Attachment 106902 Details for Bug 16371 – Bug 16371: Add database updates

[patch] Bug 16371: Add database updates

Bug-16371-Add-database-updates.patch (text/plain), 2.88 KB, created by Katrin Fischer on 2020-07-15 06:35:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2020-07-15 06:35:20 UTC

Size: 2.88 KB

patch

obsolete

>From f86ec28d1138168ae9796d2727e88c82ebe548cd Mon Sep 17 00:00:00 2001
>From: Emmi Takkinen <emmi.takkinen@outlook.com>
>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 <david@davidnind.com>
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> .../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

Actions: View | Diff | Splinter Review

Attachments on bug 16371: 102515 | 102516 | 102517 | 102969 | 103019 | 103329 | 103330 | 103331 | 103332 | 103333 | 103334 | 103732 | 103973 | 103974 | 103975 | 103976 | 103977 | 103978 | 103979 | 106818 | 106819 | 106820 | 106858 | 106859 | 106860 | 106861 | 106862 | 106863 | 106864 | 106865 | 106866 | 106867 | 106868 | 106894 | 106895 | 106896 | 106897 | 106898 | 106899 | 106900 | 106901 | 106902 | 106903 | 108097 | 108098 | 108160 | 108163