| 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'; |