From a45184da2ac9f490886ebde47fcc8af4227afcf0 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 7 Jul 2011 13:06:48 -0400 Subject: [PATCH] Stamping upgrade version number for staff_search_find_no_copies branch Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...opies.sql => 0573.schema.staff_search_find_no_copies.sql} | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.staff_search_find_no_copies.sql => 0573.schema.staff_search_find_no_copies.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 6276a29384..67b34933f5 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 ('0572', :eg_version); -- berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0573', :eg_version); -- miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.staff_search_find_no_copies.sql b/Open-ILS/src/sql/Pg/upgrade/0573.schema.staff_search_find_no_copies.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.staff_search_find_no_copies.sql rename to Open-ILS/src/sql/Pg/upgrade/0573.schema.staff_search_find_no_copies.sql index 56ccf874ab..a3f4bab415 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.staff_search_find_no_copies.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0573.schema.staff_search_find_no_copies.sql @@ -1,3 +1,12 @@ +-- Evergreen DB patch 0573.schema.staff_search_find_no_copies.sql +-- +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0573', :eg_version); + CREATE OR REPLACE FUNCTION search.query_parser_fts ( param_search_ou INT, @@ -304,3 +313,6 @@ BEGIN END; $func$ LANGUAGE PLPGSQL; + + +COMMIT; -- 2.11.0