From 82c93eda8966002c849dd9496114639f47de93a4 Mon Sep 17 00:00:00 2001 From: James Fournie Date: Thu, 31 May 2012 09:42:57 -0700 Subject: [PATCH] Addresses LP#1007003 - auditor table not updated when action.hold_request is updated --- Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql index 8329a410a1..880b4ff4c6 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql @@ -6654,7 +6654,9 @@ ALTER TABLE action.hold_request ADD CONSTRAINT sms_check CHECK ( OR sms_carrier IS NOT NULL -- and implied sms_notify IS NOT NULL ); - +ALTER TABLE auditor.action_hold_request_history ADD COLUMN sms_notify TEXT; +ALTER TABLE auditor.action_hold_request_history ADD COLUMN sms_carrier INT; +ALTER TABLE auditor.action_hold_request_history ADD COLUMN current_shelf_lib INT; -- set the value for current_shelf_lib on existing shelved holds UPDATE action.hold_request -- 2.11.0