From 19c624fb0be862a4a005bb74f8f86cc085942f08 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 script 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 Signed-off-by: Ben Shum --- .../src/sql/Pg/upgrade/0868.schema.all_hold_behind_desk.sql | 4 ++++ 1 file changed, 4 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); -- 2.43.2