2 UPDATE civicrm_dedupe_rule_group SET title = name WHERE title IS NULL;
6 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Dns';
7 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
9 (@bounceTypeID, 'Host or domain name not found');
11 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Host';
12 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
14 (@bounceTypeID, 'lost connection'),
15 (@bounceTypeID, 'conversation with [^ ]* timed out while');
17 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Relay';
18 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
20 (@bounceTypeID, 'No route to host'),
21 (@bounceTypeID, 'Network is unreachable');