From e06741affc4606d0a15772525e235b9a650c6873 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 5 Dec 2011 15:41:32 -0500 Subject: [PATCH] acq vandelay : schema removal of temp column Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 1 - Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql | 3 --- 2 files changed, 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index 8e7107ecd9..4b6c52577b 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -52,7 +52,6 @@ CREATE TABLE vandelay.queue ( 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) ON UPDATE CASCADE ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, - temp BOOL DEFAULT FALSE, CONSTRAINT vand_queue_name_once_per_owner_const UNIQUE (owner,name,queue_type) ); 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 7fff3bfd00..f38904717b 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,13 +12,10 @@ ALTER TABLE acq.acq_lineitem_history ADD COLUMN queued_record BIGINT REFERENCES vandelay.queued_bib_record (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; -ALTER TABLE vandelay.queue ADD COLUMN temp BOOL DEFAULT FALSE; - COMMIT; /* UNDO SQL 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 COLUMN temp; */ -- 2.11.0