- Patch #164532 by catch, pwolanin, David Strauss, et al.: improve table indicies for common queries.

1 files changed, 4 insertions, 2 deletions

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;