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

(-)a/installer/data/mysql/atomicupdate/bug_22512.perl (+18 lines)
Line 0 Link Here
1
$DBversion = 'XXX';    # will be replaced by the RM
2
if ( CheckVersion($DBversion) ) {
3
4
    if ( !column_exists( 'accountlines', 'status' ) ) {
5
        $dbh->do(
6
            qq{
7
            ALTER TABLE `accountlines`
8
            ADD
9
              `status` varchar(16) DEFAULT NULL
10
            AFTER
11
              `accounttype`
12
          }
13
        );
14
    }
15
16
    SetVersion($DBversion);
17
    print "Upgrade to $DBversion done (Bug 22512 - Add status to accountlines)\n";
18
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2676-2681 CREATE TABLE `accountlines` ( Link Here
2676
  `amount` decimal(28,6) default NULL,
2676
  `amount` decimal(28,6) default NULL,
2677
  `description` LONGTEXT,
2677
  `description` LONGTEXT,
2678
  `accounttype` varchar(5) default NULL,
2678
  `accounttype` varchar(5) default NULL,
2679
  `status` varchar(16) default NULL,
2679
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2680
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2680
  `amountoutstanding` decimal(28,6) default NULL,
2681
  `amountoutstanding` decimal(28,6) default NULL,
2681
  `lastincrement` decimal(28,6) default NULL,
2682
  `lastincrement` decimal(28,6) default NULL,
2682
- 

Return to bug 22512