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.'; |