CRM/Upgrade/Incremental/sql/4.4.alpha1.mysql.tpl

   1 {include file='../CRM/Upgrade/4.4.alpha1.msg_template/civicrm_msg_template.tpl'}
   2
   3 -- CRM-12357
   4 SELECT @option_group_id_cvOpt := max(id) FROM civicrm_option_group WHERE name = 'contact_view_options';
   5 SELECT @max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op  WHERE op.option_group_id  = @option_group_id_cvOpt;
   6 SELECT @max_wt := MAX(ROUND(val.weight)) FROM civicrm_option_value val WHERE val.option_group_id = @option_group_id_cvOpt;
   7
   8 INSERT INTO
   9    `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`)
  10 VALUES
  11   (@option_group_id_cvOpt, {localize}'{ts escape="sql"}Mailings{/ts}'{/localize}, @max_val+1, 'CiviMail', NULL, 0, NULL,  @max_wt+1, 0, 0, 1, NULL, NULL);
  12
  13 INSERT INTO civicrm_setting
  14   (domain_id, contact_id, is_domain, group_name, name, value)
  15 VALUES
  16   ({$domainID}, NULL, 1, 'Mailing Preferences', 'write_activity_record', '{serialize}1{/serialize}');
  17
  18 -- CRM-12580
  19 ALTER TABLE civicrm_contact ADD  INDEX index_is_deleted_sort_name(is_deleted, sort_name, id);
  20 ALTER TABLE civicrm_contact DROP INDEX index_is_deleted;
  21
  22 -- CRM-12495
  23 DROP TABLE IF EXISTS `civicrm_task_status`;
  24 DROP TABLE IF EXISTS `civicrm_task`;
  25 DROP TABLE IF EXISTS `civicrm_project`;
  26
  27 -- CRM-12425
  28 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Spam';
  29 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
  30 VALUES (@bounceTypeID, 'X-HmXmrOriginalRecipient');
  31
  32 -- CRM-12716
  33 UPDATE civicrm_custom_field SET text_length = NULL WHERE html_type = 'TextArea' AND text_length = 255;
  34