From ed3a70e8d137c8a12f22e175b5cf675baed638c9 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 6 Mar 2018 16:01:10 -0500 Subject: [PATCH] LP#1744756 Group tree display SQL WIP Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.perm-group-display.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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 index 09b6f1d867..227d6e95d7 100644 --- 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 @@ -10,7 +10,8 @@ CREATE TABLE permission.grp_tree_display_entry ( grp INTEGER NOT NULL REFERENCES permission.grp_tree (id) DEFERRABLE INITIALLY DEFERRED, parent INTEGER REFERENCES permission.grp_tree (id) - DEFERRABLE INITIALLY DEFERRED + DEFERRABLE INITIALLY DEFERRED, + CONSTRAINT pgtde_once_per_org UNIQUE (org, grp) ); COMMIT; -- 2.11.0