From 115595dca577d9192474ac3d620ca079b89f39cd Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 4 May 2012 10:33:43 -0400 Subject: [PATCH] Adding a small pile of missing permissions ADMIN_ADDRESS_ALERT VIEW_ADDRESS_ALERT ADMIN_COPY_LOCATION_GROUP ADMIN_USER_ACTIVITY_TYPE Signed-off-by: Bill Erickson 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 | 11 ++++- .../upgrade/0709.data.misc_missing_perms.sql | 48 ++++++++++++++++++ .../Pg/version-upgrade/2.1-2.2-upgrade-db.sql | 49 +++++++++++++++++++ 4 files changed, 108 insertions(+), 2 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_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 ff67979a30..2bf618d248 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 ('0708', :eg_version); -- dbs/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0709', :eg_version); -- berick/senator 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 70e401dbb4..87c3eff9e2 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1549,7 +1549,16 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 529, 'ADMIN_IMPORT_MATCH_SET', oils_i18n_gettext( 529, 'Allows a user to create/retrieve/update/delete vandelay match sets', 'ppl', 'description' )), ( 530, 'VIEW_IMPORT_MATCH_SET', oils_i18n_gettext( 530, - 'Allows a user to view vandelay match sets', 'ppl', 'description' )); + 'Allows a user to view vandelay match sets', 'ppl', 'description' )), + ( 531, 'ADMIN_ADDRESS_ALERT', oils_i18n_gettext( 531, + 'Allows a user to create/retrieve/update/delete address alerts', 'ppl', 'description' )), + ( 532, 'VIEW_ADDRESS_ALERT', oils_i18n_gettext( 532, + 'Allows a user to view address alerts', 'ppl', 'description' )), + ( 533, 'ADMIN_COPY_LOCATION_GROUP', oils_i18n_gettext( 533, + 'Allows a user to create/retrieve/update/delete copy location groups', 'ppl', 'description' )), + ( 534, 'ADMIN_USER_ACTIVITY_TYPE', oils_i18n_gettext( 534, + 'Allows a user to create/retrieve/update/delete user activity types', 'ppl', 'description' )); + SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 1000); diff --git a/Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql b/Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql new file mode 100644 index 0000000000..dd419057d2 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql @@ -0,0 +1,48 @@ +-- Evergreen DB patch 0709.data.misc_missing_perms.sql +-- +-- Fixes a typo in the name of a global flag + +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0709', :eg_version); + +INSERT INTO permission.perm_list ( id, code, description ) + VALUES ( + 531, + 'ADMIN_ADDRESS_ALERT', + oils_i18n_gettext( + 531, + 'Allows a user to create/retrieve/update/delete address alerts', + 'ppl', + 'description' + ) + ), ( + 532, + 'VIEW_ADDRESS_ALERT', + oils_i18n_gettext( + 532, + 'Allows a user to view address alerts', + 'ppl', + 'description' + ) + ), ( + 533, + 'ADMIN_COPY_LOCATION_GROUP', + oils_i18n_gettext( + 533, + 'Allows a user to create/retrieve/update/delete copy location groups', + 'ppl', + 'description' + ) + ), ( + 534, + 'ADMIN_USER_ACTIVITY_TYPE', + oils_i18n_gettext( + 534, + 'Allows a user to create/retrieve/update/delete user activity types', + 'ppl', + 'description' + ) + ); + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql index 4f8dff4ef7..3086b50cd1 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql @@ -16086,3 +16086,52 @@ INSERT INTO permission.perm_list ( id, code, description ) ); COMMIT; + +-- Evergreen DB patch 0709.data.misc_missing_perms.sql +-- +-- Fixes a typo in the name of a global flag + +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0709', :eg_version); + +INSERT INTO permission.perm_list ( id, code, description ) + VALUES ( + 531, + 'ADMIN_ADDRESS_ALERT', + oils_i18n_gettext( + 531, + 'Allows a user to create/retrieve/update/delete address alerts', + 'ppl', + 'description' + ) + ), ( + 532, + 'VIEW_ADDRESS_ALERT', + oils_i18n_gettext( + 532, + 'Allows a user to view address alerts', + 'ppl', + 'description' + ) + ), ( + 533, + 'ADMIN_COPY_LOCATION_GROUP', + oils_i18n_gettext( + 533, + 'Allows a user to create/retrieve/update/delete copy location groups', + 'ppl', + 'description' + ) + ), ( + 534, + 'ADMIN_USER_ACTIVITY_TYPE', + oils_i18n_gettext( + 534, + 'Allows a user to create/retrieve/update/delete user activity types', + 'ppl', + 'description' + ) + ); + +COMMIT; -- 2.43.2