diff options
| author | emkael <emkael@tlen.pl> | 2018-06-17 23:04:47 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2018-06-17 23:04:47 +0200 |
| commit | c1f9b43b2f1c6d45fed3557633af4e86548013eb (patch) | |
| tree | bceedc3adeaa72c7b1d0a1aaaeb3ce076b1f6e81 /import | |
| parent | 6725aa67abb732dd831d98d6320d0e1a757089f7 (diff) | |
MySQL 5.7 compatibility fixes
Diffstat (limited to 'import')
| -rw-r--r-- | import/01b_indexes.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/import/01b_indexes.sql b/import/01b_indexes.sql index d3ca687..67808ee 100644 --- a/import/01b_indexes.sql +++ b/import/01b_indexes.sql @@ -37,10 +37,12 @@ ALTER TABLE pitStops ALTER TABLE qualifying ADD INDEX position (position); +-- Default value compatibility +ALTER TABLE `races` CHANGE `date` `date` DATE NULL DEFAULT NULL; -- Indexes for table races ALTER TABLE races ADD INDEX year (year), - ADD INDEX date (date); + ADD INDEX `date` (`date`); -- Indexes for table results ALTER TABLE results |