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

-- remove activity_medium option group and values

DELETE ov.*
FROM  civicrm_option_value ov
INNER JOIN civicrm_option_group og ON og.id = ov.option_group_id
WHERE og.name like 'activity_medium';

DELETE FROM civicrm_option_group WHERE name like 'activity_medium';

ALTER TABLE `civicrm_activity`
  MODIFY `medium_id` INT( 10 ) UNSIGNED NULL DEFAULT NULL COMMENT 'Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.';
Commit	Line	Data
6a488035 TO	1	-- remove activity_medium option group and values
	2
	3	DELETE ov.*
	4	FROM civicrm_option_value ov
	5	INNER JOIN civicrm_option_group og ON og.id = ov.option_group_id
	6	WHERE og.name like 'activity_medium';
	7
	8	DELETE FROM civicrm_option_group WHERE name like 'activity_medium';
	9
10824d34	10	ALTER TABLE `civicrm_activity`
6a488035	11	MODIFY `medium_id` INT( 10 ) UNSIGNED NULL DEFAULT NULL COMMENT 'Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.';