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;
8 ALTER TABLE civicrm_loc_block DROP name;