[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.3.1.mysql.tpl

-- CRM-12351
UPDATE civicrm_dedupe_rule_group SET title = name WHERE title IS NULL;

-- CRM-12373

SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Dns';
INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
    VALUES
      (@bounceTypeID, 'Host or domain name not found');

SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Host';
INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
    VALUES
      (@bounceTypeID, 'lost connection'),
      (@bounceTypeID, 'conversation with [^ ]* timed out while');

SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Relay';
INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
    VALUES
      (@bounceTypeID, 'No route to host'),
      (@bounceTypeID, 'Network is unreachable');
Commit	Line	Data
2f539081	1	-- CRM-12351
f29cfa44 DL	2	UPDATE civicrm_dedupe_rule_group SET title = name WHERE title IS NULL;
	3
	4	-- CRM-12373
	5
	6	SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Dns';
	7	INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
	8	VALUES
	9	(@bounceTypeID, 'Host or domain name not found');
	10
	11	SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Host';
	12	INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
	13	VALUES
	14	(@bounceTypeID, 'lost connection'),
	15	(@bounceTypeID, 'conversation with [^ ]* timed out while');
	16
	17	SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Relay';
	18	INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
	19	VALUES
	20	(@bounceTypeID, 'No route to host'),
	21	(@bounceTypeID, 'Network is unreachable');