From 6cce3cd5e59eb2a247302467500c4b190a442586 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Mon, 14 Jul 2014 08:37:30 -0400 Subject: [PATCH] LP#1198475: Wrapping upgrade script for lost and paid copy status. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...nd-paid-status.sql => 0886.data.lost-and-paid-status.sql} | 5 +++++ 2 files changed, 6 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.lost-and-paid-status.sql => 0886.data.lost-and-paid-status.sql} (87%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 69e0e7fc9f..7de740b181 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0885', :eg_version); -- depesz/dyrcona/miker/kmlussier/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0886', :eg_version); -- dyrcona/kmlussier/rogan CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost-and-paid-status.sql b/Open-ILS/src/sql/Pg/upgrade/0886.data.lost-and-paid-status.sql similarity index 87% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost-and-paid-status.sql rename to Open-ILS/src/sql/Pg/upgrade/0886.data.lost-and-paid-status.sql index 9454de5e46..176090f0fb 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lost-and-paid-status.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0886.data.lost-and-paid-status.sql @@ -1,3 +1,7 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0886', :eg_version); + INSERT INTO config.copy_status (id, name, holdable, opac_visible, copy_active, restrict_copy_delete) VALUES (17, 'Lost and Paid', FALSE, FALSE, FALSE, TRUE); @@ -15,3 +19,4 @@ VALUES 'coust', 'description'), 'bool'); +COMMIT; -- 2.43.2