- Patch #554164 by catch: join on {forum} instead of {term_node} for forum queries.

1 files changed, 12 insertions, 1 deletions

diff --git a/modules/forum/forum.install b/modules/forum/forum.install
index 3b8702231..6ad9ee9b7 100644
--- a/modules/forum/forum.install
+++ b/modules/forum/forum.install
@@ -102,7 +102,7 @@ function forum_schema() {
       ),
     ),
     'indexes' => array(
-      'nid' => array('nid'),
+      'forum_topic' => array('nid', 'tid'),
       'tid' => array('tid'),
     ),
     'primary key' => array('vid'),
@@ -114,3 +114,14 @@ function forum_schema() {
 
   return $schema;
 }
+
+/**
+ * Add new index to forum table.
+ */
+function forum_update_7000() {
+  $ret = array();
+  db_drop_index($ret, 'forum', 'nid');
+  db_add_index($ret, 'forum', 'forum_topic', array('nid', 'tid'));
+
+  return $ret;
+}