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

(-)a/installer/data/mysql/atomicupdate/bug_21730.perl (+9 lines)
Line 0 Link Here
1 
$DBversion = 'XXX';  # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    # you can use $dbh here like:
4 

            

            

              5
              
    $dbh->do( "INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('AV_CLASS');");

            

            

              6
              

            

            

              7
              
    SetVersion( $DBversion );

            

            

              8
              
    print "Upgrade to $DBversion done (Bug 21730: Add new authorised value category AV_CLASS)\n";

            

            

              9
              
}

            



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




  

    
      
            Lines 16-21
          INSERT IGNORE INTO authorised_value_categories( category_name )
      
      
        Link Here
      
    
  

        

          16
          
    ('TERM'),

          16
          
    ('TERM'),

        

        

          17
          
    ('ITEMTYPECAT'),

          17
          
    ('ITEMTYPECAT'),

        

        

          18
          
    ('PAYMENT_TYPE'),

          18
          
    ('PAYMENT_TYPE'),

        

            

              
              
              19
              
    ('AV_CLASS'),

            

        

          19
          
    ('ROADTYPE');

          20
          
    ('ROADTYPE');

        

        

          20
          

          21
          

        

        

          21
          
INSERT IGNORE INTO authorised_value_categories( category_name )

          22
          
INSERT IGNORE INTO authorised_value_categories( category_name )

        

            

              22
              
- 

              
              
            






  

  Return to bug 21730