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

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

Return to bug 22521