CRM/Upgrade/Incremental/sql/2.2.0.mysql.tpl

   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
  10 ALTER TABLE `civicrm_activity`
  11   MODIFY `medium_id` INT( 10 ) UNSIGNED NULL DEFAULT NULL COMMENT 'Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.';