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

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
Commit	Line	Data
9ece1588	1	use groupex
	2	alter table evenements drop column advertise;
	3	alter table evenements drop column membres_only;
0cc4c07d	4	alter table membres add column sexe bool default null;
88198bd8	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);
9ece1588	10	use x4dat
9ece1588	11