Attachment 82110 Details for Bug 15836 – Bug 15836: Fix update DB entry

[patch] Bug 15836: Fix update DB entry

Bug-15836-Fix-update-DB-entry.patch (text/plain), 1.42 KB, created by Jonathan Druart on 2018-11-08 19:22:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2018-11-08 19:22:50 UTC

Size: 1.42 KB

patch

obsolete

>From 3beca3f93a39b4795cb910f5dd58785afdcec45b Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 8 Nov 2018 16:22:32 -0300
>Subject: [PATCH] Bug 15836: Fix update DB entry
>
>---
> installer/data/mysql/atomicupdate/bug_15836.perl | 7 ++++++-
> 1 file changed, 6 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_15836.perl b/installer/data/mysql/atomicupdate/bug_15836.perl
>index edfe012709..0cb485b90f 100644
>--- a/installer/data/mysql/atomicupdate/bug_15836.perl
>+++ b/installer/data/mysql/atomicupdate/bug_15836.perl
>@@ -13,6 +13,11 @@ if( CheckVersion( $DBversion ) ) {
>         |);
> 
>         $dbh->do(q|
>+            ALTER TABLE class_sort_rules
>+            ADD COLUMN split_routine varchar(30) NOT NULL default '' AFTER sort_routine,
>+            ADD COLUMN split_regex varchar(255) NOT NULL default '' AFTER split_routine
>+        |);
>+        $dbh->do(q|
>             ALTER TABLE class_sources
>             ADD COLUMN class_split_rule varchar(10) NOT NULL default ''
>             AFTER class_sort_rule
>@@ -38,5 +43,5 @@ if( CheckVersion( $DBversion ) ) {
>     }
> 
>     SetVersion( $DBversion );
>-    print "Upgrade to $DBversion done (Bug 15836 - Add class_sort_rules.split_routine and split_regex)\n";
>+    print "Upgrade to $DBversion done (Bug 15836 - Add new table class_split_rules and 2 columns 'split_routine' and 'split_regex' to class_sort_rules)\n";
> }
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 15836: 76691 | 76692 | 76693 | 76694 | 76695 | 76696 | 77061 | 77079 | 77306 | 78791 | 78793 | 78795 | 78796 | 78798 | 78799 | 79029 | 80339 | 80340 | 80341 | 80342 | 80343 | 80344 | 80345 | 80346 | 80347 | 80548 | 80549 | 80550 | 80551 | 80552 | 80553 | 80554 | 80555 | 80556 | 81033 | 81034 | 81035 | 81036 | 81037 | 81038 | 81039 | 81040 | 81041 | 81627 | 81628 | 81629 | 81630 | 81631 | 81632 | 81633 | 81634 | 81635 | 82110 | 82112 | 82113 | 82118 | 82119 | 82120 | 82289 | 82290 | 82291 | 82292 | 82293 | 82294 | 82295 | 82296 | 82297 | 82298 | 82299 | 82300 | 82301 | 82302 | 82317 | 82318 | 82319 | 82321