diff options
| -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 |