X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.3%2F10_aliases.sql;h=051da0c252fa9a0a8e086e52c07c2572075850b4;hb=2d89ec936167033886ae76b153605d7ccf19bc20;hp=42179212e0c27fb1568cbc8b4ad737dd2e4fafaf;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git

diff --git a/upgrade/0.9.3/10_aliases.sql b/upgrade/0.9.3/10_aliases.sql
index 4217921..051da0c 100644
--- a/upgrade/0.9.3/10_aliases.sql
+++ b/upgrade/0.9.3/10_aliases.sql
@@ -5,7 +5,7 @@ alter table aliases change column type type enum('a_vie','alias','homonyme','lis
 alter table aliases add index (flags);
 
     update  aliases AS a
-left  join  aliases AS b 
+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';