maintenance/archives/patch-user_token.sql

   1 -- user_token patch
   2 -- 2004-09-23
   3
   4 ALTER TABLE user ADD user_token char(32) binary NOT NULL default '';
   5
   6 UPDATE user SET user_token = concat(
   7         substring(rand(),3,4),
   8         substring(rand(),3,4),
   9         substring(rand(),3,4),
  10         substring(rand(),3,4),
  11         substring(rand(),3,4),
  12         substring(rand(),3,4),
  13         substring(rand(),3,4),
  14         substring(rand(),3,4)
  15 );