patch-user_token.sql

来自「php 开发的内容管理系统」· SQL 代码 · 共 16 行

-- 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)
);