Merge remote branch 'origin/platal-1.0.0'

[platal.git] / upgrade / merge-0.0.1 / 00_names.sql

diff --git a/upgrade/merge-0.0.1/00_names.sql b/upgrade/merge-0.0.1/00_names.sql
index 832c2a2..1bce81d 100644 (file)
--- 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: