@@ -, +, @@ table it's updating --- installer/data/mysql/db_revs/220600064.pl | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) --- a/installer/data/mysql/db_revs/220600064.pl +++ a/installer/data/mysql/db_revs/220600064.pl @@ -12,11 +12,17 @@ return { VALUES ('OPACAllowUserToChangeBranch','','Pending, In-Transit, Suspended','Allow users to change the library to pick up a hold for these statuses:','multiple'); }); + my ($value) = $dbh->selectrow_array(q{ + SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END + FROM systempreferences + WHERE variable='OPACInTransitHoldPickupLocationChange' + }); + $dbh->do(q{ UPDATE systempreferences - SET value=(SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END FROM systempreferences WHERE variable='OPACInTransitHoldPickupLocationChange') + SET value=(?) WHERE variable='OPACAllowUserToChangeBranch' - }); + },undef,$value); say $out "Added new system preference 'OPACAllowUserToChangeBranch'"; --