-- BEGIN TABLE code
DROP TABLE IF EXISTS code;
CREATE TABLE `code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(100) DEFAULT NULL,
`code_info` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
-- Inserting 3 rows into code
-- Insert batch #1
INSERT INTO code (id, code, code_info) VALUES
(1, 'BS', 'BS INFO'),
(2, 'FB', 'FB INFO'),
(3, 'GF', 'GF INFO');
-- END TABLE code
-- BEGIN TABLE desk
DROP TABLE IF EXISTS desk;
CREATE TABLE `desk` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- Inserting 4 rows into desk
-- Insert batch #1
INSERT INTO desk (id, description) VALUES
(1, 'Hand game'),
(2, 'Leg game'),
(3, 'Hand game'),
(4, 'Gockey stick game');
-- END TABLE desk
-- BEGIN TABLE games
DROP TABLE IF EXISTS games;
CREATE TABLE `games` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`game` varchar(100) DEFAULT NULL,
`code` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- Inserting 4 rows into games
-- Insert batch #1
INSERT INTO games (id, game, code) VALUES
(1, 'Baseball', 'BS'),
(2, 'Football', 'FB'),
(3, 'Tennis', NULL),
(4, 'Golf', 'GF');
-- END TABLE games