From 6dcd580c87538f51dcc0ee14b88ca041f8d52b15 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Fri, 4 Mar 2011 10:36:52 +0100
Subject: [PATCH] Drops erroneous domains.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 upgrade/1.1.0/02_new_mail_insertion.sql | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/upgrade/1.1.0/02_new_mail_insertion.sql b/upgrade/1.1.0/02_new_mail_insertion.sql
index 6fd0c15..ce90b8b 100644
--- a/upgrade/1.1.0/02_new_mail_insertion.sql
+++ b/upgrade/1.1.0/02_new_mail_insertion.sql
@@ -208,4 +208,8 @@ INSERT INTO  email_virtual (domain, email, redirect, type)
 -- Drop renamed list
 DELETE FROM email_virtual WHERE email LIKE 'tech-email%';
 
+-- Deletes erroneous domains
+DELETE FROM  email_virtual_domains
+      WHERE  name IN ('fanfarix.polytechnique.net', 'asd', 'x-russie', 'formation', 'groupetest', 'x-sursaut');
+
 -- vim:set syntax=mysql:
-- 
2.1.4