aboutsummaryrefslogtreecommitdiff
path: root/dbinit
diff options
context:
space:
mode:
authorlonkaars <loek@pipeframe.xyz>2023-03-24 10:36:25 +0100
committerlonkaars <loek@pipeframe.xyz>2023-03-24 10:36:25 +0100
commitb0d6eed61e0dba7e2765b98e4ac170d880279773 (patch)
tree3853cced8b94da58ca6c62bbc3b4bed79bda8078 /dbinit
parent5b77503edf15972e146f5afc518de194dad7f42d (diff)
fix typos
Diffstat (limited to 'dbinit')
-rw-r--r--dbinit/init.sql16
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);