From 6d6130ea3d1671770f55c2ee82d0b96836fa46a1 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 18 Feb 2015 15:24:50 -0500 Subject: [PATCH] LP1171984: Stamping upgrade script Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...rity_match_sets.sql => 0909.schema.authority_match_sets.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.authority_match_sets.sql => 0909.schema.authority_match_sets.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 1d2aea9e7c..bc665c1428 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 ('0908', :eg_version); -- ldw/mdriscoll/dyrcona +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0909', :eg_version); -- berick/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority_match_sets.sql b/Open-ILS/src/sql/Pg/upgrade/0909.schema.authority_match_sets.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority_match_sets.sql rename to Open-ILS/src/sql/Pg/upgrade/0909.schema.authority_match_sets.sql index 149ba2525d..30d4fab04f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority_match_sets.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0909.schema.authority_match_sets.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0909', :eg_version); + ALTER TABLE vandelay.authority_match ADD COLUMN match_score INT NOT NULL DEFAULT 0; -- 2.43.2