From ce68d9b7fd14f9959f18039b63ad3e7bea44213e 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 MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit 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 Signed-off-by: Kyle M Hall (cherry picked from commit 162b9015d9bfb23200d1bddff69be9384a33463b) Signed-off-by: Frédéric Demians --- .../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 0000000000..8b258fca54 --- /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.39.2