From 3f64dbef5d9473000661e0ce00ff73bd64e0ef58 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Tue, 1 Mar 2011 11:31:15 +0100 Subject: [PATCH] Fixes comment position. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.1.0/02_new_mail_insertion.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/upgrade/1.1.0/02_new_mail_insertion.sql b/upgrade/1.1.0/02_new_mail_insertion.sql index 2229789..411b4bd 100644 --- a/upgrade/1.1.0/02_new_mail_insertion.sql +++ b/upgrade/1.1.0/02_new_mail_insertion.sql @@ -1,8 +1,5 @@ -- 1/ Feeds email_virtual_domains from virtual_domains and aliases. --- Note: There are some adresses on virtual that have no match on the virtual_redirect. --- The adresses in this situation are dropped. - INSERT INTO email_virtual_domains (name) VALUES ('polytechnique.org'); INSERT INTO email_virtual_domains (name) @@ -128,6 +125,10 @@ INSERT INTO email_redirect_other (hrmid, redirect, type, action) ('honey.jean-pierre.bilah.1980.polytechnique.org', 'raphael.barrois.2006@polytechnique.org', 'smtp', 'let_spams'); -- 7/ Feeds email_virtual + +-- Note: There are some adresses on virtual that have no match on the virtual_redirect. +-- The adresses in this situation are dropped. + INSERT INTO email_virtual (email, domain, redirect, type) SELECT SUBSTRING_INDEX(v.alias, '@', 1), d.id, vr.redirect, IF(v.type = 'evt', 'event', v.type) FROM virtual AS v -- 2.1.4