CRM/Upgrade/Incremental/sql/4.6.6.mysql.tpl

   1 {* file to handle db changes in 4.6.6 during upgrade *}
   2
   3 -- CRM-16846 - This upgrade may have been previously skipped so moving it to 4.6.6
   4 -- update permission for editing message templates (CRM-15819)
   5
   6 SELECT @messages_menu_id := id FROM civicrm_navigation WHERE name = 'Mailings';
   7
   8 UPDATE `civicrm_navigation`
   9 SET `permission` = 'edit message templates'
  10 WHERE `parent_id` = @messages_menu_id
  11 AND name = 'Message Templates';