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 <mtompset@hotmail.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>

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 (file)
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;