From 0f07cd2c1004e3ceb2c4436f9cd3542b243c18aa Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 3 Sep 2015 16:07:42 +0100 Subject: [PATCH] Bug 14171: Update borrowers date fields Signed-off-by: Jonathan Druart http://bugs.koha-community.org/show_bug.cgi?id=14717 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 69994c38a00a1199b814d823c4e20503d86b28bf) Signed-off-by: Chris Cormack --- .../bug_14717_get_rid_of_0000-00-00_borrowers_table.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql diff --git a/installer/data/mysql/atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql b/installer/data/mysql/atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql new file mode 100644 index 0000000000..8b73b30da5 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql @@ -0,0 +1,4 @@ +update borrowers set debarred = NULL where debarred = '0000-00-00'; +update borrowers set dateexpiry = NULL where dateexpiry = '0000-00-00'; +update borrowers set dateofbirth = NULL where dateofbirth = '0000-00-00'; +update borrowers set dateenrolled = NULL where dateenrolled = '0000-00-00'; -- 2.39.5