-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);