From 4a2dbd38c65c45c5511dc4739160816902b863cf 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 --- installer/data/mysql/atomicupdate/bug_14180.pl | 15 +++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 16 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..3c30995d57 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14180.pl @@ -0,0 +1,15 @@ +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 7295744c4c..d90139f4a4 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -53,6 +53,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.30.2