diff options
| author | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-11-29 23:38:42 +0000 |
|---|---|---|
| committer | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-11-29 23:38:42 +0000 |
| commit | e403277ce206e9ba2a556ad0cd33817a81db8ace (patch) | |
| tree | 6602bed670d75d851a2de6701aedc53ce951c031 /phpBB/install | |
| parent | eb7cc50608b32d09c15eb321f8803268d9bff5bc (diff) | |
| download | forums-e403277ce206e9ba2a556ad0cd33817a81db8ace.tar forums-e403277ce206e9ba2a556ad0cd33817a81db8ace.tar.gz forums-e403277ce206e9ba2a556ad0cd33817a81db8ace.tar.bz2 forums-e403277ce206e9ba2a556ad0cd33817a81db8ace.tar.xz forums-e403277ce206e9ba2a556ad0cd33817a81db8ace.zip | |
Fixed cache table schema.
Added in index to username for validate_username() queries.
git-svn-id: file:///svn/phpbb/trunk@4697 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index d289578f71..f3a12e5d3f 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -112,7 +112,7 @@ CREATE TABLE phpbb_bots ( # Table: 'phpbb_cache' CREATE TABLE phpbb_cache ( var_name varchar(255) DEFAULT '' NOT NULL, - var_ts int(10) UNSIGNED DEFAULT '0' NOT NULL, + var_expires int(10) UNSIGNED DEFAULT '0' NOT NULL, var_data text NOT NULL, PRIMARY KEY (var_name) ); @@ -763,7 +763,8 @@ CREATE TABLE phpbb_users ( user_actkey varchar(32) DEFAULT '' NOT NULL, user_newpasswd varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (user_id), - KEY user_birthday (user_birthday(6)) + KEY user_birthday (user_birthday(6)), + KEY username (username) ); # Table: 'phpbb_users_notes' |