Merge remote branch 'origin/platal-1.0.0'

[platal.git] / upgrade / 0.9.11 / 03_xnet.sql

diff --git a/upgrade/0.9.11/03_xnet.sql b/upgrade/0.9.11/03_xnet.sql
index fad1950..6d269c5 100644 (file)
--- 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