[platal.git] / upgrade / 0.10.0 / 03_hruid.sql

# Creates a new column for the hruid field, and adds an index on it.
ALTER TABLE auth_user_md5
    ADD COLUMN hruid VARCHAR(255) DEFAULT NULL AFTER user_id,
    ADD UNIQUE INDEX hruid(hruid);


# Pre-fills the hruid field with the current forlife.
   UPDATE  auth_user_md5 AS u
LEFT JOIN  aliases AS a ON (a.id = u.user_id AND a.type = 'a_vie')
      SET  u.hruid = a.alias
    WHERE  a.alias IS NOT NULL AND u.hruid IS NULL;

# vim:set syntax=mysql:
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: