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

(-)a/installer/data/mysql/atomicupdate/bug_22516.perl (+10 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 

            

            

              4
              
    if ( column_exists( 'accountlines', 'lastincrement' ) ) {

            

            

              5
              
        $dbh->do("ALTER TABLE `accountlines` DROP COLUMN `lastincrement`");

            

            

              6
              
    }

            

            

              7
              

            

            

              8
              
    SetVersion( $DBversion );

            

            

              9
              
    print "Upgrade to $DBversion done (Bug 22516 - Drop deprecated accountlines.lastincrement field)\n";

            

            

              10
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-2 lines)




  

    
      
            Lines 2678-2684
          CREATE TABLE `accountlines` (
      
      
        Link Here
      
    
  

        

          2678
          
  `accounttype` varchar(5) default NULL,

          2678
          
  `accounttype` varchar(5) default NULL,

        

        

          2679
          
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE

          2679
          
  `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE

        

        

          2680
          
  `amountoutstanding` decimal(28,6) default NULL,

          2680
          
  `amountoutstanding` decimal(28,6) default NULL,

        

            

              2681
              
  `lastincrement` decimal(28,6) default NULL,

              
              
            

        

          2682
          
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

          2681
          
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

        

        

          2683
          
  `note` MEDIUMTEXT NULL default NULL,

          2682
          
  `note` MEDIUMTEXT NULL default NULL,

        

        

          2684
          
  `manager_id` int(11) NULL,

          2683
          
  `manager_id` int(11) NULL,

        

            

              2685
              
- 

              
              
            






  

  Return to bug 22516