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

(-)a/installer/data/mysql/atomicupdate/bug_22516.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    if ( column_exists( 'accountlines', 'lastincrement' ) ) {
5
        $dbh->do("ALTER TABLE `accountlines` DROP COLUMN `lastincrement`");
6
    }
7
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug 22516 - Drop deprecated accountlines.lastincrement field)\n";
10
}
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 2678-2684 CREATE TABLE `accountlines` ( Link Here
2678
  `accounttype` varchar(5) default NULL,
2678
  `accounttype` varchar(5) default NULL,
2679
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2679
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2680
  `amountoutstanding` decimal(28,6) default NULL,
2680
  `amountoutstanding` decimal(28,6) default NULL,
2681
  `lastincrement` decimal(28,6) default NULL,
2682
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2681
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2683
  `note` MEDIUMTEXT NULL default NULL,
2682
  `note` MEDIUMTEXT NULL default NULL,
2684
  `manager_id` int(11) NULL,
2683
  `manager_id` int(11) NULL,
2685
- 

Return to bug 22516