From 29ee813dd6f5242e2e45653cbcfba74031d84158 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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..cb8db7bb2b --- /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 4ab8c0e04e..c4ce39a634 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.11.0