Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql

   1 BEGIN;
   2
   3 --delete all instances from permission.grp_perm_map first
   4 DELETE FROM permission.grp_perm_map where perm in
   5 (select id from permission.perm_list where code='SET_CIRC_MISSING');
   6
   7 --delete from permission.perm_list
   8 DELETE FROM permission.perm_list where code='SET_CIRC_MISSING';
   9
  10 COMMIT;