From abc738f57e52871192f9a027e5356deb8f7424d5 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Wed, 1 Aug 2012 17:33:48 -0400 Subject: [PATCH] Wrap upgrade script for search filter group admin UI Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...up_perms.sql => 0735.data.search_filter_group_perms.sql} | 6 ++++-- 2 files changed, 5 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.search_filter_group_perms.sql => 0735.data.search_filter_group_perms.sql} (76%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index b836f97114..4c57bb6c6b 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 ('0734', :eg_version); -- tsbere/denials +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0735', :eg_version); -- berick/kmlussier/denials CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.search_filter_group_perms.sql b/Open-ILS/src/sql/Pg/upgrade/0735.data.search_filter_group_perms.sql similarity index 76% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.search_filter_group_perms.sql rename to Open-ILS/src/sql/Pg/upgrade/0735.data.search_filter_group_perms.sql index a0310e9c8b..cdcf50a96f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.search_filter_group_perms.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0735.data.search_filter_group_perms.sql @@ -1,8 +1,10 @@ +-- Evergreen DB patch 0735.data.search_filter_group_perms.sql +-- BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0735', :eg_version); --- TODO: verify IDs before merging INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 537, -- 2.43.2