2 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4 CREATE TABLE permission.grp_tree_display_entry (
6 position INTEGER NOT NULL,
7 org INTEGER NOT NULL REFERENCES actor.org_unit (id)
8 DEFERRABLE INITIALLY DEFERRED,
9 grp INTEGER NOT NULL REFERENCES permission.grp_tree (id)
10 DEFERRABLE INITIALLY DEFERRED,
11 CONSTRAINT pgtde_once_per_org UNIQUE (org, grp)
14 ALTER TABLE permission.grp_tree_display_entry
15 ADD COLUMN parent integer REFERENCES permission.grp_tree_display_entry (id)
16 DEFERRABLE INITIALLY DEFERRED;
18 INSERT INTO permission.perm_list (id, code, description)
19 VALUES (609, 'MANAGE_CUSTOM_PERM_GRP_TREE', oils_i18n_gettext( 609,
20 'Allows a user to manage custom permission group lists.', 'ppl', 'description' ));