-- CRM-1971

ALTER TABLE civicrm_event 
   DROP FOREIGN KEY `FK_civicrm_event_loc_block_id`;
ALTER TABLE civicrm_event 
   ADD CONSTRAINT `FK_civicrm_event_loc_block_id` FOREIGN KEY (`loc_block_id`) REFERENCES `civicrm_loc_block` (`id`) ON DELETE SET NULL; 

ALTER TABLE civicrm_loc_block DROP name;
