X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.11%2F03_xnet.sql;h=6d269c5d51948c7e12d83476e5eb514ca03a0209;hb=8eccf7e0d2a9e88e817f02fbc0fbe3daefba2975;hp=a044a85363e2a4ccca8287043ce7a1cfa6b77d74;hpb=0cc4c07df8bc6a10c893d0f91aae02e4856f3123;p=platal.git

diff --git a/upgrade/0.9.11/03_xnet.sql b/upgrade/0.9.11/03_xnet.sql
index a044a85..6d269c5 100644
--- a/upgrade/0.9.11/03_xnet.sql
+++ b/upgrade/0.9.11/03_xnet.sql
@@ -2,5 +2,10 @@ use groupex
 alter table evenements drop column advertise;
 alter table evenements drop column membres_only;
 alter table membres add column sexe bool default null;
+
+INSERT IGNORE INTO membres (uid, asso_id)
+            SELECT u.user_id AS uid, g.id AS asso_id
+              FROM x4dat.auth_user_md5 AS u
+        INNER JOIN asso AS g ON (g.diminutif LIKE u.promo);
 use x4dat