upgrade/1.1.1/02_emails.sql

   1     DELETE  e2
   2       FROM  email_virtual AS e1
   3 INNER JOIN  email_virtual AS e2
   4      WHERE  e1.email = e2.email AND e1.domain = e2.domain AND e1.redirect != e2.redirect
   5             AND e1.redirect = REPLACE(e2.redirect, '@m4x.org', '@polytechnique.org');
   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: