From e00f620dbc598be62b1a2aa7b84afec3f3863107 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Thu, 20 Aug 2009 14:58:30 +0000
Subject: - Patch #554164 by catch: join on {forum} instead of {term_node} for
 forum queries.

---
 modules/forum/forum.install | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'modules/forum/forum.install')

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;
+}
-- 
cgit v1.2.3