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
);
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')
11 WHERE a.
alias IS NOT NULL AND u.hruid
IS NULL;
13 # vim
:set syntax
=mysql
: