diff options
author | Sean <sb.groenenboom@student.avans.nl> | 2023-03-24 10:48:20 +0100 |
---|---|---|
committer | Sean <sb.groenenboom@student.avans.nl> | 2023-03-24 10:48:20 +0100 |
commit | a78c8ac520cb6e3a81125dad91306d37d56b294b (patch) | |
tree | 6dfe737ba50f0aab8bc968199c1d79e0ed4718cd /dbinit | |
parent | 00ba27d694948c9dc4b1dc77311cc214f4e30751 (diff) | |
parent | b0d6eed61e0dba7e2765b98e4ac170d880279773 (diff) |
Merge remote-tracking branch 'upstream/master'
Diffstat (limited to 'dbinit')
-rw-r--r-- | dbinit/init.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/dbinit/init.sql b/dbinit/init.sql index 6d38581..e39fc6e 100644 --- a/dbinit/init.sql +++ b/dbinit/init.sql @@ -80,15 +80,15 @@ create table if not exists `formula1`.`racetype` ( create table if not exists `formula1`.`racedate` ( `ID` int not null auto_increment, - `calanderID` int null default null, + `calendarID` int null default null, `raceTypeID` int null default null, `week` int not null, `date` date not null, primary key (`ID`), - index `calanderID_idx` (`calanderID` asc) visible, + index `calendarID_idx` (`calendarID` asc) visible, index `raceTypeID_idx` (`raceTypeID` asc) visible, - constraint `calanderID` - foreign key (`calanderID`) + constraint `calendarID` + foreign key (`calendarID`) references `formula1`.`calendar` (`ID`) on update cascade, constraint `raceTypeID` @@ -175,14 +175,14 @@ create table if not exists `formula1`.`racedatecircuit` ( create table if not exists `formula1`.`teams` ( `ID` int not null auto_increment, - `calanderID` int null default null, + `calendarID` int null default null, `teamNumber` int null default null, `teamName` varchar(45) null default null, primary key (`ID`), unique index `ID_UNIQUE` (`ID` asc) visible, - index `calanderID_idx` (`calanderID` asc) visible, - constraint `calanderID2` - foreign key (`calanderID`) + index `calendarID_idx` (`calendarID` asc) visible, + constraint `calendarID2` + foreign key (`calendarID`) references `formula1`.`calendar` (`ID`) on update cascade); |