@@ -, +, @@ --- ...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 --- a/installer/data/mysql/atomicupdate/bug_31333-add_suggestionPatronCategoryExceptions_syspref.pl +++ a/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') }); + }, +}; --- a/installer/data/mysql/mandatory/sysprefs.sql +++ a/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'), --