From d163d0ee7a83ffd482efbbaed4019491c0c3868e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 22 Jul 2016 09:51:00 +0100 Subject: [PATCH] Bug 16573: Define virtualshelves.created_on as datetime for existing installs Signed-off-by: Mark Tompsett --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 372d6e4..d221aba 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -10387,7 +10387,7 @@ $DBversion = "3.19.00.038"; if ( CheckVersion($DBversion) ) { $dbh->do(q| ALTER TABLE virtualshelves - ADD COLUMN created_on TIMESTAMP NOT NULL AFTER lastmodified + ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified |); # Set created_on = lastmodified # I would say it's better than 0000-00-00 -- 2.1.4