[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
b41569dc	1	CREATE OR REPLACE ALGORITHM=MERGE VIEW fusionax_xorg_anciens AS
424fb311 SJ	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: