From b584a14eb4b759643d9f95db81e0160d810923d2 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 5 Dec 2011 11:39:29 -0500 Subject: [PATCH] acq vandelay : schema changes to remove bib_type change Signed-off-by: Bill Erickson --- .../src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql | 7 ------- 1 file changed, 7 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql index fe9bf56b50..7fff3bfd00 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql @@ -12,11 +12,6 @@ ALTER TABLE acq.acq_lineitem_history ADD COLUMN queued_record BIGINT REFERENCES vandelay.queued_bib_record (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; --- add support for 'acq' vandelay queue types -ALTER TABLE vandelay.queue DROP CONSTRAINT queue_queue_type_check; -ALTER TABLE vandelay.queue ADD CONSTRAINT queue_queue_type_check - CHECK (queue_type = ANY (ARRAY['bib'::text, 'authority'::text, 'acq'::text])); - ALTER TABLE vandelay.queue ADD COLUMN temp BOOL DEFAULT FALSE; COMMIT; @@ -25,7 +20,5 @@ COMMIT; UPDATE acq.lineitem SET queued_record = NULL; ALTER TABLE acq.lineitem DROP COLUMN queued_record; ALTER TABLE acq.acq_lineitem_history DROP COLUMN queued_record; -ALTER TABLE vandelay.queue DROP CONSTRAINT queue_queue_type_check; -ALTER TABLE vandelay.queue ADD CONSTRAINT queue_queue_type_check CHECK (queue_type = ANY (ARRAY['bib'::text, 'authority'::text])); ALTER TABLE vandelay.queue drop COLUMN temp; */ -- 2.11.0