X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fmerge-0.0.1%2F00_names.sql;h=1bce81d5c7c5ab8419fe09330a1b94ce88a5353c;hb=4f35a3ca07b72943c53395ffc7ea49d493031940;hp=832c2a29acfcd6d8f0de808ae3b3054fc70f128b;hpb=7972436ae72911c7f2e8d5f3a26204a7ca0ee39d;p=platal.git

diff --git a/upgrade/merge-0.0.1/00_names.sql b/upgrade/merge-0.0.1/00_names.sql
index 832c2a2..1bce81d 100644
--- a/upgrade/merge-0.0.1/00_names.sql
+++ b/upgrade/merge-0.0.1/00_names.sql
@@ -1,9 +1,8 @@
-CREATE OR REPLACE ALGORITHM=MERGE VIEW fusionax_xorg_anciens AS
-    SELECT
-        u.user_id, u.matricule_ax, u.promo,
-        n.display AS display_name, n.sort AS sort_name,
-        u.nom, u.prenom
-    FROM `auth_user_md5` AS u
-    INNER JOIN `profile_names_display` AS n ON ( n.user_id = u.user_id );
+CREATE OR REPLACE ALGORITHM=MERGE VIEW  fusionax_xorg_anciens AS
+                                SELECT  u.user_id, u.matricule_ax, u.promo,
+                                        n.display AS display_name, n.sort AS sort_name,
+                                        u.nom, u.prenom
+                                  FROM  auth_user_md5         AS u
+                            INNER JOIN  profile_names_display AS n ON (n.user_id = u.user_id);
 
 -- vim:set syntax=mysql: