From 073386b76b45a8f5402c49bb4b046dce3e9ffe1e 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 Signed-off-by: Jonathan Druart --- 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.8.1