maintenance/archives/patch-user_email_token.sql


1
2
3
4
5
6
7
8
9
10
11
12

--
-- E-mail confirmation token and expiration timestamp,
-- for verification of e-mail addresses.
--
-- 2005-04-25
--

ALTER TABLE /*$wgDBprefix*/user
  ADD COLUMN user_email_authenticated CHAR(14) BINARY,
  ADD COLUMN user_email_token CHAR(32) BINARY,
  ADD COLUMN user_email_token_expires CHAR(14) BINARY,
  ADD INDEX (user_email_token);