From 3d061015b87318fd2ae202e5a7343f59a2776025 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Tue, 24 May 2016 18:12:11 -0300 Subject: [PATCH] Bug 16573: change created_on type - atomic update This patch change 'created_on' virtualshelves column to datetime type To test: 1) Apply the patch 2) Run updatedatabase.pl 3) Verify type of 'created_on' column Signed-off-by: Mark Tompsett --- installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql diff --git a/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql b/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql new file mode 100644 index 0000000..8b258fc --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql @@ -0,0 +1 @@ +ALTER TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL; -- 2.7.4