upgrade/merge-0.0.1/00_names.sql

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