upgrade/0.0.0_to_0.9.0/emails.sql

   1 --------------------------------------------------------------------------------
   2 -- emails
   3 --------------------------------------------------------------------------------
   4 update x4dat.emails set flags=CONCAT_WS(',',flags,'active') where find_in_set('filtre',flags);
   5 alter table x4dat.emails add column rewrite CHAR(128) NOT NULL after email;
   6 update x4dat.emails as e inner join x4dat.aliases as a ON(a.id=e.uid AND a.type='a_vie') set e.rewrite=CONCAT(a.alias,'@m4x.org') where find_in_set('m4x',flags);
   7 update x4dat.emails as e inner join x4dat.aliases as a ON(a.id=e.uid AND a.type='a_vie') set e.rewrite=CONCAT(a.alias,'@polytechnique.org') where find_in_set('rewrite',flags) AND rewrite='';
   8 alter table x4dat.emails change flags flags set('active','filter','mtic');
   9 update x4dat.emails set flags='filter' WHERE num=0;
  10 alter table x4dat.emails drop primary key;
  11 alter table x4dat.emails add index uid (uid);
  12 alter table x4dat.emails add primary key (uid,email);
  13 alter table x4dat.emails drop column num;
  14