Merge pull request #4054 from eileenmcnaughton/CRM-15237
[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.2.alpha2.mysql.tpl
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
7 ALTER TABLE civicrm_group ADD CONSTRAINT `FK_civicrm_group_saved_search_id`
8 FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search` (`id`)
9 ON DELETE SET NULL;