Bugzilla – Attachment 147205 Details for
Bug 33004
Add VENDOR_TYPE to default authorised value categories
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 33004: Add VENDOR_TYPE to default authorised value categories
Bug-33004-Add-VENDORTYPE-to-default-authorised-val.patch (text/plain), 2.23 KB, created by
Jonathan Druart
on 2023-02-23 09:36:39 UTC
(
hide
)
Description:
Bug 33004: Add VENDOR_TYPE to default authorised value categories
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2023-02-23 09:36:39 UTC
Size:
2.23 KB
patch
obsolete
>From 2b84144f8d84c8470359928729efdc9bc96399a4 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer.83@web.de> >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 <oleonard@myacpl.org> > >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >--- > .../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 00000000000..a30cd9e7baf >--- /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 fc11f7ac9a7..62873465395 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.25.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 33004
:
146912
|
146928
| 147205