From 5b77503edf15972e146f5afc518de194dad7f42d Mon Sep 17 00:00:00 2001 From: lonkaars Date: Wed, 8 Mar 2023 10:54:00 +0100 Subject: update database schema (remove membercol and unique from racenum) --- dbinit/demo.sql | 34 +++++++++++++++++----------------- dbinit/init.sql | 4 +--- 2 files changed, 18 insertions(+), 20 deletions(-) (limited to 'dbinit') diff --git a/dbinit/demo.sql b/dbinit/demo.sql index 7404e97..b6da468 100644 --- a/dbinit/demo.sql +++ b/dbinit/demo.sql @@ -30,11 +30,11 @@ insert into `formula1`.`specialposition` (`type`) values ("Disqualified"), ("Did not finish"); -insert into `formula1`.`member` (`firstName`, `middleName`, `lastName`, `functionID`, `membercol`) values - ("Mario", "", "Mario", 1, "TODO"), - ("Luigi", "", "Mario", 1, "TODO"), - ("Peach", "", "Toadstool", 1, "TODO"), - ("Loek", "Le", "Blansch", 2, "TODO"); +insert into `formula1`.`member` (`firstName`, `middleName`, `lastName`, `functionID`) values + ("Mario", "", "Mario", 1), + ("Luigi", "", "Mario", 1), + ("Peach", "", "Toadstool", 1), + ("Loek", "Le", "Blansch", 2); insert into `formula1`.`racedate` (`calanderID`, `raceTypeID`, `week`, `date`) values (2, 2, 4, "2011-01-29"), @@ -66,22 +66,22 @@ insert into `formula1`.`racedatecircuit` (`raceDateID`, `circuitID`) values (3, 1), (4, 1); -insert into `formula1`.`teamsmember` (`teamsID`, `memberID`, `teamsMembercol`) values - (1, 1, "TODO"), - (1, 2, "TODO"), - (2, 3, "TODO"), - (2, 4, "TODO"); +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, 3, 3), - (2, 4, 2), - (2, 5, 4), - (3, 6, 1), - (3, 7, 2), - (4, 8, 4), - (4, 9, 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), diff --git a/dbinit/init.sql b/dbinit/init.sql index 221cac8..6d38581 100644 --- a/dbinit/init.sql +++ b/dbinit/init.sql @@ -29,7 +29,6 @@ create table if not exists `formula1`.`member` ( `lastName` varchar(45) null default null, `photo` mediumblob null default null, `functionID` int null default null, - `membercol` varchar(45) null default null, primary key (`ID`), unique index `ID_UNIQUE` (`ID` asc) visible, index `functionID_idx` (`functionID` asc) visible, @@ -104,7 +103,7 @@ create table if not exists `formula1`.`race` ( `fastestLapID` int null default null, primary key (`ID`), unique index `ID_UNIQUE` (`ID` asc) visible, - unique index `raceNumber_UNIQUE` (`raceNumber` asc) visible, + index `raceNumber_idx` (`raceNumber` asc) visible, index `raceDateID_idx` (`raceDateID` asc) visible, index `fastestLapID_idx` (`fastestLapID` asc) visible, constraint `fastestLapID` @@ -191,7 +190,6 @@ create table if not exists `formula1`.`teamsmember` ( `ID` int not null auto_increment, `teamsID` int null default null, `memberID` int null default null, - `teamsMembercol` varchar(45) null default null, primary key (`ID`), unique index `ID_UNIQUE` (`ID` asc) visible, index `teamsID_idx` (`teamsID` asc) visible, -- cgit v1.2.3