From d163d0ee7a83ffd482efbbaed4019491c0c3868e Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
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 <mtompset@hotmail.com>
---
 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