@@ -, +, @@ --- .../atomicupdate/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 --- a/installer/data/mysql/atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql +++ a/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'; --