summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-user_email_token.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-user_email_token.sql')
-rw-r--r--maintenance/archives/patch-user_email_token.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/maintenance/archives/patch-user_email_token.sql b/maintenance/archives/patch-user_email_token.sql
new file mode 100644
index 00000000..d4d633b7
--- /dev/null
+++ b/maintenance/archives/patch-user_email_token.sql
@@ -0,0 +1,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);