From 795daa5b6b6374316d1e12b1f045953a953fa3b3 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 6 Mar 2018 15:56:09 -0500 Subject: [PATCH] LP#1744756 Group tree display SQL WIP Signed-off-by: Bill Erickson --- .../sql/Pg/upgrade/XXXX.schema.perm-group-display.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.perm-group-display.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.perm-group-display.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.perm-group-display.sql new file mode 100644 index 0000000000..09b6f1d867 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.perm-group-display.sql @@ -0,0 +1,17 @@ + +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +CREATE TABLE permission.grp_tree_display_entry ( + id SERIAL PRIMARY KEY, + org INTEGER NOT NULL REFERENCES actor.org_unit (id) + DEFERRABLE INITIALLY DEFERRED, + grp INTEGER NOT NULL REFERENCES permission.grp_tree (id) + DEFERRABLE INITIALLY DEFERRED, + parent INTEGER REFERENCES permission.grp_tree (id) + DEFERRABLE INITIALLY DEFERRED +); + +COMMIT; + -- 2.11.0