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

(-)a/installer/data/mysql/atomicupdate/bug_23439.perl (+7 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{ALTER TABLE accountlines CHANGE COLUMN accounttype accounttype varchar(80) default NULL});
4
5
    SetVersion( $DBversion );
6
    print "Upgrade to $DBversion done (Bug 23539 - accountlines.accounttype should match authorised_values.authorised_value in size)\n";
7
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2611-2617 CREATE TABLE `accountlines` ( Link Here
2611
  `date` date default NULL,
2611
  `date` date default NULL,
2612
  `amount` decimal(28,6) default NULL,
2612
  `amount` decimal(28,6) default NULL,
2613
  `description` LONGTEXT,
2613
  `description` LONGTEXT,
2614
  `accounttype` varchar(16) default NULL,
2614
  `accounttype` varchar(80) default NULL,
2615
  `status` varchar(16) default NULL,
2615
  `status` varchar(16) default NULL,
2616
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2616
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2617
  `amountoutstanding` decimal(28,6) default NULL,
2617
  `amountoutstanding` decimal(28,6) default NULL,
2618
- 

Return to bug 23539