From 65d5ea680d0a5490374b108f009737c45084598f Mon Sep 17 00:00:00 2001 From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4> Date: Wed, 17 Mar 2010 13:42:42 +0000 Subject: [PATCH] syntax error in fkey cascade git-svn-id: svn://svn.open-ils.org/ILS/trunk@15877 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index b0a62d4e5a..a82b4a487c 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -477,7 +477,7 @@ CREATE TABLE acq.lineitem_alert_text ( CREATE TABLE acq.lineitem_note ( id SERIAL PRIMARY KEY, - lineitem INT NOT NULL REFERENCES acq.lineitem (id) ON CASCADE DELETE DEFERRABLE INITIALLY DEFERRED, + lineitem INT NOT NULL REFERENCES acq.lineitem (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, creator INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, editor INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), @@ -493,7 +493,7 @@ CREATE INDEX li_note_editor_idx ON acq.lineitem_note ( editor ); CREATE TABLE acq.lineitem_detail ( id BIGSERIAL PRIMARY KEY, - lineitem INT NOT NULL REFERENCES acq.lineitem (id) ON CASCADE DELETE DEFERRABLE INITIALLY DEFERRED, + lineitem INT NOT NULL REFERENCES acq.lineitem (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, fund INT REFERENCES acq.fund (id) DEFERRABLE INITIALLY DEFERRED, fund_debit INT REFERENCES acq.fund_debit (id) DEFERRABLE INITIALLY DEFERRED, eg_copy_id BIGINT REFERENCES asset.copy (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, @@ -547,7 +547,7 @@ CREATE TABLE acq.lineitem_local_attr_definition ( CREATE TABLE acq.lineitem_attr ( id BIGSERIAL PRIMARY KEY, definition BIGINT NOT NULL, - lineitem BIGINT NOT NULL REFERENCES acq.lineitem (id) ON CASCADE DELETE DEFERRABLE INITIALLY DEFERRED, + lineitem BIGINT NOT NULL REFERENCES acq.lineitem (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, attr_type TEXT NOT NULL, attr_name TEXT NOT NULL, attr_value TEXT NOT NULL @@ -607,7 +607,7 @@ CREATE TABLE acq.distribution_formula_application ( formula INT NOT NULL REFERENCES acq.distribution_formula(id) DEFERRABLE INITIALLY DEFERRED, lineitem INT NOT NULL - REFERENCES acq.lineitem(id) ON CASCADE DELETE DEFERRABLE INITIALLY DEFERRED + REFERENCES acq.lineitem(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED ); CREATE INDEX acqdfa_df_idx -- 2.11.0