From 24e23a4e1dd478c138418a4d7b921e9e6c1992fc 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 --- .../data/mysql/atomicupdate/bug-16573-change-created_on-column.sql | 2 ++ 1 file changed, 2 insertions(+) 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..5bb7e3d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql @@ -0,0 +1,2 @@ +ALTER TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL; + -- 2.7.4