summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-user_token.sql
blob: 797dc98f66a7c6780f6c7d27815ca9fe97325593 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
-- user_token patch
-- 2004-09-23

ALTER TABLE /*$wgDBprefix*/user ADD user_token char(32) binary NOT NULL default '';

UPDATE /*$wgDBprefix*/user SET user_token = concat(
	substring(rand(),3,4),
	substring(rand(),3,4),
	substring(rand(),3,4),
	substring(rand(),3,4),
	substring(rand(),3,4),
	substring(rand(),3,4),
	substring(rand(),3,4),
	substring(rand(),3,4)
);