Attachment 21197 Details for Bug 9761 – Bug 9761: dbrev for ConfirmFutureHolds

[patch] Bug 9761: dbrev for ConfirmFutureHolds

Bug-9761-dbrev-for-ConfirmFutureHolds.patch (text/plain), 2.73 KB, created by Marcel de Rooy on 2013-09-18 12:21:54 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2013-09-18 12:21:54 UTC

Size: 2.73 KB

patch

obsolete

>From 6215b09de9af471f2020763e6bc55ac7b38cf157 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Thu, 7 Mar 2013 14:57:25 +0100
>Subject: [PATCH] Bug 9761: dbrev for ConfirmFutureHolds
>Content-Type: text/plain; charset=utf-8
>
>Db rev for new pref ConfirmFutureHolds.
>
>Test plan:
>Run [your server]/cgi-bin/koha/installer/install.pl?step=3&op=updatestructure
>Optionally, run a new install to test sysprefs.sql.
>Or:
>Edit sysprefs.sql, leave at least the last few lines including the new one.
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
>---
> installer/data/mysql/sysprefs.sql      |    1 +
> installer/data/mysql/updatedatabase.pl |    8 ++++++++
> 2 files changed, 9 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index 4b9c492..4b0f364 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -76,6 +76,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('CircAutocompl','1',NULL,'If ON, autocompletion is enabled for the Circulation input','YesNo'),
> ('CircAutoPrintQuickSlip','1',NULL,'Choose what should happen when an empty barcode field is submitted in circulation: Display a print quick slip window or Clear the screen.','YesNo'),
> ('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
>+('ConfirmFutureHolds','0','','Number of days for confirming future holds','Integer'),
> ('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),
> ('CurrencyFormat','US','US|FR','Determines the display format of currencies. eg: \'36000\' is displayed as \'360 000,00\'  in \'FR\' or \'360,000.00\'  in \'US\'.','Choice'),
> ('dateformat','us','metric|us|iso','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd)','Choice'),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 31f494a..28412a5 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -7139,6 +7139,14 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion ($DBversion);
> }
> 
>+$DBversion ="3.13.00.XXX";
>+if ( CheckVersion($DBversion) ) {
>+    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('ConfirmFutureHolds','0','Number of days for confirming future holds','','Integer');");
>+    print "Upgrade to $DBversion done (Bug 9761: Add ConfirmFutureHolds pref)\n";
>+    SetVersion($DBversion);
>+}
>+
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.7.7.6

Actions: View | Diff | Splinter Review

Attachments on bug 9761: 15932 | 15933 | 15951 | 15980 | 15981 | 15982 | 18609 | 18610 | 18611 | 18612 | 18613 | 18614 | 18615 | 21193 | 21197 | 21198 | 21208 | 21209 | 21227 | 21280