Attachment 81781 Details for Bug 21730 – Bug 21730: Add missing PA_CLASS authorized values categories

[patch] Bug 21730: Add missing PA_CLASS authorized values categories

Bug-21730-Add-missing-PACLASS-authorized-values-ca.patch (text/plain), 1.71 KB, created by Jonathan Druart on 2018-10-31 20:44:29 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2018-10-31 20:44:29 UTC

Size: 1.71 KB

patch

obsolete

>From 06fe8b41479e61eac608bdc237d6ce090d25c38a Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 31 Oct 2018 17:42:43 -0300
>Subject: [PATCH] Bug 21730: Add missing PA_CLASS authorized values categories
>
>PA_CLASS is missing from the list of AV category
>
>Test plan:
>Execute the update DB entry
>Confirm that you now have PA_CLASS in the AV category list
>---
> installer/data/mysql/atomicupdate/bug_21730.perl | 9 +++++++++
> installer/data/mysql/mandatory/auth_val_cat.sql  | 1 +
> 2 files changed, 10 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_21730.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21730.perl b/installer/data/mysql/atomicupdate/bug_21730.perl
>new file mode 100644
>index 0000000000..7470a74867
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_21730.perl
>@@ -0,0 +1,9 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    # you can use $dbh here like:
>+
>+    $dbh->do( "INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('AV_CLASS');");
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 21730: Add new authorised value category AV_CLASS)\n";
>+}
>diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql
>index 4ab8c0e04e..812f7af675 100644
>--- a/installer/data/mysql/mandatory/auth_val_cat.sql
>+++ b/installer/data/mysql/mandatory/auth_val_cat.sql
>@@ -16,6 +16,7 @@ INSERT IGNORE INTO authorised_value_categories( category_name )
>     ('TERM'),
>     ('ITEMTYPECAT'),
>     ('PAYMENT_TYPE'),
>+    ('AV_CLASS'),
>     ('ROADTYPE');
> 
> INSERT IGNORE INTO authorised_value_categories( category_name )
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21730: 81781 | 81988 | 82574 | 82588