File: patch-user_token.sql

package info (click to toggle)
mediawiki 1%3A1.27.4-1~bpo8%2B1
  • links: PTS, VCS
  • area: main
  • in suites: jessie-backports
  • size: 152,836 kB
  • sloc: php: 426,557; sql: 8,668; python: 3,484; xml: 2,201; pascal: 1,567; ruby: 1,017; perl: 789; sh: 612; makefile: 284
file content (15 lines) | stat: -rw-r--r-- 362 bytes parent folder | download | duplicates (8) 
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  binary(32) 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)
);