INSERT INTO `bounce_patterns` (`id`, `pattern`, `bounce_type`, `description`) VALUES
(1, '%user unknown%', 'hard', 'Empfaenger unbekannt'),
(2, '%mailbox full%', 'soft', 'Postfach voll'),
(3, '%blocked%', 'spam', 'Blockiert durch Spamfilter'),
(4, '%temporarily deferred%', 'soft', 'Voruebergehende Ablehnung'),
(5, '%mailbox not found%', 'hard', 'Postfach nicht gefunden'),
(6, '%mailbox unavailable%', 'hard', 'Postfach nicht verfuegbar'),
(7, '%host or domain name not found%', 'hard', 'Postfach oder Domain nicht gefunden'),
(8, '%user is unknown%', 'hard', 'Empfaenger unbekannt'),
(9, '%not accepted%', 'hard', 'E-Mail abgelehnt'),
(10, '%unrouteable address%', 'hard', 'Empfaenger nicht gefunden'),
(13, '%no mailbox%', 'hard', NULL),
(14, '%invalid address%', 'hard', NULL),
(15, '%recipient address rejected%', 'hard', NULL),
(16, '%does not exist%', 'hard', NULL),
(17, '%doesnt have a%', 'hard', NULL),
(18, '%mailbox not available%', 'hard', NULL),
(19, '%no such user%', 'hard', NULL),
(20, '%delivery not allowed%', 'hard', NULL),
(21, '%mailbox inactive%', 'hard', NULL),
(22, '%the email account that you tried to reach is disabled%', 'hard', NULL),
(23, '%account has been disabled%', 'hard', NULL),
(24, '%550 address rejected%', 'hard', NULL),
(25, '%account that you tried to reach is disabled%', 'hard', NULL),
(26, '%550 no such local user%', 'hard', NULL),
(27, '%550 account suspended%', 'hard', NULL),
(28, '%550 #5.1.0 address rejected%', 'hard', NULL),
(29, '%this account is disabled%', 'hard', NULL),
(30, 'benutzer hat zuviele mails auf dem server', 'soft', 'Postfach voll'),
(33, '%speichervolumen ueberschritten%', 'soft', NULL),
(34, '%mailbox is full%', 'soft', NULL),
(35, '%onnection refused%', 'soft', NULL),
(36, '%refused%', 'soft', NULL),
(37, '%permanent error%', 'soft', NULL),
(38, '%mailbox over quota%', 'soft', NULL),
(39, '%mailbox deaktiviert%', 'hard', NULL),
(40, '%malformed or unexpected name server reply%', 'soft', NULL),
(41, '%mailbox disk quota exceeded%', 'soft', NULL),
(42, '%account is temporarily over quota%', 'soft', NULL),
(43, '%account is full%', 'soft', NULL),
(44, '%maildir over quota%', 'soft', NULL),
(45, '%quota exceeded%', 'soft', NULL),
(46, '%552-quota exceeded%', 'soft', NULL),
(47, '%account temporary disabled%', 'soft', NULL),
(48, '%unable to accept message%', 'soft', NULL),
(49, '%554 rejected by surbl%', 'soft', NULL),
(50, '%cannot be delivered%', 'soft', NULL),
(51, '%spam or virus classification%', 'spam', NULL),
(52, '%message detected as spam%', 'spam', NULL),
(53, '%as spamming%', 'spam', NULL),
(54, '%als spam%', 'spam', NULL),
(55, '%virus eingestuft%', 'spam', NULL),
(56, '%as spam%', 'spam', NULL),
(57, '%550 spam message%', 'spam', NULL),
(58, '%as spam by content filtering%', 'spam', NULL),
(59, '%recipients have complained about included content%', 'spam', NULL),
(60, '%is listed on sbl-multi.rbl.spamrl.com%', 'spam', NULL),
(61, '%blocked by spamassassin%', 'spam', NULL),
(62, '%the internet community may consider spam%', 'spam', NULL),
(63, '%message because it is spam%', 'spam', NULL),
(64, '%message cannot be accepted, spam rejection%', 'spam', NULL),
(65, '%your message was detected as spam%', 'spam', NULL),
(66, '%blacklisted url%', 'spam', NULL)
ON DUPLICATE KEY UPDATE
  `pattern` = VALUES(`pattern`),
  `bounce_type` = VALUES(`bounce_type`),
  `description` = VALUES(`description`);