From 4e7817cf9ba1958b622fc72505b24341705955ee Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 13 Dec 2017 16:56:38 -0300 Subject: [PATCH] Bug 19804: Add new DB column issuingrules.suspension_chargeperiod Signed-off-by: Hugo Agud --- installer/data/mysql/atomicupdate/bug_19804.perl | 12 ++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 13 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_19804.perl diff --git a/installer/data/mysql/atomicupdate/bug_19804.perl b/installer/data/mysql/atomicupdate/bug_19804.perl new file mode 100644 index 0000000..76f2122 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_19804.perl @@ -0,0 +1,12 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + + if( !column_exists( 'issuingrules', 'suspension_chargeperiod' ) ) { + $dbh->do(q| + ALTER TABLE issuingrules ADD COLUMN suspension_chargeperiod int(11) DEFAULT '1' AFTER maxsuspensiondays; + |); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 19804: Add issuingrules.suspension_chargeperiod)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f031503..bc6c348 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -865,6 +865,7 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules `fine` decimal(28,6) default NULL, -- fine amount `finedays` int(11) default NULL, -- suspension in days `maxsuspensiondays` int(11) default NULL, -- max suspension days + `suspension_chargeperiod` int(11) default '1', -- how often the finedays is charged `firstremind` int(11) default NULL, -- fine grace period `chargeperiod` int(11) default NULL, -- how often the fine amount is charged `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period -- 2.1.4