From 5537727d1b7e50452f1933e401998de192ecfe02 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 22 May 2012 15:10:14 -0400 Subject: [PATCH] stamping upgrade script for saved queries Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...rch_query_groups.sql => 0712.schema.search_query_groups.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.search_query_groups.sql => 0712.schema.search_query_groups.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index a51ec77e4a..e6f7c4744d 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 ('0711', :eg_version); -- senator +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0712', :eg_version); -- berick/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.search_query_groups.sql b/Open-ILS/src/sql/Pg/upgrade/0712.schema.search_query_groups.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.search_query_groups.sql rename to Open-ILS/src/sql/Pg/upgrade/0712.schema.search_query_groups.sql index 1ce760d3c8..0b55ac003b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.search_query_groups.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0712.schema.search_query_groups.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0712', :eg_version); + -- General purpose query container. Any table the needs to store -- a QueryParser query should store it here. This will be the -- source for top-level and QP sub-search inclusion queries. -- 2.43.2