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

(-)a/installer/data/mysql/atomicupdate/bug_21753.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    if( column_exists( 'issuingrules', 'chargename' ) ) {
4
        $dbh->do( "ALTER TABLE issuingrules DROP chargename" );
5
    }
6
7
    # Always end with this (adjust the bug info)
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug 21753: Drop chargename from issuingrules )\n";
10
}
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 855-861 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
855
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
855
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
856
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period
856
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period
857
  `accountsent` int(11) default NULL, -- not used? always NULL
857
  `accountsent` int(11) default NULL, -- not used? always NULL
858
  `chargename` varchar(100) default NULL, -- not used? always NULL
859
  `maxissueqty` int(4) default NULL, -- total number of checkouts allowed
858
  `maxissueqty` int(4) default NULL, -- total number of checkouts allowed
860
  `maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed
859
  `maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed
861
  `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit
860
  `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit
862
- 

Return to bug 21753