X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.11%2F03_xnet.sql;h=6d269c5d51948c7e12d83476e5eb514ca03a0209;hb=843a2191e4c76f0beb00c754f06974de76791238;hp=fad1950969d584dda15f9ac869184546db6c0bd5;hpb=9ece1588755b26d32d2b5a565e0d59bc681b0264;p=platal.git

diff --git a/upgrade/0.9.11/03_xnet.sql b/upgrade/0.9.11/03_xnet.sql
index fad1950..6d269c5 100644
--- a/upgrade/0.9.11/03_xnet.sql
+++ b/upgrade/0.9.11/03_xnet.sql
@@ -1,5 +1,11 @@
 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