Commit | Line | Data |
---|---|---|
92b37ea3 VZ |
1 | # Creates a new column for the hruid field, and adds an index on it. |
2 | ALTER TABLE auth_user_md5 | |
3 | ADD COLUMN hruid VARCHAR(255) DEFAULT NULL AFTER user_id, | |
4 | ADD UNIQUE INDEX hruid(hruid); | |
5 | ||
6 | ||
7 | # Pre-fills the hruid field with the current forlife. | |
8 | UPDATE auth_user_md5 AS u | |
9 | LEFT JOIN aliases AS a ON (a.id = u.user_id AND a.type = 'a_vie') | |
10 | SET u.hruid = a.alias | |
11 | WHERE a.alias IS NOT NULL AND u.hruid IS NULL; | |
12 | ||
13 | # vim:set syntax=mysql: |