diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2002-01-11 13:15:49 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2002-01-11 13:15:49 +0000 |
| commit | 5792aeeb85de01b51f6e84577331463d9c311b00 (patch) | |
| tree | cee03c5ce485b08b26939106e0d2457c10653525 /phpBB/db | |
| parent | b3c8f779d6b6181a81444b9d1d6ba87a8e8370d9 (diff) | |
| download | forums-5792aeeb85de01b51f6e84577331463d9c311b00.tar forums-5792aeeb85de01b51f6e84577331463d9c311b00.tar.gz forums-5792aeeb85de01b51f6e84577331463d9c311b00.tar.bz2 forums-5792aeeb85de01b51f6e84577331463d9c311b00.tar.xz forums-5792aeeb85de01b51f6e84577331463d9c311b00.zip | |
Added index on topic_type (topics table)
git-svn-id: file:///svn/phpbb/trunk@1844 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 3 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 1 |
2 files changed, 3 insertions, 1 deletions
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index a15260e266..7efe88fee8 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -428,7 +428,8 @@ CREATE TABLE phpbb_topics ( PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_moved_id (topic_moved_id), - KEY topic_status (topic_status) + KEY topic_status (topic_status), + KEY topic_type (topic_type) ); diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 53d1126d7d..eb90729248 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -408,6 +408,7 @@ CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id); CREATE INDEX topic_moved_id_phpbb_topics_index ON phpbb_topics (topic_moved_id); CREATE INDEX topic_last_post_id_phpbb_topics_index ON phpbb_topics (topic_last_post_id); CREATE INDEX topic_status_phpbb_topics_index ON phpbb_topics (topic_status); +CREATE INDEX topic_type_phpbb_topics_index ON phpbb_topics (topic_type); /* -------------------------------------------------------- |