From 463f5358841f1ec668290ad598dc0e83b9e8fc90 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Wed, 4 May 2016 12:59:01 -0400 Subject: [PATCH] LP#1568046: Stamping upgrade script for changes to permission.grp_ancestors Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...nctions-via-cte.sql => 0979.function.grp-tree-functions-via-cte.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.function.grp-tree-functions-via-cte.sql => 0979.function.grp-tree-functions-via-cte.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 fc8f13ee63..cad3b82e56 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 ('0978', :eg_version); -- gmcharlt/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0979', :eg_version); -- miker/dyrcona/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.grp-tree-functions-via-cte.sql b/Open-ILS/src/sql/Pg/upgrade/0979.function.grp-tree-functions-via-cte.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.grp-tree-functions-via-cte.sql rename to Open-ILS/src/sql/Pg/upgrade/0979.function.grp-tree-functions-via-cte.sql index 28dc0611ab..82263bbcfa 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.grp-tree-functions-via-cte.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0979.function.grp-tree-functions-via-cte.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0979', :eg_version); + -- Replace connectby from the tablefunc extension with CTEs -- 2.11.0