From db7b67abd0c52a1ae92f35a7b4f28f441a9af8ad Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 8 Aug 2017 17:28:43 -0400 Subject: [PATCH] LP#1480432: stamp DB update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...n.user_perms.sql => 1050.function.permission.user_perms.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.function.permission.user_perms.sql => 1050.function.permission.user_perms.sql} (89%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 6cc41db27a..9dc75dfbb5 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('1049', :eg_version); -- mmorgan/stompro/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1050', :eg_version); -- mmorgan/cesardv/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.permission.user_perms.sql b/Open-ILS/src/sql/Pg/upgrade/1050.function.permission.user_perms.sql similarity index 89% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.permission.user_perms.sql rename to Open-ILS/src/sql/Pg/upgrade/1050.function.permission.user_perms.sql index 10af7ba973..5a9b0d53e0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.permission.user_perms.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1050.function.permission.user_perms.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('0991', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1050', :eg_version); -- mmorgan/cesardv/gmcharlt CREATE OR REPLACE FUNCTION permission.usr_perms ( INT ) RETURNS SETOF permission.usr_perm_map AS $$ SELECT DISTINCT ON (usr,perm) * -- 2.43.2