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: |