diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-08 22:36:17 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-08 22:36:17 +0000 |
| commit | 3d5bdc6c8c6c552743ea602bc20316b20b11d765 (patch) | |
| tree | 75e70d7766f60894e02ef6793335d686df03757e | |
| parent | 7ffb762b04681c9fbe249d6afe6f26f4cd1a169c (diff) | |
| download | forums-3d5bdc6c8c6c552743ea602bc20316b20b11d765.tar forums-3d5bdc6c8c6c552743ea602bc20316b20b11d765.tar.gz forums-3d5bdc6c8c6c552743ea602bc20316b20b11d765.tar.bz2 forums-3d5bdc6c8c6c552743ea602bc20316b20b11d765.tar.xz forums-3d5bdc6c8c6c552743ea602bc20316b20b11d765.zip | |
Add index to poster_id in posts table
git-svn-id: file:///svn/phpbb/trunk@3614 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 427274fa7e..d997a84b00 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -349,7 +349,8 @@ CREATE TABLE phpbb_posts ( post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), KEY topic_id (topic_id), - KEY poster_ip (poster_ip) + KEY poster_ip (poster_ip), + KEY poster_id (poster_id) ); |