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

(-)a/installer/data/mysql/atomicupdate/bug_22435.perl (+8 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do( "INSERT IGNORE INTO account_offset_types () VALUES ( 'CREATE' )" );
4 
    $dbh->do( "UPDATE account_offsets SET type = 'CREATE' WHERE type != 'OVERDUE_INCREASE' AND type != 'OVERDUE_DECREASE' AND ( debit_id IS NULL OR credit_id IS NULL)" );
5 

            

            

              6
              
    # Always end with this (adjust the bug info)

            

            

              7
              
    NewVersion( $DBversion, 22435, "Update offsets to CREATE type");

            

            

              8
              
}

            



(-)a/installer/data/mysql/mandatory/account_offset_types.sql
      (-1 / +1 lines)




  

    
      
            Lines 1-4
          
      
      
        Link Here
      
    
  

        

          1
          
INSERT INTO account_offset_types ( type ) VALUES

          1
          
INSERT INTO account_offset_types ( type ) VALUES

        

            

              
              
              2
              
('CREATE'),

            

        

          2
          
('Writeoff'),

          3
          
('Writeoff'),

        

        

          3
          
('Payment'),

          4
          
('Payment'),

        

        

          4
          
('Purchase'),

          5
          
('Purchase'),

        

            

              5
              
- 

              
              
            






  

  Return to bug 22435