From e455d6173ed6e9c05b7907bf98ffe89c2df23f01 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 12 Dec 2016 16:03:01 +0100 Subject: [PATCH] Bug 14146: Add the new pref CumulativeRestrictionPeriods Sponsored-by: Orex Digital --- installer/data/mysql/atomicupdate/bug_14146.sql | 2 ++ installer/data/mysql/sysprefs.sql | 1 + 2 files changed, 3 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_14146.sql diff --git a/installer/data/mysql/atomicupdate/bug_14146.sql b/installer/data/mysql/atomicupdate/bug_14146.sql new file mode 100644 index 0000000..24cc49f --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14146.sql @@ -0,0 +1,2 @@ +INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) +VALUES ('CumulativeRestrictionPeriods', 0, NULL, 'Cumulate the restriction periods instead of keeping the highest', 'YesNo'); diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index ef83c3d..7b0cf18 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -109,6 +109,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ConfirmFutureHolds','0','','Number of days for confirming future holds','Integer'), ('ConsiderOnSiteCheckoutsAsNormalCheckouts','1',NULL,'Consider on-site checkouts as normal checkouts','YesNo'), ('CronjobLog','0',NULL,'If ON, log information from cron jobs.','YesNo'), +('CumulativeRestrictionPeriods',0,NULL,'Cumulate the restriction periods instead of keeping the highest','YesNo'), ('CurrencyFormat','US','US|FR|CH','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|dmydot','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)','Choice'), ('DebugLevel','2','0|1|2','Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','Choice'), -- 2.9.3