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 binary(14),
  ADD COLUMN user_email_token binary(32),
  ADD COLUMN user_email_token_expires binary(14),
  ADD INDEX (user_email_token);