[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.6.6.mysql.tpl

{* file to handle db changes in 4.6.6 during upgrade *}

-- CRM-16846 - This upgrade may have been previously skipped so moving it to 4.6.6
-- update permission for editing message templates (CRM-15819)

SELECT @messages_menu_id := id FROM civicrm_navigation WHERE name = 'Mailings';

UPDATE `civicrm_navigation`
SET `permission` = 'edit message templates'
WHERE `parent_id` = @messages_menu_id
AND name = 'Message Templates';
Commit	Line	Data
9ccbd1c1	1	{* file to handle db changes in 4.6.6 during upgrade *}
aac793a0 CW	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';