From de9e68fdc2993caf1728e05cd08c08d9ae006c22 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 17 Feb 2022 12:55:20 +0000 Subject: [PATCH] Bug 30108: Database revision, adding new preference Test plan: Run upgrade or new install. Signed-off-by: Marcel de Rooy Signed-off-by: Lucas Gass Signed-off-by: Tomas Cohen Arazi Signed-off-by: Fridolin Somers --- installer/data/mysql/atomicupdate/bug_30108.pl | 14 ++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 15 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_30108.pl diff --git a/installer/data/mysql/atomicupdate/bug_30108.pl b/installer/data/mysql/atomicupdate/bug_30108.pl new file mode 100755 index 0000000000..039d5ce0c8 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_30108.pl @@ -0,0 +1,14 @@ +use Modern::Perl; + +return { + bug_number => 30108, + description => "Add preference OPACMandatoryHoldDates", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + $dbh->do(q{ +INSERT IGNORE INTO systempreferences (`variable`, `value`, `options`, `explanation`, `type` ) VALUES +('OPACMandatoryHoldDates', '', '|start|end|both', 'Define which hold dates are required on OPAC reserve form', 'Choice') + }); + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index c6d0fd49e9..aab22108b0 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -438,6 +438,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('OPACLocalCoverImages','0','1','Display local cover images on OPAC search and details pages.','YesNo'), ('OpacLocationBranchToDisplay','holding','holding|home|both','In the OPAC, under location show which branch for Location in the record details.','Choice'), ('OpacLocationOnDetail','holding','holding|home|both|column','In the OPAC detail, display the shelving location on its own column or under a library columns.', 'Choice'), +('OPACMandatoryHoldDates', '', '|start|end|both', 'Define which hold dates are required on OPAC reserve form', 'Choice'), ('OpacMaintenance','0','','If ON, enables maintenance warning in OPAC','YesNo'), ('OpacMaintenanceNotice','','','A user-defined block of HTML to appear on screen when OpacMaintenace is enabled','Textarea'), ('OpacMaxItemsToDisplay','50','','Max items to display at the OPAC on a biblio detail','Integer'), -- 2.39.5