6u79q2rr

1CREATE TABLE IF NOT EXISTS `player` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `firstname` varchar(50) COLLATE utf8_czech_ci NOT NULL,
4  `lastname` varchar(100) COLLATE utf8_czech_ci NOT NULL,
5  PRIMARY KEY (`id`),
6) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
7
8
9CREATE TABLE IF NOT EXISTS `player_team` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `team_id` int(11) NOT NULL,
12  `player_id` int(11) NOT NULL,
13  PRIMARY KEY (`id`),
14  KEY `team_id` (`team_id`,`player_id`),
15  KEY `player_id` (`player_id`)
16) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
17
18
19CREATE TABLE IF NOT EXISTS `team` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
22  PRIMARY KEY (`id`),
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=19 ;