From 3d853ec529e766a6f38eb83e7f09ca47f2687c04 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 30 Nov 2011 14:54:41 -0500 Subject: [PATCH] ACQ Vandelay : schema schanges; upgrade script Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 2 ++ .../XXXX.schema.acq-vandelay-integration.sql | 28 ++++++++++++++++++++++ 2 files changed, 30 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 8765c4a659..f70a80fe48 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -486,6 +486,8 @@ CREATE TABLE acq.lineitem ( estimated_unit_price NUMERIC, claim_policy INT REFERENCES acq.claim_policy DEFERRABLE INITIALLY DEFERRED, + queued_record BIGINT REFERENCES vandelay.queued_bib_record (id) + ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; CONSTRAINT picklist_or_po CHECK (picklist IS NOT NULL OR purchase_order IS NOT NULL) ); CREATE INDEX li_po_idx ON acq.lineitem (purchase_order); 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 new file mode 100644 index 0000000000..7f18b31c37 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-vandelay-integration.sql @@ -0,0 +1,28 @@ +-- Evergreen DB patch XXXX.schema.acq-vandelay-integration.sql +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE acq.lineitem ADD COLUMN queued_record BIGINT + REFERENCES vandelay.queued_bib_record (id) + ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; + +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])); + +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 CONSTRAINT queue_queue_type_check; +ALTER TABLE vandelay.queue ADD CONSTRAINT queue_queue_type_check CHECK (queue_type = ANY (ARRAY['bib'::text, 'authority'::text])); +*/ -- 2.11.0