maintenance/archives/patch-user_email_token.sql

   1 --
   2 -- E-mail confirmation token and expiration timestamp,
   3 -- for verification of e-mail addresses.
   4 --
   5 -- 2005-04-25
   6 --
   7
   8 ALTER TABLE /*$wgDBprefix*/user
   9   ADD COLUMN user_email_authenticated CHAR(14) BINARY,
  10   ADD COLUMN user_email_token CHAR(32) BINARY,
  11   ADD COLUMN user_email_token_expires CHAR(14) BINARY,
  12   ADD INDEX (user_email_token);