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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1146-1151 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1146
  `reservecharge` decimal(28,6) default NULL,
1146
  `reservecharge` decimal(28,6) default NULL,
1147
  `fine` decimal(28,6) default NULL, -- fine amount
1147
  `fine` decimal(28,6) default NULL, -- fine amount
1148
  `finedays` int(11) default NULL, -- suspension in days
1148
  `finedays` int(11) default NULL, -- suspension in days
1149
  `maxsuspensiondays` int(11) default NULL, -- max suspension days
1149
  `firstremind` int(11) default NULL, -- fine grace period
1150
  `firstremind` int(11) default NULL, -- fine grace period
1150
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
1151
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
1151
  `accountsent` int(11) default NULL, -- not used? always NULL
1152
  `accountsent` int(11) default NULL, -- not used? always NULL
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
Lines 8465-8470 if ( CheckVersion($DBversion) ) { Link Here
8465
    SetVersion($DBversion);
8465
    SetVersion($DBversion);
8466
}
8466
}
8467
8467
8468
$DBversion = "3.15.00.XXX";
8469
if(CheckVersion($DBversion)) {
8470
    $dbh->do(q|
8471
        ALTER TABLE issuingrules
8472
        ADD maxsuspensiondays INT(11) DEFAULT NULL AFTER finedays;
8473
    |);
8474
    print "Upgrade to $DBversion done (Bug 12230: Add new issuing rule maxsuspensiondays)\n";
8475
    SetVersion($DBversion);
8476
}
8477
8468
=head1 FUNCTIONS
8478
=head1 FUNCTIONS
8469
8479
8470
=head2 TableExists($table)
8480
=head2 TableExists($table)
8471
- 

Return to bug 12230