Attachment 42344 Details for Bug 14717 – Bug 14171: Update borrowers date fields

[patch] Bug 14171: Update borrowers date fields

Bug-14171-Update-borrowers-date-fields.patch (text/plain), 1.21 KB, created by Jonathan Druart on 2015-09-03 15:10:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2015-09-03 15:10:08 UTC

Size: 1.21 KB

patch

obsolete

>From 2cbb7af77220fb7aef50d30453828521cc1c6cfc Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 3 Sep 2015 16:07:42 +0100
>Subject: [PATCH] Bug 14171: Update borrowers date fields
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>
>http://bugs.koha-community.org/show_bug.cgi?id=14717
>---
> .../atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql | 5 +++++
> 1 file changed, 5 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 0000000..50219b9
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_14717_get_rid_of_0000-00-00_borrowers_table.sql
>@@ -0,0 +1,5 @@
>+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.1.0

Actions: View | Diff | Splinter Review

Attachments on bug 14717: 41871 | 42331 | 42342 | 42343 | 42344 | 42356 | 42357 | 42358