1 files changed, 12 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-user_email_token.sql b/www/wiki/maintenance/archives/patch-user_email_token.sql
new file mode 100644
index 00000000..f8e66ca4
--- /dev/null
+++ b/www/wiki/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 binary(14),
+  ADD COLUMN user_email_token binary(32),
+  ADD COLUMN user_email_token_expires binary(14),
+  ADD INDEX (user_email_token);