051da0c252fa9a0a8e086e52c07c2572075850b4
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
);
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';