From 3b0151d8542c49e75f1705f6e7437ee86d6b7ffa Mon Sep 17 00:00:00 2001 From: Alex Buckley Date: Tue, 9 Aug 2022 02:01:57 +0000 Subject: [PATCH] Bug 31333: Database changes Sponsored-by: Catalyst IT, New Zealand Signed-off-by: Owen Leonard Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- ...add_suggestionPatronCategoryExceptions_syspref.pl | 12 ++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 13 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl diff --git a/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl b/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl new file mode 100755 index 0000000000..ba4a1e18cd --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl @@ -0,0 +1,12 @@ +use Modern::Perl; + +return { + bug_number => "31333", + description => "Add new suggestionPatronCategoryExceptions system preference", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + + $dbh->do(q{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('suggestionPatronCategoryExceptions', '', '', 'List the patron categories not affected by suggestion system preference if on', 'Free') }); + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 1575f9516b..9f6d066976 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -687,6 +687,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('SubscriptionHistory','simplified','simplified|full','Define the display preference for serials issue history in OPAC','Choice'), ('SubscriptionLog','1',NULL,'If ON, enables subscriptions log','YesNo'), ('suggestion','1','','If ON, enables patron suggestions feature in OPAC','YesNo'), +('suggestionPatronCategoryExceptions', '', '', 'List the patron categories not affected by suggestion system preference if on', 'Free'), ('SuspendHoldsIntranet','1','Allow holds to be suspended from the intranet.',NULL,'YesNo'), ('SuspendHoldsOpac','1','Allow holds to be suspended from the OPAC.',NULL,'YesNo'), ('SuspensionsCalendar','noSuspensionsWhenClosed','ignoreCalendar|noSuspensionsWhenClosed','Specify whether to use the Calendar in calculating suspension expiration','Choice'), -- 2.39.5