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

   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
  17 UPDATE civicrm_activity
  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;