diff options
| author | Dries Buytaert <dries@buytaert.net> | 2008-01-05 22:45:40 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2008-01-05 22:45:40 +0000 |
| commit | 7127adabb0fd7add82a92200b1e56372f1163882 (patch) | |
| tree | 9435f95cc519a12a451cf29fa1b3064808086ff0 | |
| parent | dc2cd5ea4dc1340abf9b2499974e0811a24e8a2d (diff) | |
| download | brdo-7127adabb0fd7add82a92200b1e56372f1163882.tar.gz brdo-7127adabb0fd7add82a92200b1e56372f1163882.tar.bz2 | |
- Patch #205465 by jvandyk: add missing index on comment table.
| -rw-r--r-- | modules/comment/comment.install | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/modules/comment/comment.install b/modules/comment/comment.install index 48e0f7b6e..7da948b0e 100644 --- a/modules/comment/comment.install +++ b/modules/comment/comment.install @@ -59,6 +59,15 @@ function comment_update_6002() { } /** + * Add index to parent ID field. + */ +function comment_update_6003() { + $ret[] = update_sql("ALTER TABLE {comments} ADD KEY pid (pid)"); + return $ret; +} + + +/** * Implementation of hook_schema(). */ function comment_schema() { @@ -155,6 +164,7 @@ function comment_schema() { ) ), 'indexes' => array( + 'pid' => array('pid'), 'nid' => array('nid'), 'status' => array('status'), // This index is probably unused ), |