From 1417acaab574110cb344f191d93b2e7259376ff8 Mon Sep 17 00:00:00 2001 From: Alice Frumin Date: Thu, 7 Jan 2021 13:24:13 -0500 Subject: [PATCH] upgrader script --- CRM/Upgrade/Incremental/sql/5.34.alpha1.mysql.tpl | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/5.34.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.34.alpha1.mysql.tpl index 3bf32eb8bd..118ee6797a 100644 --- a/CRM/Upgrade/Incremental/sql/5.34.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.34.alpha1.mysql.tpl @@ -9,3 +9,9 @@ INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, DELETE FROM civicrm_mapping_field WHERE name NOT IN ( SELECT concat('custom_', id) FROM civicrm_custom_field) AND name LIKE 'custom_%'; + +-- Update permissions for CiviCRM Admin Menu -> CiviMail -> Message Templates +UPDATE civicrm_navigation n +SET n.permission = 'edit user-driven message templates,edit message templates,edit system workflow message templates', n.permission_operator = 'OR' +WHERE n.name = 'Message Templates' +AND n.permission = 'edit message templates'; -- 2.25.1