From d9bd67f6ccce5ce4e3f40e73d0af0641c846b26a Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Fri, 26 Jan 2024 17:34:40 +0000 Subject: [PATCH] Bug 14180: Add AlwaysLoadCheckoutsTable system preference Signed-off-by: Kelly Signed-off-by: Tomas Cohen Arazi Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_14180.pl | 18 ++++++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 19 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_14180.pl diff --git a/installer/data/mysql/atomicupdate/bug_14180.pl b/installer/data/mysql/atomicupdate/bug_14180.pl new file mode 100755 index 0000000000..dffa605038 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14180.pl @@ -0,0 +1,18 @@ +use Modern::Perl; + +return { + bug_number => "14180", + description => "Add system preference AlwaysLoadCheckoutsTable", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + # Do you stuffs here + $dbh->do( + q{ + INSERT IGNORE INTO systempreferences (`variable`,`value`,`options`,`explanation`,`type`) + VALUES ('AlwaysLoadCheckoutsTable','0','','Option to always load the checkout table','YesNo') + } + ); + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index cdc0f16e2f..6bb9f56893 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -55,6 +55,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('alphabet','A B C D E F G H I J K L M N O P Q R S T U V W X Y Z',NULL,'Alphabet than can be expanded into browse links, e.g. on Home > Patrons','free'), ('AlternateHoldingsField','',NULL,'The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).','free'), ('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','free'), +('AlwaysLoadCheckoutsTable','0','','Option to always load the checkout table','Yes/No'), ('AmazonAssocTag','','','See: http://aws.amazon.com','free'), ('AmazonCoverImages','0','','Display Cover Images in staff interface from Amazon Web Services','YesNo'), ('AmazonLocale','US','US|CA|DE|FR|IN|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'), -- 2.39.5