php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Return to Bug #77138
Patch update_schema_for_5.7.patch revision 2018-11-11 07:45 UTC by zach at zrhoffman dot net
Patch update_schema_for_5.5.patch revision 2018-11-11 07:45 UTC by zach at zrhoffman dot net

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

Patch version 2018-11-11 07:45 UTC

Return to Bug #77138 | Download this patch
Patch Revisions:

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:
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Tue Dec 10 07:01:24 2019 UTC