From 33f7699fcb40dd6fb5cae40cbfeef858c9058348 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 --- ...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 9a5cb2e0a8..212d646589 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -679,6 +679,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.20.1