From 031d50ddf57072272686d68b5db0f6699f01f359 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 27 Sep 2017 12:25:16 -0400 Subject: [PATCH] LP#1719726: make new FK constraint consistent The constraint fieldset_fieldset_group_fkey will now do 'ON DELETE CASCADE' regardless of whether the database was created from scratch or upgraded. Signed-off-by: Galen Charlton Signed-off-by: Mike Rylander Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/090.schema.action.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 8211b23fd3..7d06aba9fb 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -826,7 +826,7 @@ CREATE TABLE action.fieldset_group ( CREATE TABLE action.fieldset ( id SERIAL PRIMARY KEY, fieldset_group INT REFERENCES action.fieldset_group (id) - DEFERRABLE INITIALLY DEFERRED, + ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, owner INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, owning_lib INT NOT NULL REFERENCES actor.org_unit (id) -- 2.43.2