From c8b1ddf26a299016c433c2901e519942d693430d Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 18 Dec 2007 12:59:22 +0000 Subject: - Patch #164532 by catch, pwolanin, David Strauss, et al.: improve table indicies for common queries. --- modules/comment/comment.install | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'modules/comment') diff --git a/modules/comment/comment.install b/modules/comment/comment.install index 0cfc026db..d944f3b71 100644 --- a/modules/comment/comment.install +++ b/modules/comment/comment.install @@ -156,7 +156,7 @@ function comment_schema() { ), 'indexes' => array( 'nid' => array('nid'), - 'status' => array('status') + 'status' => array('status'), // This index is probably unused ), 'primary key' => array('cid'), ); @@ -197,8 +197,10 @@ function comment_schema() { 'description' => t('The total number of comments on this node.'), ), ), - 'indexes' => array('node_comment_timestamp' => array('last_comment_timestamp')), 'primary key' => array('nid'), + 'indexes' => array( + 'node_comment_timestamp' => array('last_comment_timestamp') + ), ); return $schema; -- cgit v1.2.3