[platal.git] / upgrade / 1.0.1 / 02_accounts.sql

ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL;
UPDATE  accounts AS a
   SET  a.directory_name = (SELECT  pd.directory_name
                              FROM  profile_display  AS pd
                        INNER JOIN  account_profiles AS ap ON (ap.uid = pd.pid AND FIND_IN_SET('owner', perms))
                             WHERE  a.uid = ap.uid);

-- vim:set syntax=mysql:
Commit	Line	Data
d081acb2 SJ	1	ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL;
	2	UPDATE accounts AS a
	3	SET a.directory_name = (SELECT pd.directory_name
	4	FROM profile_display AS pd
	5	INNER JOIN account_profiles AS ap ON (ap.uid = pd.pid AND FIND_IN_SET('owner', perms))
	6	WHERE a.uid = ap.uid);
	7
	8	-- vim:set syntax=mysql: