Commit | Line | Data |
---|---|---|
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 |