Clean up e-mail authentication code.

* Add Special:Confirmemail unlisted page for requesting confirmation emails and as the destination
* There is now a confirmation token separate from the login password, which is cleaner and hopefully a lot less confusing.
* Confirmation token expires after 7 days
* Added support functions for nullable timestamp columns: wfTimestampOrNull and Database::timestampOrNull
* userMailer now returns WikiError objects
* Added convenience functions to User for email management, consolidated some checks

There are changes to the user table, so run update.php

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 000000000000..d4d633b776cd
--- /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);