From f683335a2e73268dec6b3b02b47c50df43efafd6 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 7 Feb 2018 11:58:02 -0300 Subject: [PATCH] Bug 20175: [sql_modes] (follow-up) Set a correct default value for club_enrollments.date_created From comment 6: """ Can't recreate database, when creating table structure, I got: there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause I am on mysql 5.5.59, which is still default in jessie, more timestamp columns are possible from mysql 5.6.5: https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-5.html """ Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice Signed-off-by: Jonathan Druart (cherry picked from commit ffd7fa3a068ff60976b1cf6f94fd2a48ae2d619c) Signed-off-by: Fridolin Somers --- .../atomicupdate/bug_xxxxx_club_enrollments.date_created.sql | 2 +- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_xxxxx_club_enrollments.date_created.sql b/installer/data/mysql/atomicupdate/bug_xxxxx_club_enrollments.date_created.sql index d22f41edc5..5bf3520936 100644 --- a/installer/data/mysql/atomicupdate/bug_xxxxx_club_enrollments.date_created.sql +++ b/installer/data/mysql/atomicupdate/bug_xxxxx_club_enrollments.date_created.sql @@ -1 +1 @@ -ALTER TABLE club_enrollments MODIFY date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP; +ALTER TABLE club_enrollments MODIFY date_created timestamp NOT NULL; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 580175f6f5..bd97c913d5 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4056,7 +4056,7 @@ CREATE TABLE IF NOT EXISTS club_enrollments ( borrowernumber int(11) NOT NULL, date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, date_canceled timestamp NULL DEFAULT NULL, - date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + date_created timestamp NULL DEFAULT NULL, date_updated timestamp NULL DEFAULT NULL, branchcode varchar(10) NULL DEFAULT NULL, PRIMARY KEY (id), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 7d1aa9ef3e..ff7378c45b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -14199,7 +14199,7 @@ if( CheckVersion( $DBversion ) ) { borrowernumber int(11) NOT NULL, date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, date_canceled timestamp NULL DEFAULT NULL, - date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + date_created timestamp NULL DEFAULT NULL, date_updated timestamp NULL DEFAULT NULL, branchcode varchar(10) NULL DEFAULT NULL, PRIMARY KEY (id), -- 2.39.5