update core
[platal.git] / upgrade / 0.9.11 / 03_xnet.sql
1 use groupex
2 alter table evenements drop column advertise;
3 alter table evenements drop column membres_only;
4 alter table membres add column sexe bool default null;
5
6 INSERT IGNORE INTO membres (uid, asso_id)
7 SELECT u.user_id AS uid, g.id AS asso_id
8 FROM x4dat.auth_user_md5 AS u
9 INNER JOIN asso AS g ON (g.diminutif LIKE u.promo);
10 use x4dat
11