@@ -, +, @@ $ koha-mysql kohadev > INSERT INTO circulation_rules (rule_name,rule_value) VALUES ('holdallowed', -1); > INSERT INTO circulation_rules (rule_name,rule_value) VALUES ('holdallowed', 1); > INSERT INTO circulation_rules (rule_name,rule_value) VALUES ('holdallowed', 2); > INSERT INTO circulation_rules (rule_name,rule_value) VALUES ('holdallowed', 3); > INSERT INTO circulation_rules (rule_name,rule_value) VALUES ('holdallowed', 0); > INSERT INTO circulation_rules (rule_name,rule_value) VALUES ('holdallowed', 4); $ updatedatabase > SELECT * FROM circulation_rules WHERE rule_name='holdallowed'; $ kshell k$ git diff origin/master --name-only | grep -e '\.t$' | \ xargs prove --- .../data/mysql/atomicupdate/bug_27069.perl | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_27069.perl --- a/installer/data/mysql/atomicupdate/bug_27069.perl +++ a/installer/data/mysql/atomicupdate/bug_27069.perl @@ -0,0 +1,17 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + + $dbh->do(q{ + UPDATE circulation_rules + SET + rule_value = CASE + WHEN rule_value='0' THEN 'not_allowed' + WHEN rule_value='1' THEN 'from_home_library' + WHEN rule_value='2' THEN 'from_any_library' + WHEN rule_value='3' THEN 'from_local_hold_group' + END + WHERE rule_name='holdallowed' AND rule_value >= 0 AND rule_value <= 3; + }); + + NewVersion( $DBversion, 27069, "Change holdallowed values from numbers to strings"); +} --