From 0a02a0d21def81a2e6ff64cfae612afa40a7a332 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 1 Dec 2011 17:10:20 -0500 Subject: [PATCH] ACQ Vandeley : vandelay DB upgrade script changes for temp queues Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql | 3 +++ 1 file changed, 3 insertions(+) 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 7f18b31c37..fe9bf56b50 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 @@ -17,6 +17,8 @@ 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; /* UNDO SQL @@ -25,4 +27,5 @@ 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