0337d704 |
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 |
aab2ffdd |
8 | left join aliases AS b |
0337d704 |
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'; |