From 6f3ffe31008bcb73c10bde3894913d2ff55027a9 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 13 Mar 2013 14:45:22 -0400 Subject: [PATCH] Add CASCADE and DEFERRABLE clauses to fkey Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z3950_credentials.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 6f63a17723..1c9323f8c6 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -517,7 +517,7 @@ CREATE TABLE config.z3950_attr ( CREATE TABLE config.z3950_source_credentials ( id SERIAL PRIMARY KEY, owner INTEGER NOT NULL, -- REFERENCES actor.org_unit(id), - source TEXT NOT NULL REFERENCES config.z3950_source(name), + source TEXT NOT NULL REFERENCES config.z3950_source(name) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, username TEXT, password TEXT, CONSTRAINT czsc_source_once_per_lib UNIQUE (source, owner) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z3950_credentials.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z3950_credentials.sql index ca6d3646e3..37a21c03f0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z3950_credentials.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z3950_credentials.sql @@ -4,7 +4,7 @@ BEGIN; CREATE TABLE config.z3950_source_credentials ( id SERIAL PRIMARY KEY, owner INTEGER NOT NULL REFERENCES actor.org_unit(id), - source TEXT NOT NULL REFERENCES config.z3950_source(name), + source TEXT NOT NULL REFERENCES config.z3950_source(name) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, -- do some Z servers require a username but no password or vice versa? username TEXT, password TEXT, -- 2.43.2