From 4ec31e41884354d88d51e1ad4b3573bbb2dd42ec Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 23 Jun 2017 11:53:46 -0400 Subject: [PATCH] LP#1286340 - acq_purchase_order_lifecycle may not exist. Signed-off-by: Chris Sharp --- .../src/sql/Pg/upgrade/XXXX.schema.delete_acq_purchase_orders.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.delete_acq_purchase_orders.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.delete_acq_purchase_orders.sql index 36764b7a2e..1d4f8cae6e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.delete_acq_purchase_orders.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.delete_acq_purchase_orders.sql @@ -7,9 +7,9 @@ ALTER TABLE acq.lineitem ADD COLUMN deleted BOOLEAN NOT NULL DEFAULT FALSE; ALTER TABLE acq.lineitem_detail ADD COLUMN deleted BOOLEAN NOT NULL DEFAULT FALSE; ALTER TABLE acq.po_item ADD COLUMN deleted BOOLEAN NOT NULL DEFAULT FALSE; ALTER TABLE acq.acq_purchase_order_history ADD COLUMN deleted BOOLEAN NOT NULL; -ALTER TABLE acq.acq_purchase_order_lifecycle ADD COLUMN deleted BOOLEAN NOT NULL; +ALTER TABLE IF EXISTS acq.acq_purchase_order_lifecycle ADD COLUMN deleted BOOLEAN NOT NULL; ALTER TABLE acq.acq_lineitem_history ADD COLUMN deleted BOOLEAN NOT NULL; -ALTER TABLE acq.acq_lineitem_lifecycle ADD COLUMN deleted BOOLEAN NOT NULL; +ALTER TABLE IF EXISTS acq.acq_lineitem_lifecycle ADD COLUMN deleted BOOLEAN NOT NULL; -- just in case the upgraded DB has these auditor tables, change them too ALTER TABLE IF EXISTS auditor.acq_lineitem_detail_history ADD COLUMN deleted BOOLEAN NOT NULL; ALTER TABLE IF EXISTS auditor.acq_lineitem_detail_lifecycle ADD COLUMN deleted BOOLEAN NOT NULL; -- 2.11.0