From 03bc00d30fc77e537044ff2ba4aa7b3b0e1ee689 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Sun, 7 Nov 2004 19:47:03 +0000
Subject: [PATCH] convert all melix

---
 scripts/migration/0.9.2/99_virtual.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/scripts/migration/0.9.2/99_virtual.sql b/scripts/migration/0.9.2/99_virtual.sql
index 2b9c746..cc40de1 100644
--- a/scripts/migration/0.9.2/99_virtual.sql
+++ b/scripts/migration/0.9.2/99_virtual.sql
@@ -3,3 +3,13 @@ alter table virtual change column alias alias varchar(255) not null;
 alter table virtual add unique (alias) ;
 alter table virtual_redirect change column vid vid int not null auto_increment;
 alter table virtual_redirect add index (redirect);
+
+insert into virtual
+    select null,domain,'user'
+    from   groupex.aliases
+    where  domain like'%@melix.net';
+
+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);
-- 
2.1.4