1 ALTER TABLE accounts
ADD COLUMN directory_name
VARCHAR(255) DEFAULT NULL;
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
))
8 -- vim:set syntax=mysql: