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