From c1ba7ec23c1003f8d49863ebb746854b24ab61f0 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 24 Mar 2017 12:18:44 -0400 Subject: [PATCH] LP#1616170 - attempt to fix "magical statuses" problem. Signed-off-by: Chris Sharp --- .../upgrade/XXXX.schema.copy_status_attributes.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_status_attributes.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_status_attributes.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_status_attributes.sql new file mode 100644 index 0000000000..191f2ede42 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_status_attributes.sql @@ -0,0 +1,22 @@ +BEGIN; + +-- add the new columns +ALTER TABLE config.copy_status ADD COLUMN staff_editable BOOLEAN NOT NULL DEFAULT TRUE; +ALTER TABLE config.copy_status ADD COLUMN block_mark_item_damaged BOOLEAN NOT NULL DEFAULT FALSE; +ALTER TABLE config.copy_status ADD COLUMN block_mark_item_action BOOLEAN NOT NULL DEFAULT FALSE; + +-- update existing statuses +UPDATE config.copy_status SET + staff_editable = FALSE, + block_mark_item_damaged = TRUE, + block_mark_item_action = TRUE +WHERE name IN ( + 'Checked out', + 'Lost', + 'In transit', + 'On holds shelf', + 'Long Overdue', + 'Canceled Transit' +); + +COMMIT; -- 2.11.0