Removes trailing spaces.

[platal.git] / upgrade / 0.9.3 / 10_aliases.sql

alter table aliases add column flags set('epouse','bestalias') not null after type;
update aliases set flags='epouse' where type='epouse';
update aliases set type='epouse' where type='epouse';
alter table aliases change column type type enum('a_vie','alias','homonyme','liste') not null;
alter table aliases add index (flags);

    update  aliases AS a
left  join  aliases AS b
	ON(a.id=b.id and b.alias like '%.%' and length(b.alias)<length(a.alias) and b.type!='homonyme')
       set  a.flags=CONCAT(a.flags,',bestalias')
     where  a.alias LIKE '%.%' and b.alias IS NULL and a.type!='homonyme';