[platal.git] / upgrade / 1.1.3 / 02_names.sql

UPDATE  profile_public_names
   SET  lastname_main = REPLACE(lastname_main, '  ', ' ')
 WHERE  lastname_main LIKE '%  %';

    UPDATE  accounts             AS a
INNER JOIN  account_profiles     AS ap  ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
INNER JOIN  profile_public_names AS ppn ON (ppn.pid = ap.pid)
INNER JOIN  profile_display      AS pd  ON (pd.pid = ap.pid)
       SET  a.lastname = IF(ppn.lastname_ordinary = '', ppn.lastname_main, ppn.lastname_ordinary)
     WHERE  a.type IN ('x', 'master', 'phd');

-- vim:set syntax=mysql:
Commit	Line	Data
7b3a37af SJ	1	UPDATE profile_public_names
	2	SET lastname_main = REPLACE(lastname_main, ' ', ' ')
	3	WHERE lastname_main LIKE '% %';
	4
	5	UPDATE accounts AS a
	6	INNER JOIN account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
	7	INNER JOIN profile_public_names AS ppn ON (ppn.pid = ap.pid)
	8	INNER JOIN profile_display AS pd ON (pd.pid = ap.pid)
	9	SET a.lastname = IF(ppn.lastname_ordinary = '', ppn.lastname_main, ppn.lastname_ordinary)
	10	WHERE a.type IN ('x', 'master', 'phd');
	11
	12	-- vim:set syntax=mysql: