From 4188065fe61f09d5e9cdaae4d5bb0d134c9ba51c Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 1 Jun 2011 16:30:43 -0400 Subject: [PATCH] gave upgrade script a real version number Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...rmat_generated_coverage.sql => 0544..data.patron_no_collections.sql} | 0 Open-ILS/src/sql/Pg/upgrade/XXXX.data.patron_no_collections.sql | 2 +- 3 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{0543.data.reformat_generated_coverage.sql => 0544..data.patron_no_collections.sql} (100%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 56af82f64a..8f107d1ba2 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0543', :eg_version); -- dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0544', :eg_version); -- berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0543.data.reformat_generated_coverage.sql b/Open-ILS/src/sql/Pg/upgrade/0544..data.patron_no_collections.sql similarity index 100% rename from Open-ILS/src/sql/Pg/upgrade/0543.data.reformat_generated_coverage.sql rename to Open-ILS/src/sql/Pg/upgrade/0544..data.patron_no_collections.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.patron_no_collections.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.patron_no_collections.sql index 620c2a4a31..74ce619800 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.patron_no_collections.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.patron_no_collections.sql @@ -1,6 +1,6 @@ BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('XXX'); +SELECT evergreen.upgrade_deps_block_check('0544', :eg_version); INSERT INTO config.usr_setting_type ( name, opac_visible, label, description, datatype) VALUES -- 2.11.0