[platal.git] / upgrade / merge-0.0.1 / 01_emails.sql

INSERT INTO  profile_directory (uid, email_directory)
     SELECT  user_id, Mel_usage
       FROM  fusionax_anciens AS ax
 INNER JOIN  auth_user_md5    AS u ON (ax.id_ancien = u.matricule_ax)
      WHERE  Mel_publiable != '0' AND Mel_usage != '';

INSERT IGNORE INTO  register_marketing (uid, email, type)
            SELECT  user_id, Mel_usage, 'ax'
              FROM  fusionax_anciens AS ax
        INNER JOIN  auth_user_md5    AS u ON (ax.id_ancien = u.matricule_ax)
         LEFT JOIN  emails           AS e ON (e.uid = u.user_id AND e.flags = 'active')
             WHERE  Mel_usage != '' AND
                    Mel_usage NOT LIKE '%@polytechnique.edu' AND
                    Mel_usage NOT LIKE '%@polytechnique.org' AND
                    Mel_usage NOT LIKE '%@m4x.org' AND
                    Mel_usage NOT LIKE '%@melix.%' AND
                    e.email IS NULL;

-- vim:set syntax=mysql:
Commit	Line	Data
b715c1e1 SJ	1	INSERT INTO profile_directory (uid, email_directory)
	2	SELECT user_id, Mel_usage
	3	FROM fusionax_anciens AS ax
22f043e4	4	INNER JOIN auth_user_md5 AS u ON (ax.id_ancien = u.matricule_ax)
b715c1e1 SJ	5	WHERE Mel_publiable != '0' AND Mel_usage != '';
b715c1e1 SJ	6
b715c1e1 SJ	7	INSERT IGNORE INTO register_marketing (uid, email, type)
	8	SELECT user_id, Mel_usage, 'ax'
	9	FROM fusionax_anciens AS ax
22f043e4	10	INNER JOIN auth_user_md5 AS u ON (ax.id_ancien = u.matricule_ax)
b715c1e1 SJ	11	LEFT JOIN emails AS e ON (e.uid = u.user_id AND e.flags = 'active')
	12	WHERE Mel_usage != '' AND
	13	Mel_usage NOT LIKE '%@polytechnique.edu' AND
	14	Mel_usage NOT LIKE '%@polytechnique.org' AND
	15	Mel_usage NOT LIKE '%@m4x.org' AND
	16	Mel_usage NOT LIKE '%@melix.%' AND
	17	e.email IS NULL;
	18
424fb311	19	-- vim:set syntax=mysql: