Attachment #28197 for bug #12230

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

Lines 1146-1151 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
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




    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)
- 

Return to bug 12230

Lines 8465-8470 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
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	-