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

{* file to handle db changes in 5.9.alpha1 during upgrade *}

-- mail/issues#23 Bounce processing doesn't catch pattern "user doesn't exist"
SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Invalid';
UPDATE civicrm_mailing_bounce_pattern SET pattern = 'user (unknown|(does not|doesn\'t) exist)' WHERE bounce_type_id = @bounceTypeID AND pattern = 'user (unknown|does not exist)';
Commit	Line	Data
d7aafc7f	1	{* file to handle db changes in 5.9.alpha1 during upgrade *}
677f5b3b MD	2
	3	-- mail/issues#23 Bounce processing doesn't catch pattern "user doesn't exist"
	4	SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Invalid';
	5	UPDATE civicrm_mailing_bounce_pattern SET pattern = 'user (unknown\|(does not\|doesn\'t) exist)' WHERE bounce_type_id = @bounceTypeID AND pattern = 'user (unknown\|does not exist)';