diff options
| author | David Rothstein <drothstein@gmail.com> | 2012-06-03 14:32:18 -0400 |
|---|---|---|
| committer | David Rothstein <drothstein@gmail.com> | 2012-06-03 14:32:18 -0400 |
| commit | c2fd99425cac4a26714b60d3d8eac11096c140c2 (patch) | |
| tree | 0cee0f09add26f1fd6172f0f521d5f3f50ad1ee8 /modules/forum | |
| parent | f7b54a48e964fc3689de58cf0b07d55e4b0e2b98 (diff) | |
| download | brdo-c2fd99425cac4a26714b60d3d8eac11096c140c2.tar.gz brdo-c2fd99425cac4a26714b60d3d8eac11096c140c2.tar.bz2 | |
Issue #1354726 by damiankloip, develCuy, gnuget, droplet, cha0s | bvanmeurs: Add more indexes on {forum_index}.
Diffstat (limited to 'modules/forum')
| -rw-r--r-- | modules/forum/forum.install | 10 |
1 files changed, 10 insertions, 0 deletions
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')); +} |