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 disabled BOOLEAN NOT NULL DEFAULT FALSE,
12 CONSTRAINT pgtde_once_per_org UNIQUE (org, grp)
15 ALTER TABLE permission.grp_tree_display_entry
16 ADD COLUMN parent integer REFERENCES permission.grp_tree_display_entry (id)
17 DEFERRABLE INITIALLY DEFERRED;