Patch update_schema_for_5.7.patch for Systems problem Bug #77138

Patch version 2018-11-11 07:45 UTC

• 2018-11-11 07:45 UTC [diff to current]

Developer: zach@zrhoffman.net

commit 4edfbbef5ebd2592f01c226943098e48b9c4a0a8
Author: zrhoffman <zach@zrhoffman.net>
Date:   Sun Nov 11 01:04:13 2018 -0600

    Update db schema for MySQL 5.7
    
    Need to disable strict SQL mode to allow for default datetimes of zero
    (e.g., '0000-00-00 00:00:00')

diff --git a/event.sql b/event.sql
index 3f70348..0318ad6 100644
--- a/event.sql
+++ b/event.sql
@@ -1,3 +1,4 @@
+SET SESSION sql_mode = '';
 #
 # Table structure for table 'phpcal'
 #
diff --git a/mirrors.sql b/mirrors.sql
index 3f1d25c..815dd87 100644
--- a/mirrors.sql
+++ b/mirrors.sql
@@ -1,3 +1,4 @@
+SET SESSION sql_mode = '';
 --
 -- Table structure for table 'mirrors'
 --
diff --git a/note.sql b/note.sql
index 5d1cea5..40e26c7 100644
--- a/note.sql
+++ b/note.sql
@@ -1,3 +1,4 @@
+SET SESSION sql_mode = '';
 /* the note table holds notes for the php manual. */
 /* TODO: there is a similar table for php-gtk's manual. it should probably be
    merged with this one. */
diff --git a/users.sql b/users.sql
index 2d6a3ae..54f9eb2 100644
--- a/users.sql
+++ b/users.sql
@@ -1,3 +1,4 @@
+SET SESSION sql_mode = '';
 /* user-related tables */
 
 /* various things that may hang off the users table in the future: