summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-user_email_token.sql
blob: d4d633b776cda10f7914b5c789bc1baa774f8a6b (plain)
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);