From d5ce5929495c31eeac6bfdc3df6bd3e275a3ed0d Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 29 Jul 2016 17:51:14 -0400 Subject: [PATCH] LP#1549505: Stamping upgrade scripts 0983-84 for stat pop ratings Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...tisitcal-ratings.sql => 0983.schema.statistical-ratings.sql} | 2 ++ ...{YYYY.function.qp_search.sql => 0984.function.qp_search.sql} | 2 ++ 3 files changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.statisitcal-ratings.sql => 0983.schema.statistical-ratings.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.function.qp_search.sql => 0984.function.qp_search.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 2cc6ff5413..0a00b31189 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 ('0982', :eg_version); -- dyrcona/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0984', :eg_version); -- miker/gmcharlt/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/0983.schema.statistical-ratings.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql rename to Open-ILS/src/sql/Pg/upgrade/0983.schema.statistical-ratings.sql index 29bcaf7356..9c48c1204f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0983.schema.statistical-ratings.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0983', :eg_version); + -- Create these so that the queries in the UDFs will validate CREATE TEMP TABLE precalc_filter_bib_list ( id BIGINT diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.function.qp_search.sql b/Open-ILS/src/sql/Pg/upgrade/0984.function.qp_search.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.function.qp_search.sql rename to Open-ILS/src/sql/Pg/upgrade/0984.function.qp_search.sql index 3cb1da6a52..ea5814210f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.function.qp_search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0984.function.qp_search.sql @@ -17,6 +17,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0984', :eg_version); + ALTER TYPE search.search_result ADD ATTRIBUTE badges TEXT, ADD ATTRIBUTE popularity NUMERIC; CREATE OR REPLACE FUNCTION search.query_parser_fts ( -- 2.43.2