Open-ILS/src/sql/Pg/upgrade/0592.data.ACQ_INVOICE_REOPEN-perm.sql

   1 --Upgrade script for lp818311.
   2
   3 BEGIN;
   4
   5 SELECT evergreen.upgrade_deps_block_check('0592', :eg_version);
   6
   7 INSERT INTO permission.perm_list ( id, code, description ) VALUES
   8  ( 512, 'ACQ_INVOICE_REOPEN', oils_i18n_gettext( 512,
   9     'Allows a user to reopen an Acquisitions invoice', 'ppl', 'description' ));
  10
  11 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
  12         SELECT
  13                 pgt.id, perm.id, aout.depth, TRUE
  14         FROM
  15                 permission.grp_tree pgt,
  16                 permission.perm_list perm,
  17                 actor.org_unit_type aout
  18         WHERE
  19                 pgt.name = 'Acquisitions Administrator' AND
  20                 aout.name = 'Consortium' AND
  21                 perm.code = 'ACQ_INVOICE_REOPEN';
  22
  23 COMMIT;