From 14f73e5f0ab1177472a81e1e390b8a5cc1b3a460 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Thu, 25 May 2023 13:07:52 -0400 Subject: [PATCH] syntax Signed-off-by: Jason Etheridge --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 6a26f47683..84586ad6e9 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -757,8 +757,8 @@ CREATE TABLE actor.org_unit_custom_tree ( CREATE TABLE actor.org_unit_custom_tree_node ( id SERIAL PRIMARY KEY, tree INTEGER REFERENCES actor.org_unit_custom_tree (id) DEFERRABLE INITIALLY DEFERRED, - org_unit INTEGER NOT NULL REFERENCES actor.org_unit (id) DEFERRABLE INITIALLY DEFERRED, - parent_node INTEGER REFERENCES actor.org_unit_custom_tree_node (id) CASCADE DEFERRABLE INITIALLY DEFERRED, + org_unit INTEGER NOT NULL REFERENCES actor.org_unit (id) DEFERRABLE INITIALLY DEFERRED, + parent_node INTEGER REFERENCES actor.org_unit_custom_tree_node (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, sibling_order INTEGER NOT NULL DEFAULT 0, CONSTRAINT aouctn_once_per_org UNIQUE (tree, org_unit) ); -- 2.11.0