From 7a2f0d1fda966e88d0a1aec6b881b4b1bcfaeff0 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Mon, 14 Mar 2011 12:08:58 -0400 Subject: [PATCH] SQL syntax for FKEY --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index 06bd2f6131..cdfd9c98b9 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -48,7 +48,7 @@ CREATE TABLE vandelay.queue ( name TEXT NOT NULL, complete BOOL NOT NULL DEFAULT FALSE, queue_type TEXT NOT NULL DEFAULT 'bib' CHECK (queue_type IN ('bib','authority')), - match_set INT REFERENCES vandelay.match_set (id) DEFERRABLE INITIALLY DEFERRED ON UPDATE CASCADE ON DELETE SET NULL, + match_set INT REFERENCES vandelay.match_set (id) ON UPDATE CASCADE ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, CONSTRAINT vand_queue_name_once_per_owner_const UNIQUE (owner,name,queue_type) ); -- 2.11.0