From eaf67a5fe21577b4995c7894d430de7c86db45f9 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Tue, 1 Mar 2011 11:34:22 +0100 Subject: [PATCH] Removes useless condition. 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 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/upgrade/1.1.0/02_new_mail_insertion.sql b/upgrade/1.1.0/02_new_mail_insertion.sql index 3a3b9c4..8edc6f8 100644 --- a/upgrade/1.1.0/02_new_mail_insertion.sql +++ b/upgrade/1.1.0/02_new_mail_insertion.sql @@ -133,7 +133,7 @@ INSERT INTO email_virtual (email, domain, redirect, type) FROM virtual AS v INNER JOIN email_virtual_domains AS d ON (SUBSTRING_INDEX(v.alias, '@', -1) = d.name AND d.id = d.aliasing) LEFT JOIN virtual_redirect AS vr ON (vr.vid = v.vid) - WHERE v.alias NOT LIKE '%@melix.net' AND vr.vid IS NOT NULL AND v.alias != '@melix.org' AND v.type != 'dom'; + WHERE v.alias NOT LIKE '%@melix.net' AND vr.vid IS NOT NULL AND v.type != 'dom'; INSERT INTO email_virtual (email, type, domain, redirect) SELECT alias, 'list', @p_domain_id, -- 2.1.4