From 787b9fd3e977464a466a9f938a16cb2f7aae9fc6 Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Thu, 3 May 2018 15:02:07 -0700 Subject: [PATCH 1/1] LP#1768992: Add missing copy alert permissions Signed-off-by: Jeff Davis Signed-off-by: Galen Charlton Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 28 ++++++++++++++- .../Pg/upgrade/XXXX.data.copy_alert_perms.sql | 35 +++++++++++++++++++ 2 files changed, 62 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy_alert_perms.sql 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 6816911bab..7f7687d734 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1877,7 +1877,33 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 592,'CONTAINER_BATCH_UPDATE', oils_i18n_gettext( 592, 'Allow batch update via buckets', 'ppl', 'description' )), ( 593, 'ADMIN_SERIAL_PATTERN_TEMPLATE', oils_i18n_gettext( 593, - 'Administer serial prediction pattern templates', 'ppl', 'description' )) + 'Administer serial prediction pattern templates', 'ppl', 'description' )), + ( 594, 'ADMIN_COPY_ALERT_TYPE', oils_i18n_gettext( 594, + 'Administer copy alert types', 'ppl', 'description' )), + ( 595, 'CREATE_COPY_ALERT_TYPE', oils_i18n_gettext( 595, + 'Create copy alert types', 'ppl', 'description' )), + ( 596, 'UPDATE_COPY_ALERT_TYPE', oils_i18n_gettext( 596, + 'Update copy alert types', 'ppl', 'description' )), + ( 597, 'DELETE_COPY_ALERT_TYPE', oils_i18n_gettext( 597, + 'Delete copy alert types', 'ppl', 'description' )), + ( 598, 'ADMIN_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 598, + 'Administer copy alert suppression', 'ppl', 'description' )), + ( 599, 'CREATE_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 599, + 'Create copy alert suppression', 'ppl', 'description' )), + ( 600, 'UPDATE_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 600, + 'Update copy alert suppression', 'ppl', 'description' )), + ( 601, 'DELETE_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 601, + 'Delete copy alert suppression', 'ppl', 'description' )), + ( 602, 'ADMIN_COPY_ALERT', oils_i18n_gettext( 602, + 'Administer copy alerts', 'ppl', 'description' )), + ( 603, 'CREATE_COPY_ALERT', oils_i18n_gettext( 603, + 'Create copy alerts', 'ppl', 'description' )), + ( 604, 'VIEW_COPY_ALERT', oils_i18n_gettext( 604, + 'View copy alerts', 'ppl', 'description' )), + ( 605, 'UPDATE_COPY_ALERT', oils_i18n_gettext( 605, + 'Update copy alerts', 'ppl', 'description' )), + ( 606, 'DELETE_COPY_ALERT', oils_i18n_gettext( 606, + 'Delete copy alerts', 'ppl', 'description' )) ; SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 1000); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy_alert_perms.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy_alert_perms.sql new file mode 100644 index 0000000000..da2d217302 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy_alert_perms.sql @@ -0,0 +1,35 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO permission.perm_list ( id, code, description ) VALUES + ( 594, 'ADMIN_COPY_ALERT_TYPE', oils_i18n_gettext( 594, + 'Administer copy alert types', 'ppl', 'description' )), + ( 595, 'CREATE_COPY_ALERT_TYPE', oils_i18n_gettext( 595, + 'Create copy alert types', 'ppl', 'description' )), + ( 596, 'UPDATE_COPY_ALERT_TYPE', oils_i18n_gettext( 596, + 'Update copy alert types', 'ppl', 'description' )), + ( 597, 'DELETE_COPY_ALERT_TYPE', oils_i18n_gettext( 597, + 'Delete copy alert types', 'ppl', 'description' )), + ( 598, 'ADMIN_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 598, + 'Administer copy alert suppression', 'ppl', 'description' )), + ( 599, 'CREATE_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 599, + 'Create copy alert suppression', 'ppl', 'description' )), + ( 600, 'UPDATE_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 600, + 'Update copy alert suppression', 'ppl', 'description' )), + ( 601, 'DELETE_COPY_ALERT_SUPPRESS', oils_i18n_gettext( 601, + 'Delete copy alert suppression', 'ppl', 'description' )), + ( 602, 'ADMIN_COPY_ALERT', oils_i18n_gettext( 602, + 'Administer copy alerts', 'ppl', 'description' )), + ( 603, 'CREATE_COPY_ALERT', oils_i18n_gettext( 603, + 'Create copy alerts', 'ppl', 'description' )), + ( 604, 'VIEW_COPY_ALERT', oils_i18n_gettext( 604, + 'View copy alerts', 'ppl', 'description' )), + ( 605, 'UPDATE_COPY_ALERT', oils_i18n_gettext( 605, + 'Update copy alerts', 'ppl', 'description' )), + ( 606, 'DELETE_COPY_ALERT', oils_i18n_gettext( 606, + 'Delete copy alerts', 'ppl', 'description' )) +; + +COMMIT; + -- 2.43.2