Attachment 42358 Details for Bug 14717 – [PASSED QA] Bug 14171: Update borrowers date fields

[patch] [PASSED QA] Bug 14171: Update borrowers date fields

PASSED-QA-Bug-14171-Update-borrowers-date-fields.patch (text/plain), 1.28 KB, created by Katrin Fischer on 2015-09-03 21:22:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2015-09-03 21:22:08 UTC

Size: 1.28 KB

patch

obsolete

>From 76fd76720dd43ada17e32d9f28384c0450e7f0d3 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] [PASSED QA] 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
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> .../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
>
>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..8b73b30
>--- /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';
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

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