From 3629f7a2d0713189a3113a317662a3ed398db8db Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 12 May 2014 12:40:05 +0200 Subject: [PATCH] Bug 12230: DB changes - add issuingrules.maxsuspensiondays Signed-off-by: Paola Rossi Signed-off-by: Kyle M Hall Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 1 + installer/data/mysql/updatedatabase.pl | 10 ++++++++++ 2 files changed, 11 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a2d1800640..b46dc6adb0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1147,6 +1147,7 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules `reservecharge` decimal(28,6) default NULL, `fine` decimal(28,6) default NULL, -- fine amount `finedays` int(11) default NULL, -- suspension in days + `maxsuspensiondays` int(11) default NULL, -- max suspension days `firstremind` int(11) default NULL, -- fine grace period `chargeperiod` int(11) default NULL, -- how often the fine amount is charged `accountsent` int(11) default NULL, -- not used? always NULL diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 9b17d9fe5e..a6d5066f6e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8526,6 +8526,16 @@ if (CheckVersion($DBversion)) { SetVersion($DBversion); } +$DBversion = "3.15.00.XXX"; +if(CheckVersion($DBversion)) { + $dbh->do(q| + ALTER TABLE issuingrules + ADD maxsuspensiondays INT(11) DEFAULT NULL AFTER finedays; + |); + print "Upgrade to $DBversion done (Bug 12230: Add new issuing rule maxsuspensiondays)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 2.39.5