CRM/Upgrade/Incremental/sql/5.35.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.35.alpha1 during upgrade *}
   2
   3 -- Update permissions for CiviCRM Admin Menu -> CiviMail -> Message Templates
   4 UPDATE civicrm_navigation n
   5 SET n.permission = 'edit user-driven message templates,edit message templates,edit system workflow message templates', n.permission_operator = 'OR'
   6 WHERE n.name = 'Message Templates'
   7 AND n.permission = 'edit message templates';