From c208754eafadb005439800f7fedd33241fca7b65 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 12 Apr 2012 15:34:02 -0400 Subject: [PATCH] Add missing ADMIN_ORG_UNIT_CUSTOM_TREE permission Signed-off-by: Bill Erickson Signed-off-by: Michael Peters Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 4 +++- .../Pg/upgrade/0705.data.custom-org-tree-perms.sql | 20 ++++++++++++++++++++ 3 files changed, 24 insertions(+), 2 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0705.data.custom-org-tree-perms.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index b1f20934bc..dc9d191ba0 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 ('0704', :eg_version); -- dbs +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0705', :eg_version); -- dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index d53ae14db5..e71a35974c 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1543,7 +1543,9 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 526, 'UPDATE_PATRON_STAT_CAT_ENTRY_DEFAULT', oils_i18n_gettext( 526, 'User may reset a default entry in a patron statistical category', 'ppl', 'description' )), ( 527, 'DELETE_PATRON_STAT_CAT_ENTRY_DEFAULT', oils_i18n_gettext( 527, - 'User may unset a default entry in a patron statistical category', 'ppl', 'description' )); + 'User may unset a default entry in a patron statistical category', 'ppl', 'description' )), + ( 528, 'ADMIN_ORG_UNIT_CUSTOM_TREE', oils_i18n_gettext( 528, + 'User may update custom org unit trees', 'ppl', 'description' )); SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 1000); diff --git a/Open-ILS/src/sql/Pg/upgrade/0705.data.custom-org-tree-perms.sql b/Open-ILS/src/sql/Pg/upgrade/0705.data.custom-org-tree-perms.sql new file mode 100644 index 0000000000..3d0e0b92b6 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0705.data.custom-org-tree-perms.sql @@ -0,0 +1,20 @@ +-- Evergreen DB patch 0705.data.custom-org-tree-perms.sql +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0705', :eg_version); + +INSERT INTO permission.perm_list (id, code, description) + VALUES ( + 528, + 'ADMIN_ORG_UNIT_CUSTOM_TREE', + oils_i18n_gettext( + 528, + 'User may update custom org unit trees', + 'ppl', + 'description' + ) + ); + +COMMIT; -- 2.11.0