From 921a19e3fb495efa5b0bc1c830e506e4ae7264c4 Mon Sep 17 00:00:00 2001 From: Jason Stephenson <jstephenson@mvlc.org> Date: Wed, 12 Oct 2011 09:38:53 -0400 Subject: [PATCH] Add upgrade script for config.copy_status.restrict_copy_delete. Adds the column to the config.copy_status table. Updates the "magical" statues (1,3,6,8) to have restrict_copy_delete set to TRUE. Signed-off-by: Jason Stephenson <jstephenson@mvlc.org> Signed-off-by: Jason Etheridge <jason@esilibrary.com> --- .../upgrade/XXXX.config.copy_status.restrict_copy_delete.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.config.copy_status.restrict_copy_delete.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.config.copy_status.restrict_copy_delete.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.config.copy_status.restrict_copy_delete.sql new file mode 100644 index 0000000000..e91aed21c9 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.config.copy_status.restrict_copy_delete.sql @@ -0,0 +1,10 @@ +BEGIN; + +ALTER TABLE config.copy_status + ADD COLUMN restrict_copy_delete BOOL NOT NULL DEFAULT FALSE; + +UPDATE config.copy_status +SET restrict_copy_delete = TRUE +WHERE id IN (1,3,6,8); + +COMMIT; -- 2.11.0