Attachment 82574 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.75 KB, created by Owen Leonard on 2018-11-21 18:39:14 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Owen Leonard

Created: 2018-11-21 18:39:14 UTC

Size: 1.75 KB

patch

obsolete

>From 7379b6f5231691aed1ddf5cdd6bdedd34b1d3afb 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
>
>Signed-off-by: Owen Leonard <oleonard@myacpl.org>
>---
> 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 0000000..cb8db7b
>--- /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 ('PA_CLASS');");
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 21730: Add new authorised value category PA_CLASS)\n";
>+}
>diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql
>index 4ab8c0e..c4ce39a 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'),
>+    ('PA_CLASS'),
>     ('ROADTYPE');
> 
> INSERT IGNORE INTO authorised_value_categories( category_name )
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

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