| Index: trunk/extensions/CodeReview/CodeReview.php |
| — | — | @@ -213,6 +213,9 @@ |
| 214 | 214 | "$base/archives/code_signoffs_userid.sql", true ) ); |
| 215 | 215 | $updater->addExtensionUpdate( array( 'addField', 'code_signoffs', 'cs_timestamp_struck', |
| 216 | 216 | "$base/archives/code_signoffs_timestamp_struck.sql", true ) ); |
| | 217 | + |
| | 218 | + $updater->addExtensionUpdate( array( 'addIndex', 'code_comments', 'cc_author', |
| | 219 | + "$base/archives/code_comment_author-index.sql", true ) ); |
| 217 | 220 | break; |
| 218 | 221 | case 'sqlite': |
| 219 | 222 | $updater->addExtensionUpdate( array( 'addTable', 'code_rev', "$base/codereview.sql", true ) ); |
| Index: trunk/extensions/CodeReview/codereview.sql |
| — | — | @@ -194,6 +194,7 @@ |
| 195 | 195 | |
| 196 | 196 | CREATE INDEX /*i*/cc_repo_id ON /*_*/code_comment (cc_repo_id,cc_rev_id,cc_sortkey); |
| 197 | 197 | CREATE INDEX /*i*/cc_repo_time ON /*_*/code_comment (cc_repo_id,cc_timestamp); |
| | 198 | +CREATE INDEX /*i*/cc_author ON /*_*/code_comment (cc_repo_id, cc_user_text, cc_timestamp); |
| 198 | 199 | |
| 199 | 200 | -- |
| 200 | 201 | -- Changes to review metadata for a single code revision. |
| Index: trunk/extensions/CodeReview/archives/code_comment_author-index.sql |
| — | — | @@ -0,0 +1,2 @@ |
| | 2 | +ALTER TABLE /*$wgDBprefix*/code_comment |
| | 3 | + ADD key /*i*/cc_author (cc_repo_id, cc_user_text, cc_timestamp); |
| Property changes on: trunk/extensions/CodeReview/archives/code_comment_author-index.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 4 | + native |