From d74d03489b62073eadc71e5c2900f2eff4458c3e Mon Sep 17 00:00:00 2001 From: Emmi Takkinen Date: Fri, 10 Jul 2020 10:20:56 +0300 Subject: [PATCH] Bug 16371: Add database updates Sponsored-by: Koha-Suomi Oy Signed-off-by: David Nind --- .../atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl | 10 ++++++++++ installer/data/mysql/sysprefs.sql | 2 +- 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl diff --git a/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl b/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl new file mode 100644 index 0000000000..d5bf79c953 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl @@ -0,0 +1,10 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # you can use $dbh here like: + # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" ); + + $dbh->do( "UPDATE systempreferences SET value = '', options = 'intranet,opac', explanation = 'Enable or disable display of Quote of the Day on the OPAC and staff interface home page', type = 'multiple' WHERE variable = 'QuoteOfTheDay'" ); + + # Always end with this (adjust the bug info) + NewVersion( $DBversion, 16371, "Bug 16371 - Quote of the Day (QOTD) for the staff interface "); +} diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index d67a02b367..464d7cdaa5 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -520,7 +520,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('QueryRegexEscapeOptions', 'escape', 'dont_escape|escape|unescape_escaped', 'Escape option for regexps delimiters in Elasicsearch queries.', 'Choice'), ('QueryStemming','1',NULL,'If ON, enables query stemming','YesNo'), ('QueryWeightFields','1',NULL,'If ON, enables field weighting','YesNo'), -('QuoteOfTheDay','0',NULL,'Enable or disable display of Quote of the Day on the OPAC home page','YesNo'), +('QuoteOfTheDay','','intranet,opac','Enable or disable display of Quote of the Day on the OPAC and staff interface home page','multiple'), ('RandomizeHoldsQueueWeight','0',NULL,'if ON, the holds queue in circulation will be randomized, either based on all location codes, or by the location codes specified in StaticHoldsQueueWeight','YesNo'), ('RecordLocalUseOnReturn','0',NULL,'If ON, statistically record returns of unissued items as local use, instead of return','YesNo'), ('RefundLostOnReturnControl','CheckinLibrary','CheckinLibrary|ItemHomeBranch|ItemHoldingBranch','If a lost item is returned, choose which branch to pick rules for refunding.','Choice'), -- 2.11.0