[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 2.2.beta4.mysql.tpl

-- 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;
Commit	Line	Data
6a488035 TO	1	-- CRM-1971
6a488035 TO	2
10824d34	3	ALTER TABLE civicrm_event
6a488035	4	DROP FOREIGN KEY `FK_civicrm_event_loc_block_id`;
10824d34	5	ALTER TABLE civicrm_event
6a488035 TO	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;