From 9651627b8bc3ac3553de0ebd701c30c5acc2564e Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Sun, 7 Nov 2004 20:20:23 +0000 Subject: [PATCH] delete unused aliases --- scripts/migration/0.9.2/99_virtual.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/scripts/migration/0.9.2/99_virtual.sql b/scripts/migration/0.9.2/99_virtual.sql index 13ba002..6cd3564 100644 --- a/scripts/migration/0.9.2/99_virtual.sql +++ b/scripts/migration/0.9.2/99_virtual.sql @@ -13,3 +13,5 @@ insert into virtual_redirect select vid,CONCAT(email,'@m4x.org') from virtual AS v inner join groupex.aliases as d ON(v.alias=d.domain); + +delete from virtual where domain like '%@melix.net'; -- 2.1.4