From 809f203c53884fd412ec0adf8c384405b42171e1 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Tue, 5 Oct 2004 21:57:52 +0000
Subject: [PATCH] melix

---
 scripts/sql/migration.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/scripts/sql/migration.sql b/scripts/sql/migration.sql
index 5d66a29..f84295c 100644
--- a/scripts/sql/migration.sql
+++ b/scripts/sql/migration.sql
@@ -50,6 +50,15 @@ ALTER TABLE x4dat.auth_user_md5 DROP COLUMN username_sasl;
 
 
 --------------------------------------------------------------------------------
+-- MELIX
+--------------------------------------------------------------------------------
+update groupex.aliases       AS gx
+    inner join x4dat.aliases AS a ON (gx.email = a.alias)
+    inner join x4dat.aliases AS b ON (a.id=b.id AND b.type='a_vie')
+    set gx.email = b.alias
+    where gx.id = 12
+
+--------------------------------------------------------------------------------
 -- DROP des LISTES
 --------------------------------------------------------------------------------
 drop table x4dat.listes_def;
-- 
2.1.4