[platal.git] / upgrade / 1.1.1 / 02_emails.sql

    DELETE  e2
      FROM  email_virtual AS e1
INNER JOIN  email_virtual AS e2
     WHERE  e1.email = e2.email AND e1.domain = e2.domain AND e1.redirect != e2.redirect
            AND e1.redirect = REPLACE(e2.redirect, '@m4x.org', '@polytechnique.org');
UPDATE  email_virtual
   SET  redirect = REPLACE(redirect, '@m4x.org', '@polytechnique.org')
 WHERE  redirect LIKE '%@m4x.org';

-- vim:set syntax=mysql:
Commit	Line	Data
42c3833f SJ	1	DELETE e2
	2	FROM email_virtual AS e1
	3	INNER JOIN email_virtual AS e2
120baaa5 SJ	4	WHERE e1.email = e2.email AND e1.domain = e2.domain AND e1.redirect != e2.redirect
120baaa5 SJ	5	AND e1.redirect = REPLACE(e2.redirect, '@m4x.org', '@polytechnique.org');
42c3833f SJ	6	UPDATE email_virtual
	7	SET redirect = REPLACE(redirect, '@m4x.org', '@polytechnique.org')
	8	WHERE redirect LIKE '%@m4x.org';
	9
	10	-- vim:set syntax=mysql: