diff options
Diffstat (limited to 'dbinit/demo.sql')
-rw-r--r-- | dbinit/demo.sql | 93 |
1 files changed, 0 insertions, 93 deletions
diff --git a/dbinit/demo.sql b/dbinit/demo.sql deleted file mode 100644 index 70d0116..0000000 --- a/dbinit/demo.sql +++ /dev/null @@ -1,93 +0,0 @@ -insert into `formula1`.`calendar` (`year`) values - ('2010'), - ('2011'), - ('2012'), - ('2013'), - ('2014'); - -insert into `formula1`.`circuit` (`name`, `length`, `laps`) values - ("Dolphin shoals", 2, 3), - ("Maple treeway", 4, 2), - ("Moo moo meadows", 6, 1); - -insert into `formula1`.`function` (`function`) values - ("Driver"), - ("Concierge"); - -insert into `formula1`.`nationality` (`country`) values - ("Netherlands"), - ("Germany"), - ("United states of America"), - ("Japan"), - ("North Korea"), - ("Australiƫ"), - ("Gelderland zuid"); - -insert into `formula1`.`racetype` (`raceType`) values - ("Qualification"), - ("Real deal race"); - -insert into `formula1`.`specialposition` (`type`) values - ("Disqualified"), - ("Did not finish"); - -insert into `formula1`.`member` (`firstName`, `middleName`, `lastName`, `functionID`) values - ("Mario", "", "Mario", 1), - ("Carlos", "Sainz", "jr.", 1), - ("Max", "", "Verstappen", 1), - ("Loek", "Le", "Blansch", 2); - -insert into `formula1`.`racedate` (`calendarID`, `raceTypeID`, `week`, `date`) values - (2, 2, 4, "2011-01-29"), - (1, 2, 12, "2011-04-02"), - (3, 1, 28, "2011-07-25"), - (5, 1, 29, "2011-07-26"); - -insert into `formula1`.`teams` (`calendarID`, `teamNumber`, `teamName`) values - (1, 1, "Team red"), - (2, 2, "Team blue"); - -insert into `formula1`.`endposition` (`memberID`, `position`, `specialPositionID`) values - (1, 3, NULL), - (2, 2, NULL), - (3, 4, NULL), - (4, 1, NULL); - -insert into `formula1`.`fastestlap` (`memberID`) values (1), (2), (3), (4); - -insert into `formula1`.`membernationality` (`memberID`, `nationalityID`) values - (1, 1), - (2, 4), - (3, 5), - (4, 3); - -insert into `formula1`.`racedatecircuit` (`raceDateID`, `circuitID`) values - (1, 3), - (2, 2), - (3, 1), - (4, 1); - -insert into `formula1`.`teamsmember` (`teamsID`, `memberID`) values - (1, 1), - (1, 2), - (2, 3), - (2, 4); - -insert into `formula1`.`race` (`raceDateID`, `raceNumber`, `fastestLapID`) values - (1, 1, 1), - (1, 2, 2), - (2, 1, 3), - (2, 2, 2), - (2, 3, 4), - (3, 1, 1), - (3, 2, 2), - (4, 1, 4), - (4, 2, 2); - -insert into `formula1`.`endpositionrace` (`endPositionID`, `raceID`) values - (1, 2), - (3, 4), - (4, 1), - (3, 2), - (3, 3); - |