diff options
Diffstat (limited to 'dbinit/init.sql')
| -rw-r--r-- | dbinit/init.sql | 4 |
1 files changed, 1 insertions, 3 deletions
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, |