Open-ILS/src/sql/Pg/upgrade/1010.remove_unused_self_checkout_setting.sql

   1 -- remove unused org unit setting for self checkout interface
   2
   3 BEGIN;
   4
   5 SELECT evergreen.upgrade_deps_block_check('1010', :eg_version);
   6
   7 DELETE FROM actor.org_unit_setting WHERE name = 'circ.selfcheck.require_patron_password';
   8
   9 DELETE FROM config.org_unit_setting_type WHERE name = 'circ.selfcheck.require_patron_password';
  10
  11 DELETE FROM config.org_unit_setting_type_log WHERE field_name = 'circ.selfcheck.require_patron_password';
  12
  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');
  14
  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');
  16
  17 DELETE FROM permission.perm_list WHERE code = 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password';
  18
  19 COMMIT;