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

(-)a/installer/data/mysql/atomicupdate/bug_27069.perl (-1 / +17 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do(q{
5
        UPDATE circulation_rules
6
        SET
7
            rule_value = CASE
8
                WHEN rule_value='0' THEN 'not_allowed'
9
                WHEN rule_value='1' THEN 'from_home_library'
10
                WHEN rule_value='2' THEN 'from_any_library'
11
                WHEN rule_value='3' THEN 'from_local_hold_group'
12
            END
13
        WHERE rule_name='holdallowed' AND rule_value >= 0 AND rule_value <= 3;
14
    });
15
16
    NewVersion( $DBversion, 27069, "Change holdallowed values from numbers to strings");
17
}

Return to bug 27069