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

(-)a/installer/data/mysql/atomicupdate/bug_20777_accountlines_dispute.perl (+13 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
4
    if ( column_exists( 'accountlines', 'dispute' ) ) {
5
        $dbh->do(q{
6
            ALTER TABLE `accountlines`
7
                DROP COLUMN `dispute`
8
        });
9
    }
10
11
    SetVersion( $DBversion );
12
    print "Upgrade to $DBversion done (Bug 20777 - Remove unused field accountlines.dispute)\n";
13
}
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 2679-2685 CREATE TABLE `accountlines` ( Link Here
2679
  `date` date default NULL,
2679
  `date` date default NULL,
2680
  `amount` decimal(28,6) default NULL,
2680
  `amount` decimal(28,6) default NULL,
2681
  `description` LONGTEXT,
2681
  `description` LONGTEXT,
2682
  `dispute` LONGTEXT,
2683
  `accounttype` varchar(5) default NULL,
2682
  `accounttype` varchar(5) default NULL,
2684
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2683
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2685
  `amountoutstanding` decimal(28,6) default NULL,
2684
  `amountoutstanding` decimal(28,6) default NULL,
2686
- 

Return to bug 20777