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