From c2fd99425cac4a26714b60d3d8eac11096c140c2 Mon Sep 17 00:00:00 2001
From: David Rothstein <drothstein@gmail.com>
Date: Sun, 3 Jun 2012 14:32:18 -0400
Subject: Issue #1354726 by damiankloip, develCuy, gnuget, droplet, cha0s |
 bvanmeurs: Add more indexes on {forum_index}.

---
 modules/forum/forum.install | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'modules/forum')

diff --git a/modules/forum/forum.install b/modules/forum/forum.install
index 94911e62e..3bdead37f 100644
--- a/modules/forum/forum.install
+++ b/modules/forum/forum.install
@@ -219,6 +219,8 @@ function forum_schema() {
     ),
     'indexes' => array(
       'forum_topics' => array('nid', 'tid', 'sticky', 'last_comment_timestamp'),
+      'created' => array('created'),
+      'last_comment_timestamp' => array('last_comment_timestamp'),
     ),
     'foreign keys' => array(
       'tracked_node' => array(
@@ -455,3 +457,11 @@ function forum_update_7011() {
     ->condition('nid', $select, 'IN')
     ->execute();
 }
+
+ /**
+ * Add 'created' and 'last_comment_timestamp' indexes.
+ */
+function forum_update_7012() {
+  db_add_index('forum_index', 'created', array('created'));
+  db_add_index('forum_index', 'last_comment_timestamp', array('last_comment_timestamp'));
+}
-- 
cgit v1.2.3