3 INSERT INTO config.upgrade_log (version) VALUES ('0447'); -- gmc
5 -- undo 0077.data.holds_local_avail_and_override.sql
6 DELETE FROM actor.org_unit_setting WHERE name IN (
7 'circ.holds.alert_if_local_avail',
8 'circ.holds.deny_if_local_avail'
10 DELETE FROM config.org_unit_setting_type WHERE name IN (
11 'circ.holds.alert_if_local_avail',
12 'circ.holds.deny_if_local_avail'
14 DELETE FROM permission.usr_perm_map WHERE perm = (
15 SELECT id FROM permission.perm_list WHERE code = 'HOLD_LOCAL_AVAIL_OVERRIDE'
17 DELETE FROM permission.grp_perm_map WHERE perm = (
18 SELECT id FROM permission.perm_list WHERE code = 'HOLD_LOCAL_AVAIL_OVERRIDE'
20 DELETE FROM permission.perm_list WHERE code = 'HOLD_LOCAL_AVAIL_OVERRIDE';