| Index: trunk/extensions/CodeReview/CodeReview.php |
| — | — | @@ -285,6 +285,9 @@ |
| 286 | 286 | |
| 287 | 287 | $updater->addExtensionUpdate( array( 'addIndex', 'code_paths', 'repo_path', |
| 288 | 288 | "$base/archives/codereview-repopath.sql", true ) ); |
| | 289 | + |
| | 290 | + $updater->addExtensionUpdate( array( 'addIndex', 'code_revs', 'cr_repo_status_author', |
| | 291 | + "$base/archives/code_revs_status_author-index.sql", true ) ); |
| 289 | 292 | break; |
| 290 | 293 | case 'sqlite': |
| 291 | 294 | $updater->addExtensionUpdate( array( 'addTable', 'code_rev', "$base/codereview.sql", true ) ); |
| Index: trunk/extensions/CodeReview/codereview.sql |
| — | — | @@ -71,6 +71,7 @@ |
| 72 | 72 | |
| 73 | 73 | CREATE INDEX /*i*/cr_repo_id ON /*_*/code_rev (cr_repo_id, cr_timestamp); |
| 74 | 74 | CREATE INDEX /*i*/cr_repo_author ON /*_*/code_rev (cr_repo_id, cr_author, cr_timestamp); |
| | 75 | +CREATE INDEX /*i*/cr_repo_status_author ON /*_*/code_rev (cr_repo_id, cr_status, cr_author); |
| 75 | 76 | |
| 76 | 77 | -- |
| 77 | 78 | -- Allow us to match up repository usernames |
| Index: trunk/extensions/CodeReview/archives/code_revs_status_author-index.sql |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +CREATE INDEX /*i*/cr_repo_status_author ON /*_*/code_rev (cr_repo_id, cr_status, cr_author); |
| \ No newline at end of file |
| Property changes on: trunk/extensions/CodeReview/archives/code_revs_status_author-index.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 3 | + native |