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 2703-2709 CREATE TABLE `accountlines` ( Link Here
2703
  `date` date default NULL,
2703
  `date` date default NULL,
2704
  `amount` decimal(28,6) default NULL,
2704
  `amount` decimal(28,6) default NULL,
2705
  `description` LONGTEXT,
2705
  `description` LONGTEXT,
2706
  `dispute` LONGTEXT,
2707
  `accounttype` varchar(5) default NULL,
2706
  `accounttype` varchar(5) default NULL,
2708
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2707
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2709
  `amountoutstanding` decimal(28,6) default NULL,
2708
  `amountoutstanding` decimal(28,6) default NULL,
2710
- 

Return to bug 20777