aboutsummaryrefslogtreecommitdiff
path: root/dbinit/init.sql
diff options
context:
space:
mode:
authorSean <sb.groenenboom@student.avans.nl>2023-03-24 10:48:20 +0100
committerSean <sb.groenenboom@student.avans.nl>2023-03-24 10:48:20 +0100
commita78c8ac520cb6e3a81125dad91306d37d56b294b (patch)
tree6dfe737ba50f0aab8bc968199c1d79e0ed4718cd /dbinit/init.sql
parent00ba27d694948c9dc4b1dc77311cc214f4e30751 (diff)
parentb0d6eed61e0dba7e2765b98e4ac170d880279773 (diff)
Merge remote-tracking branch 'upstream/master'
Diffstat (limited to 'dbinit/init.sql')
-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);