upgrade/1.0.1/02_accounts.sql

   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: