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 all instances from permission.usr_perm_map too
   8 DELETE FROM permission.usr_perm_map where perm in
   9 (select id from permission.perm_list where code='SET_CIRC_MISSING');
  10
  11 --delete from permission.perm_list
  12 DELETE FROM permission.perm_list where code='SET_CIRC_MISSING';
  13
  14 COMMIT;