From c1f9b43b2f1c6d45fed3557633af4e86548013eb Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sun, 17 Jun 2018 23:04:47 +0200
Subject: MySQL 5.7 compatibility fixes

---
 import/01b_indexes.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'import')

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
-- 
cgit v1.2.3