Bugzilla – Attachment 30639 Details for
Bug 8337
System preferences for longoverdue cron
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8337 - Added the sysprefs to the database scripts. modified: installer/data/mysql/sysprefs.sql modified: installer/data/mysql/updatedatabase.pl
Bug-8337---Added-the-sysprefs-to-the-database-scri.patch (text/plain), 3.02 KB, created by
Maxime Beaulieu
on 2014-08-08 18:24:45 UTC
(
hide
)
Description:
Bug 8337 - Added the sysprefs to the database scripts. modified: installer/data/mysql/sysprefs.sql modified: installer/data/mysql/updatedatabase.pl
Filename:
MIME Type:
Creator:
Maxime Beaulieu
Created:
2014-08-08 18:24:45 UTC
Size:
3.02 KB
patch
obsolete
>From d17e5e896dd6e8e9348125104af41bbf46d41d9e Mon Sep 17 00:00:00 2001 >From: mbeaulieu <mbeaulieu@inlibro.com> >Date: Fri, 8 Aug 2014 14:22:58 -0400 >Subject: [PATCH] Bug 8337 - Added the sysprefs to the database scripts. > modified: installer/data/mysql/sysprefs.sql modified: > installer/data/mysql/updatedatabase.pl > >--- > installer/data/mysql/sysprefs.sql | 5 ++++- > installer/data/mysql/updatedatabase.pl | 9 +++++++++ > 2 files changed, 13 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 03a3f1e..7496272 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -441,5 +441,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'), > ('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'), > ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'), >-('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo') >+('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'), >+('defaultlongoverduechargevalue', NULL, NULL, "Charge a lost item to the borrower's account when the LOST value of the item changes to n.", 'integer'); >+('defaultlongoverduedays', NULL, NULL, "Set the LOST value of an item when the item has been overdue for more than n days.", 'integer'); >+('defaultlongoverduelostvalue', NULL, NULL, "Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.", 'integer'); > ; >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 3f1af57..68c5dba 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8603,9 +8603,18 @@ if ( CheckVersion($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "XXX"; >+if( CheckVersion($DBversion) ){ >+ $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultlongoverduechargevalue','Charge a lost item to the borrower account when the LOST value of the item changes to n', 'integer')"); >+ $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultlongoverduelostvalue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.', 'integer')"); >+ $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('defaultlongoverduedays', 'Set the LOST value of an item when the item has been overdue for more than n days.', 'integer')"); >+ print "Upgrade to $DBversion done (System preferences for longoverdue cron)\n"; >+ SetVersion($DBversion); >+} > =head1 FUNCTIONS > > =head2 TableExists($table) >+a > > =cut > >-- >1.7.9.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 8337
:
10569
|
11389
|
16687
|
16810
|
17393
|
30639
|
30944
|
32288
|
32289
|
32290
|
32291
|
32292
|
33802