upgrade/merge-0.0.1/00_names.sql

   1 CREATE OR REPLACE ALGORITHM=MERGE VIEW  fusionax_xorg_anciens AS
   2                                 SELECT  u.user_id, u.matricule_ax, u.promo,
   3                                         n.display AS display_name, n.sort AS sort_name,
   4                                         u.nom, u.prenom
   5                                   FROM  auth_user_md5         AS u
   6                             INNER JOIN  profile_names_display AS n ON (n.user_id = u.user_id);
   7
   8 -- vim:set syntax=mysql: