MFvM3aLg

1CREATE TABLE IF NOT EXISTS `team_entrant` (
2  `entrant_number` tinyint(4) NOT NULL,
3  `qualifying_position` tinyint(4) NOT NULL,
4  `qualifying_time` time(3) NOT NULL,
5  `grid_position` tinyint(4) DEFAULT NULL,
6  `best_race_time` datetime DEFAULT NULL,
7  `final_position` tinyint(4) DEFAULT NULL,
8  `dnf_reason` varchar(45) DEFAULT NULL,
9  `team_id` int(11) NOT NULL,
10  `competition_year` date NOT NULL,
11  PRIMARY KEY (`entrant_number`),
12  KEY `fk_team_entrant_team1_idx` (`team_id`),
13  CONSTRAINT `fk_team_entrant_team1` FOREIGN KEY (`team_id`) REFERENCES `team` (`team_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15	
16CREATE TABLE IF NOT EXISTS `entrant_drivers` (
17  `entrant_number` tinyint(4) NOT NULL,
18  `competition_year` date NOT NULL,
19  `driver_id` int(11) NOT NULL,
20  PRIMARY KEY (`entrant_number`,`competition_year`,`driver_id`),
21  CONSTRAINT `ed_entrant_fk` FOREIGN KEY (`entrant_number`) REFERENCES `team_entrant` (`entrant_number`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23	
24ALTER table entrant_drivers ADD CONSTRAINT ed_comp_year_fk FOREIGN KEY (competition_year) REFERENCES team_entrant(competition_year);
25	
26-- Dumping structure for table 99_lemans_db1.driver
27CREATE TABLE IF NOT EXISTS `driver` (
28  `driver_id` int(11) NOT NULL,
29  `driver_name` varchar(64) NOT NULL,
30  `driver_nationality` varchar(32) NOT NULL,
31  `driver_birth_day` date NOT NULL,
32  `driver_best_previous_finish_class` varchar(8) DEFAULT NULL,
33  `driver_best_previous_finish_position` tinyint(4) DEFAULT NULL,
34  `team_entrant_id` int(11) NOT NULL,
35  PRIMARY KEY (`driver_id`,`team_entrant_id`),
36  KEY `fk_driver_team_entrant1_idx` (`team_entrant_id`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;