Merge pull request #4054 from eileenmcnaughton/CRM-15237
[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 2.2.beta4.mysql.tpl
1 -- CRM-1971
2
3 ALTER TABLE civicrm_event
4 DROP FOREIGN KEY `FK_civicrm_event_loc_block_id`;
5 ALTER TABLE civicrm_event
6 ADD CONSTRAINT `FK_civicrm_event_loc_block_id` FOREIGN KEY (`loc_block_id`) REFERENCES `civicrm_loc_block` (`id`) ON DELETE SET NULL;
7
8 ALTER TABLE civicrm_loc_block DROP name;