| Index: trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql |
| — | — | @@ -0,0 +1,5 @@ |
| | 2 | +-- New index on revision table to allow searches for all edits by a given user |
| | 3 | +-- to a given page. Added 2007-08-28 |
| | 4 | + |
| | 5 | +ALTER TABLE /*$wgDBprefix*/revision |
| | 6 | + ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); |
| Property changes on: trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 7 | + native |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -326,6 +326,7 @@ |
| 327 | 327 | CREATE INDEX /*i*/page_timestamp ON /*_*/revision (rev_page,rev_timestamp); |
| 328 | 328 | CREATE INDEX /*i*/user_timestamp ON /*_*/revision (rev_user,rev_timestamp); |
| 329 | 329 | CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision (rev_user_text,rev_timestamp); |
| | 330 | +CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); |
| 330 | 331 | |
| 331 | 332 | -- |
| 332 | 333 | -- Holds text of individual page revisions. |
| Index: trunk/phase3/includes/installer/MysqlUpdater.php |
| — | — | @@ -195,6 +195,7 @@ |
| 196 | 196 | |
| 197 | 197 | // 1.20 |
| 198 | 198 | array( 'addTable', 'config', 'patch-config.sql' ), |
| | 199 | + array( 'addIndex', 'revision'. 'page_user_timestamp', 'patch-revision-user-page-index.sql' ), |
| 199 | 200 | ); |
| 200 | 201 | } |
| 201 | 202 | |
| Index: trunk/phase3/includes/installer/SqliteUpdater.php |
| — | — | @@ -74,6 +74,7 @@ |
| 75 | 75 | |
| 76 | 76 | // 1.20 |
| 77 | 77 | array( 'addTable', 'config', 'patch-config.sql' ), |
| | 78 | + array( 'addIndex', 'revision'. 'page_user_timestamp', 'patch-revision-user-page-index.sql' ), |
| 78 | 79 | ); |
| 79 | 80 | } |
| 80 | 81 | |