From 13973bc1ce189b6ede2afde59b9f8c8487be75b0 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 14 Feb 2013 14:24:00 -0500 Subject: [PATCH] Stamping upgrades for Link Checker Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../upgrade/{XXXX.schema.url_verify.sql => 0752.schema.url_verify.sql} | 2 ++ .../{YYYY.functions.url_verify.sql => 0753.functions.url_verify.sql} | 2 ++ .../Pg/upgrade/{ZZZZ.data.url_verify.sql => 0754.data.url_verify.sql} | 2 ++ 4 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.url_verify.sql => 0752.schema.url_verify.sql} (98%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.functions.url_verify.sql => 0753.functions.url_verify.sql} (98%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.data.url_verify.sql => 0754.data.url_verify.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 84635982f4..04194230e1 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,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 ('0751', :eg_version); -- berick/senator +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0754', :eg_version); -- senator/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql b/Open-ILS/src/sql/Pg/upgrade/0752.schema.url_verify.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql rename to Open-ILS/src/sql/Pg/upgrade/0752.schema.url_verify.sql index ddddd41626..ccf0372254 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.url_verify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0752.schema.url_verify.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0752', :eg_version); + INSERT INTO container.biblio_record_entry_bucket_type (code, label) VALUES ('url_verify', 'URL Verification Queue'); DROP SCHEMA IF EXISTS url_verify CASCADE; diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.functions.url_verify.sql b/Open-ILS/src/sql/Pg/upgrade/0753.functions.url_verify.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.functions.url_verify.sql rename to Open-ILS/src/sql/Pg/upgrade/0753.functions.url_verify.sql index e80cb25542..026b4a2bb1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.functions.url_verify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0753.functions.url_verify.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0753', :eg_version); + CREATE OR REPLACE FUNCTION url_verify.parse_url (url_in TEXT) RETURNS url_verify.url AS $$ use Rose::URI; diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.data.url_verify.sql b/Open-ILS/src/sql/Pg/upgrade/0754.data.url_verify.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.data.url_verify.sql rename to Open-ILS/src/sql/Pg/upgrade/0754.data.url_verify.sql index 968361b851..eecbca8940 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.data.url_verify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0754.data.url_verify.sql @@ -4,6 +4,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0754', :eg_version); + INSERT INTO permission.perm_list (id, code, description) VALUES ( 543, -- 2.11.0