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

{* file to handle db changes in 4.7.14 during upgrade *}
-- CRM-19616 Fix Manage Tags and New Tag Url issues.
UPDATE civicrm_navigation SET
  `url` = 'civicrm/tag?reset=1'
WHERE `name` = 'Manage Tags (Categories)'
AND `url` = 'civicrm/tag?reset=1&action=add';

UPDATE civicrm_navigation SET
  `url` = 'civicrm/tag?reset=1&action=add'
WHERE `name` = 'New Tag'
AND `url` = 'civicrm/admin/tag?reset=1';

UPDATE civicrm_navigation SET
  `url` = 'civicrm/tag?reset=1'
WHERE `name` = 'Tags (Categories)'
AND `url` = 'civicrm/admin/tag?reset=1';

-- Handle message template changes
{include file='../CRM/Upgrade/4.7.14.msg_template/civicrm_msg_template.tpl'}
Commit	Line	Data
5195a8af	1	{* file to handle db changes in 4.7.14 during upgrade *}
b9bbfae7 SL	2	-- CRM-19616 Fix Manage Tags and New Tag Url issues.
	3	UPDATE civicrm_navigation SET
	4	`url` = 'civicrm/tag?reset=1'
	5	WHERE `name` = 'Manage Tags (Categories)'
	6	AND `url` = 'civicrm/tag?reset=1&action=add';
	7
	8	UPDATE civicrm_navigation SET
	9	`url` = 'civicrm/tag?reset=1&action=add'
	10	WHERE `name` = 'New Tag'
	11	AND `url` = 'civicrm/admin/tag?reset=1';
	12
	13	UPDATE civicrm_navigation SET
	14	`url` = 'civicrm/tag?reset=1'
	15	WHERE `name` = 'Tags (Categories)'
	16	AND `url` = 'civicrm/admin/tag?reset=1';
8fd59c21	17
	18	-- Handle message template changes
	19	{include file='../CRM/Upgrade/4.7.14.msg_template/civicrm_msg_template.tpl'}