From 4ae3fa1a24e1e1bbfbd8b1ba77c8cc8e5d5b99a0 Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 19 Feb 2016 12:41:43 -0500 Subject: [PATCH] LP#1474051 Stamping upgrade script for drop-cc-data Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.schema.drop_cc_cols.sql => 0956.schema.drop_cc_cols.sql} | 2 +- .../upgrade/{YYYY.data.drop_cc_cols.sql => 0957.data.drop_cc_cols.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.drop_cc_cols.sql => 0956.schema.drop_cc_cols.sql} (75%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.drop_cc_cols.sql => 0957.data.drop_cc_cols.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ab33a79ae9..1559923e11 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 ('0955', :eg_version); --mpeters/christineb/kmlussier +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0957', :eg_version); --berick/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.drop_cc_cols.sql b/Open-ILS/src/sql/Pg/upgrade/0956.schema.drop_cc_cols.sql similarity index 75% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.drop_cc_cols.sql rename to Open-ILS/src/sql/Pg/upgrade/0956.schema.drop_cc_cols.sql index c24ab04c6f..fc8fb1b333 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.drop_cc_cols.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0956.schema.drop_cc_cols.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0956', :eg_version); ALTER TABLE money.credit_card_payment DROP COLUMN cc_type, diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.drop_cc_cols.sql b/Open-ILS/src/sql/Pg/upgrade/0957.data.drop_cc_cols.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.drop_cc_cols.sql rename to Open-ILS/src/sql/Pg/upgrade/0957.data.drop_cc_cols.sql index 763dcbd56d..36124179c8 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.drop_cc_cols.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0957.data.drop_cc_cols.sql @@ -1,7 +1,7 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0957', :eg_version); -- Remove references to dropped CC payment columns in the print/email -- payment receipt templates, but only if the in-db template matches -- 2.11.0