Attachment 96532 Details for Bug 24263 – Bug 24263: DB changes

[patch] Bug 24263: DB changes

Bug-24263-DB-changes.patch (text/plain), 1.01 KB, created by Martin Renvoize (ashimema) on 2019-12-20 17:43:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-12-20 17:43:58 UTC

Size: 1.01 KB

patch

obsolete

>From 03bfd6576fc92842b16c3174bf3964bfbe709f9c Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 18 Dec 2019 14:08:34 +0100
>Subject: [PATCH] Bug 24263: DB changes
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> installer/data/mysql/atomicupdate/bug_24215.perl | 10 ++++++++++
> 1 file changed, 10 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24215.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24215.perl b/installer/data/mysql/atomicupdate/bug_24215.perl
>new file mode 100644
>index 0000000000..61a1915baf
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24215.perl
>@@ -0,0 +1,10 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do( q|
>+        UPDATE borowers SET relationship = NULL
>+        WHERE relationship = ""
>+    |);
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 24215 - Replace relationship with NULL when "")\n";
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 24263: 96418 | 96419 | 96420 | 96531 | 96532 | 96533 | 96989 | 96990 | 96991 | 96992