diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2004-02-03 18:15:37 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2004-02-03 18:15:37 +0000 |
| commit | f8b89a8f94225955efc691c864f9d3ac83aadb1d (patch) | |
| tree | df46e8f591f85c5a0a3c394757e5f51a10039531 | |
| parent | 13f80fe2ef7a84923b3c3bd7741e65dcf799db93 (diff) | |
| download | forums-f8b89a8f94225955efc691c864f9d3ac83aadb1d.tar forums-f8b89a8f94225955efc691c864f9d3ac83aadb1d.tar.gz forums-f8b89a8f94225955efc691c864f9d3ac83aadb1d.tar.bz2 forums-f8b89a8f94225955efc691c864f9d3ac83aadb1d.tar.xz forums-f8b89a8f94225955efc691c864f9d3ac83aadb1d.zip | |
Update user table for email hashing? Suggested and implemented by lanzer ... we may as well give it a go too
git-svn-id: file:///svn/phpbb/trunk@4792 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index c07b6cbf28..31ecf18483 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -786,6 +786,7 @@ CREATE TABLE phpbb_users ( user_password varchar(32) DEFAULT '' NOT NULL, user_passchg int(11) DEFAULT '0' NOT NULL, user_email varchar(60) DEFAULT '' NOT NULL, + user_email_hash bigint(20) DEFAULT '0' NOT NULL, user_birthday varchar(10) DEFAULT '' NOT NULL, user_lastvisit int(11) DEFAULT '0' NOT NULL, user_lastpost_time int(11) DEFAULT '0' NOT NULL, @@ -837,6 +838,7 @@ CREATE TABLE phpbb_users ( user_newpasswd varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (user_id), KEY user_birthday (user_birthday(6)), + KEY user_email_hash (user_email_hash), KEY username (username) ); |