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