View | Details | Raw Unified | Return to bug 19804
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_19804.perl (+12 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
4
    if( !column_exists( 'issuingrules', 'suspension_chargeperiod' ) ) {
5
        $dbh->do(q|
6
            ALTER TABLE issuingrules ADD COLUMN suspension_chargeperiod int(11) DEFAULT '1' AFTER maxsuspensiondays;
7
        |);
8
    }
9
10
    SetVersion( $DBversion );
11
    print "Upgrade to $DBversion done (Bug 19804: Add issuingrules.suspension_chargeperiod)\n";
12
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 865-870 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
865
  `fine` decimal(28,6) default NULL, -- fine amount
865
  `fine` decimal(28,6) default NULL, -- fine amount
866
  `finedays` int(11) default NULL, -- suspension in days
866
  `finedays` int(11) default NULL, -- suspension in days
867
  `maxsuspensiondays` int(11) default NULL, -- max suspension days
867
  `maxsuspensiondays` int(11) default NULL, -- max suspension days
868
  `suspension_chargeperiod` int(11) default '1', -- how often the finedays is charged
868
  `firstremind` int(11) default NULL, -- fine grace period
869
  `firstremind` int(11) default NULL, -- fine grace period
869
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
870
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
870
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period
871
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period
871
- 

Return to bug 19804