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

{include file='../CRM/Upgrade/4.2.alpha2.msg_template/civicrm_msg_template.tpl'}

-- CRM-10326
DELETE FROM `civicrm_price_set_entity` WHERE entity_table = "civicrm_contribution" or entity_table = "civicrm_participant";

-- When deleting saved searches, null-out references from groups
ALTER TABLE civicrm_group ADD CONSTRAINT `FK_civicrm_group_saved_search_id`
  FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`)
  ON DELETE SET NULL;
Commit	Line	Data
6a488035 TO	1	{include file='../CRM/Upgrade/4.2.alpha2.msg_template/civicrm_msg_template.tpl'}
	2
	3	-- CRM-10326
	4	DELETE FROM `civicrm_price_set_entity` WHERE entity_table = "civicrm_contribution" or entity_table = "civicrm_participant";
	5
	6	-- When deleting saved searches, null-out references from groups
10824d34	7	ALTER TABLE civicrm_group ADD CONSTRAINT `FK_civicrm_group_saved_search_id`
10824d34	8	FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`)
6a488035	9	ON DELETE SET NULL;