From c820aa492739c544e09a7b646a09b8507ae3993b Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 24 Aug 2016 18:01:33 -0400 Subject: [PATCH] Stamping upgrade for email receipts Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...heckout-receipt.sql => 0996.data.email-checkout-receipt.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.email-checkout-receipt.sql => 0996.data.email-checkout-receipt.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index d0fc23aeb2..7e098c0d6c 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 ('0995', :eg_version); -- kmlussier/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0996', :eg_version); -- gmcharlt/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.email-checkout-receipt.sql b/Open-ILS/src/sql/Pg/upgrade/0996.data.email-checkout-receipt.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.email-checkout-receipt.sql rename to Open-ILS/src/sql/Pg/upgrade/0996.data.email-checkout-receipt.sql index eaeaf367a7..961c87bc02 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.email-checkout-receipt.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0996.data.email-checkout-receipt.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0996', :eg_version); + INSERT INTO config.usr_setting_type ( name, opac_visible, -- 2.43.2