From 42c3833ff847814f7177863f37eed8221080606b Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Thu, 7 Apr 2011 14:49:43 +0200
Subject: [PATCH] Updates email_virtual so that it only contains forlife
 emails.
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.1/02_emails.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 upgrade/1.1.1/02_emails.sql

diff --git a/upgrade/1.1.1/02_emails.sql b/upgrade/1.1.1/02_emails.sql
new file mode 100644
index 0000000..95ee45c
--- /dev/null
+++ b/upgrade/1.1.1/02_emails.sql
@@ -0,0 +1,9 @@
+    DELETE  e2
+      FROM  email_virtual AS e1
+INNER JOIN  email_virtual AS e2
+     WHERE  e1.email = e2.email AND e1.domain = e2.domain AND e1.redirect = REPLACE(e2.redirect, '@m4x.org', '@polytechnique.org');
+UPDATE  email_virtual
+   SET  redirect = REPLACE(redirect, '@m4x.org', '@polytechnique.org')
+ WHERE  redirect LIKE '%@m4x.org';
+
+-- vim:set syntax=mysql:
-- 
2.1.4