upgrade/0.9.3/10_aliases.sql

   1 alter table aliases add column flags set('epouse','bestalias') not null after type;
   2 update aliases set flags='epouse' where type='epouse';
   3 update aliases set type='epouse' where type='epouse';
   4 alter table aliases change column type type enum('a_vie','alias','homonyme','liste') not null;
   5 alter table aliases add index (flags);
   6
   7     update  aliases AS a
   8 left  join  aliases AS b
   9         ON(a.id=b.id and b.alias like '%.%' and length(b.alias)<length(a.alias) and b.type!='homonyme')
  10        set  a.flags=CONCAT(a.flags,',bestalias')
  11      where  a.alias LIKE '%.%' and b.alias IS NULL and a.type!='homonyme';