From 3cd206a5e61f6665420602dd2e9da15270a5b26c Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Wed, 19 Aug 2015 12:17:17 -0400 Subject: [PATCH] LP#1379815: Stamping upgrade scripts for vandelay stat cat import Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ..._to_table.sql => 0928.function.vandelay-oils_xpath_tag_to_table.sql} | 2 +- ...lay-stat-cat-import.sql => 0929.schema.vandelay-stat-cat-import.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.function.vandelay-oils_xpath_tag_to_table.sql => 0928.function.vandelay-oils_xpath_tag_to_table.sql} (95%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.schema.vandelay-stat-cat-import.sql => 0929.schema.vandelay-stat-cat-import.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 3b00fb8949..209df2da2f 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 ('0927', :eg_version); -- dbwells/csharp/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0929', :eg_version); -- dbwells/remington/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.vandelay-oils_xpath_tag_to_table.sql b/Open-ILS/src/sql/Pg/upgrade/0928.function.vandelay-oils_xpath_tag_to_table.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.vandelay-oils_xpath_tag_to_table.sql rename to Open-ILS/src/sql/Pg/upgrade/0928.function.vandelay-oils_xpath_tag_to_table.sql index 48e44f8d31..9796f8df96 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.vandelay-oils_xpath_tag_to_table.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0928.function.vandelay-oils_xpath_tag_to_table.sql @@ -1,6 +1,6 @@ BEGIN; ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0928', :eg_version); CREATE OR REPLACE FUNCTION oils_xpath_tag_to_table(marc text, tag text, xpaths text[]) RETURNS SETOF record AS $function$ diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.vandelay-stat-cat-import.sql b/Open-ILS/src/sql/Pg/upgrade/0929.schema.vandelay-stat-cat-import.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.schema.vandelay-stat-cat-import.sql rename to Open-ILS/src/sql/Pg/upgrade/0929.schema.vandelay-stat-cat-import.sql index 57b0a45855..e475366c91 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.vandelay-stat-cat-import.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0929.schema.vandelay-stat-cat-import.sql @@ -1,6 +1,6 @@ BEGIN; ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0929', :eg_version); INSERT INTO vandelay.import_error ( code, description ) VALUES ( 'import.item.invalid.stat_cat_format', oils_i18n_gettext('import.item.invalid.stat_cat_format', 'Bad format for stat cat data, should be like: CAT 1|VALUE 1', 'vie', 'description') ); -- 2.11.0