| Index: trunk/extensions/CodeReview/CodeReview.php |
| — | — | @@ -234,6 +234,9 @@ |
| 235 | 235 | |
| 236 | 236 | $updater->addExtensionUpdate( array( 'addIndex', 'code_comment', 'cc_author', |
| 237 | 237 | "$base/archives/code_comment_author-index.sql", true ) ); |
| | 238 | + |
| | 239 | + $updater->addExtensionUpdate( array( 'addIndex', 'code_prop_changes', 'cc_author', |
| | 240 | + "$base/archives/code_prop_changes_author-index.sql", true ) ); |
| 238 | 241 | break; |
| 239 | 242 | case 'sqlite': |
| 240 | 243 | $updater->addNewExtension( 'CodeReview', "$base/codereview.sql" ); |
| Index: trunk/extensions/CodeReview/codereview.sql |
| — | — | @@ -221,6 +221,7 @@ |
| 222 | 222 | |
| 223 | 223 | CREATE INDEX /*i*/cpc_repo_rev_time ON /*_*/code_prop_changes (cpc_repo_id, cpc_rev_id, cpc_timestamp); |
| 224 | 224 | CREATE INDEX /*i*/cpc_repo_time ON /*_*/code_prop_changes (cpc_repo_id, cpc_timestamp); |
| | 225 | +CREATE INDEX /*i*/cpc_author ON /*_*/code_prop_changes (cpc_repo_id, cpc_user_text, cpc_timestamp); |
| 225 | 226 | |
| 226 | 227 | CREATE TABLE /*_*/code_signoffs ( |
| 227 | 228 | -- Repository ID and revision ID |
| Index: trunk/extensions/CodeReview/archives/code_prop_changes_author-index.sql |
| — | — | @@ -0,0 +1,2 @@ |
| | 2 | +ALTER TABLE /*$wgDBprefix*/code_prop_changes |
| | 3 | + ADD KEY /*i*/cpc_author (cpc_repo_id, cpc_user_text, cpc_timestamp); |
| \ No newline at end of file |
| Property changes on: trunk/extensions/CodeReview/archives/code_prop_changes_author-index.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 4 | + native |