diff options
Diffstat (limited to 'phpBB/db/schemas')
| -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); /* -------------------------------------------------------- |