diff options
author | lonkaars <loek@pipeframe.xyz> | 2023-03-24 10:36:25 +0100 |
---|---|---|
committer | lonkaars <loek@pipeframe.xyz> | 2023-03-24 10:36:25 +0100 |
commit | b0d6eed61e0dba7e2765b98e4ac170d880279773 (patch) | |
tree | 3853cced8b94da58ca6c62bbc3b4bed79bda8078 | |
parent | 5b77503edf15972e146f5afc518de194dad7f42d (diff) |
fix typos
-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); |