From 6eaa123c11156ef6999cfb595e15368a63735dab Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Wed, 9 Oct 2013 09:29:01 -0400 Subject: [PATCH] Make some FK constraints on config.metabib_field.id deferrable Signed-off-by: Dan Wells Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/002.schema.config.sql | 6 +++--- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 6f689224b4..bfecd9b9ca 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -239,7 +239,7 @@ $$; CREATE TABLE config.metabib_field_ts_map ( id SERIAL PRIMARY KEY, - metabib_field INT NOT NULL REFERENCES config.metabib_field (id), + metabib_field INT NOT NULL REFERENCES config.metabib_field (id) DEFERRABLE INITIALLY DEFERRED, ts_config TEXT NOT NULL REFERENCES config.ts_config_list (id), active BOOL NOT NULL DEFAULT TRUE, index_weight CHAR(1) NOT NULL DEFAULT 'C' CHECK (index_weight IN ('A','B','C','D')), @@ -256,7 +256,7 @@ $$; CREATE TABLE config.metabib_search_alias ( alias TEXT PRIMARY KEY, field_class TEXT NOT NULL REFERENCES config.metabib_class (name), - field INT REFERENCES config.metabib_field (id) + field INT REFERENCES config.metabib_field (id) DEFERRABLE INITIALLY DEFERRED ); CREATE TABLE config.non_cataloged_type ( @@ -1056,7 +1056,7 @@ $$; CREATE TABLE config.z3950_index_field_map ( id SERIAL PRIMARY KEY, label TEXT NOT NULL, -- i18n - metabib_field INTEGER REFERENCES config.metabib_field(id), + metabib_field INTEGER REFERENCES config.metabib_field(id) DEFERRABLE INITIALLY DEFERRED, record_attr TEXT REFERENCES config.record_attr_definition(name), z3950_attr INTEGER REFERENCES config.z3950_attr(id), z3950_attr_type TEXT,-- REFERENCES config.z3950_attr(name) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 9cf1ed8c04..73b30ea735 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -204,7 +204,7 @@ CREATE TRIGGER metabib_browse_entry_fti_trigger CREATE TABLE metabib.browse_entry_def_map ( id BIGSERIAL PRIMARY KEY, entry BIGINT REFERENCES metabib.browse_entry (id), - def INT REFERENCES config.metabib_field (id), + def INT REFERENCES config.metabib_field (id) DEFERRABLE INITIALLY DEFERRED, source BIGINT REFERENCES biblio.record_entry (id), authority BIGINT REFERENCES authority.record_entry (id) ON DELETE SET NULL ); -- 2.43.2