|
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 |
} |