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

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:
Commit	Line	Data
29459c49 SJ	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);
424fb311 SJ	7
424fb311 SJ	8	-- vim:set syntax=mysql: