Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-10641 (fix duplicate option values) |
2 | ||
3 | SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type'; | |
4 | SELECT @maxValue := MAX(ROUND(value)) FROM civicrm_option_value WHERE option_group_id = @option_group_id_act; | |
5 | SELECT @clientSMSValue := value FROM civicrm_option_value WHERE name = 'BULK SMS' AND option_group_id = @option_group_id_act; | |
6 | ||
7 | SELECT @smsVal := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_act GROUP BY value | |
8 | HAVING count(value) > 1 AND value = @clientSMSValue; | |
9 | ||
10 | UPDATE civicrm_option_value | |
11 | SET value = @maxValue + 1 | |
12 | WHERE value = @smsVal | |
13 | AND name = 'BULK SMS' AND option_group_id = @option_group_id_act; | |
14 | ||
15 | SELECT @newClientSMSValue := value FROM civicrm_option_value WHERE name = 'BULK SMS' AND option_group_id = @option_group_id_act; | |
16 | ||
10824d34 | 17 | UPDATE civicrm_activity |
6a488035 TO |
18 | INNER JOIN civicrm_mailing ON civicrm_activity.source_record_id = civicrm_mailing.id |
19 | SET civicrm_activity.activity_type_id = @newClientSMSValue | |
20 | WHERE civicrm_activity.activity_type_id = @clientSMSValue; | |
21 | ||
22 | -- CRM-10671 remove incomplete price set reports (inserted in 4.2 alpha 1) | |
23 | SELECT @option_group_id_report := MAX(id) FROM civicrm_option_group WHERE name = 'report_template'; | |
24 | DELETE from civicrm_option_value | |
25 | WHERE name = 'CRM_Report_Form_Price_Lineitem' AND | |
26 | option_group_id = @option_group_id_report; | |
27 | ||
28 | DELETE from civicrm_option_value | |
29 | WHERE name = 'CRM_Report_Form_Price_Contributionbased' AND | |
30 | option_group_id = @option_group_id_report; | |
31 | ||
32 | DELETE from civicrm_option_value | |
33 | WHERE name = 'CRM_Report_Form_Price_Lineitemparticipant' AND | |
34 | option_group_id = @option_group_id_report; |