From 70dc8a3ebe79e4fba3cb49d067958b55c1535df1 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sat, 18 Feb 2023 11:01:54 +0000 Subject: [PATCH] Bug 33004: Add VENDOR_TYPE to default authorised value categories To test: * Go to administration > authorised values * Verify that VENDOR_TYPE doesn't show in the list * Apply patch * Run database update * Verify that VENDOR_TYPE does now appear and has a nice description (not added by this patch) * Bonus: start over and run the web installer, VENDOR_TYPE should now be already there Signed-off-by: Owen Leonard Signed-off-by: Jonathan Druart Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 0f3a82f09c530fcb0681fa70edf5168fb396d25e) Signed-off-by: Jacob O'Mara --- .../mysql/atomicupdate/bug_33004_VENDOR_TYPE_AV.pl | 12 ++++++++++++ installer/data/mysql/mandatory/auth_val_cat.sql | 3 ++- 2 files changed, 14 insertions(+), 1 deletion(-) create mode 100755 installer/data/mysql/atomicupdate/bug_33004_VENDOR_TYPE_AV.pl diff --git a/installer/data/mysql/atomicupdate/bug_33004_VENDOR_TYPE_AV.pl b/installer/data/mysql/atomicupdate/bug_33004_VENDOR_TYPE_AV.pl new file mode 100755 index 0000000000..a30cd9e7ba --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_33004_VENDOR_TYPE_AV.pl @@ -0,0 +1,12 @@ +use Modern::Perl; + +return { + bug_number => "33004", + description => "Add VENDOR_TYPE authorised value category", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + $dbh->do(q{INSERT IGNORE INTO authorised_value_categories (category_name, is_system) VALUES ('VENDOR_TYPE', 1)}); + say $out "Added new authorised value category 'VENDOR_TYPE'"; + }, +}; diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql index fc11f7ac9a..6287346539 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/installer/data/mysql/mandatory/auth_val_cat.sql @@ -19,7 +19,8 @@ INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) ('PA_CLASS', 0), ('HOLD_CANCELLATION', 0), ('ROADTYPE', 0), - ('AR_CANCELLATION', 0); + ('AR_CANCELLATION', 0), + ('VENDOR_TYPE', 1); INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES -- 2.39.5