1 -- remove unused org unit setting for self checkout interface
5 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
7 DELETE FROM actor.org_unit_setting WHERE name = 'circ.selfcheck.require_patron_password';
9 DELETE FROM config.org_unit_setting_type WHERE name = 'circ.selfcheck.require_patron_password';
11 DELETE FROM config.org_unit_setting_type_log WHERE field_name = 'circ.selfcheck.require_patron_password';
13 DELETE FROM permission.usr_perm_map WHERE perm IN (SELECT id FROM permission.perm_list WHERE code = 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password');
15 DELETE FROM permission.grp_perm_map WHERE perm IN (SELECT id FROM permission.perm_list WHERE code = 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password');
17 DELETE FROM permission.perm_list WHERE code = 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password';