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

(-)a/installer/data/mysql/atomicupdate/bug_24338.perl (+12 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do(qq{
4 
        INSERT INTO
5 
          authorised_values (category,authorised_value,lib, lib_opac)
6 
        VALUES
7 
          ('PAYMENT_TYPE','CASH','Cash','Cash')
8 
    });
9 

            

            

              10
              
    SetVersion( $DBversion );

            

            

              11
              
    print "Upgrade to $DBversion done (Bug 24338 - Add 'CASH' to default 'PAYMENT_TYPE')\n";

            

            

              12
              
}

            



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




  

    
      
            Lines 3-6
          INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('
      
      
        Link Here
      
    
  

        

          3
          
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP00','Cash via SIP2','Cash');

          3
          
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP00','Cash via SIP2','Cash');

        

        

          4
          
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP01','Visa via SIP2','Visa');

          4
          
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP01','Visa via SIP2','Visa');

        

        

          5
          
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP02','Creditcard via SIP2','Creditcard');

          5
          
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP02','Creditcard via SIP2','Creditcard');

        

            

              
              
              6
              
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','CASH','Cash','Cash');

            

        

          6
          
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');

          7
          
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');

        

            

              7
              
- 

              
              
            






  

  Return to bug 24338