From eb257af76aebb79abe881575c4dbd9cbc1128ade Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Wed, 5 Mar 2014 12:24:19 -0500 Subject: [PATCH] LP#1287510 Add missing column to upgrade scripts If you come via upgrade and not a fresh 2.5 DB, you are probably missing the action.aged_hold_request.behind_desk column. Add it in a harmless way. Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/upgrade/0868.schema.all_hold_behind_desk.sql | 4 ++++ Open-ILS/src/sql/Pg/version-upgrade/2.5.2-2.5.3-upgrade-db.sql | 5 +++++ 2 files changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/0868.schema.all_hold_behind_desk.sql b/Open-ILS/src/sql/Pg/upgrade/0868.schema.all_hold_behind_desk.sql index 0a5271919e..cb463adcd4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0868.schema.all_hold_behind_desk.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0868.schema.all_hold_behind_desk.sql @@ -1,5 +1,9 @@ -- add missing behind_desk column +\qecho *** This ALTER TABLE might fail depending on your DB vintage. *** +\qecho *** It should be harmless. *** +ALTER TABLE action.aged_hold_request ADD COLUMN behind_desk BOOLEAN; + BEGIN; SELECT evergreen.upgrade_deps_block_check('0868', :eg_version); diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.5.2-2.5.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.5.2-2.5.3-upgrade-db.sql index c901c8e4b5..4c38217e6b 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.5.2-2.5.3-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.5.2-2.5.3-upgrade-db.sql @@ -1,5 +1,10 @@ --Upgrade Script for 2.5.2 to 2.5.3 \set eg_version '''2.5.3''' + +\qecho *** This ALTER TABLE might fail depending on your DB vintage. *** +\qecho *** It should be harmless. *** +ALTER TABLE action.aged_hold_request ADD COLUMN behind_desk BOOLEAN; + BEGIN; INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.5.3', :eg_version); -- 2.11.0