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

(-)a/installer/data/mysql/atomicupdate/bug_24101_1_add_auth_values.perl (+17 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    # Add authorised value category "CHECKOUT_TYPE"
5
    $dbh->do( q|
6
        INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('CHECKOUT_TYPE');
7
    | );
8
9
    # Add authorised value "ONSITE" under "CHECKOUT_TYPE" category
10
    $dbh->do( q|
11
        INSERT IGNORE INTO authorised_values(category, authorised_value, lib, lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', 'On-site checkout', 'On-site checkout');
12
    | );
13
14
    # Always end with this (adjust the bug info)
15
    SetVersion( $DBversion );
16
    print "Upgrade to $DBversion done (Bug 24101 - Add authorised value for checkout types )\n";
17
}
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 / +4 lines)
Lines 65-67 INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES Link Here
65
-- For Claims returned
65
-- For Claims returned
66
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
66
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
67
    ('RETURN_CLAIM_RESOLUTION');
67
    ('RETURN_CLAIM_RESOLUTION');
68
- 
68
69
-- For Circulation types
70
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
71
    ('CHECKOUT_TYPE');

Return to bug 25037