Index: trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql |
— | — | @@ -1,5 +0,0 @@ |
2 | | - |
3 | | -ALTER TABLE /*$wgDBprefix*/revision |
4 | | - ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); |
Index: trunk/phase3/maintenance/updaters.inc |
— | — | @@ -1032,8 +1032,6 @@ |
1033 | 1033 | |
1034 | 1034 | do_oldimage_user_index(); flush (); |
1035 | 1035 | |
1036 | | - do_revision_page_user_index(); flush (); |
1037 | | - |
1038 | 1036 | echo "Deleting old default messages (this may take a long time!)..."; flush(); |
1039 | 1037 | deleteDefaultMessages(); |
1040 | 1038 | echo "Done\n"; flush(); |
— | — | @@ -1132,17 +1130,6 @@ |
1133 | 1131 | |
1134 | 1132 | } |
1135 | 1133 | |
1136 | | -function do_revision_page_user_index() { |
1137 | | - global $wgDatabase; |
1138 | | - if( $wgDatabase->indexExists( 'revision', 'page_user_timestamp' ) ) { |
1139 | | - echo "...page,user,timestamp key on revision already exists.\n"; |
1140 | | - } else { |
1141 | | - echo "Adding page,user,timestamp key on revision table... "; |
1142 | | - dbsource( archive("patch-revision-user-page-index.sql"), $wgDatabase ); |
1143 | | - echo "ok\n"; |
1144 | | - } |
1145 | | -} |
1146 | | - |
1147 | 1134 | function |
1148 | 1135 | pg_describe_table($table) |
1149 | 1136 | { |
— | — | @@ -1542,4 +1529,4 @@ |
1543 | 1530 | } |
1544 | 1531 | |
1545 | 1532 | return; |
1546 | | -} |
| 1533 | +} |
\ No newline at end of file |
Index: trunk/phase3/maintenance/tables.sql |
— | — | @@ -282,8 +282,7 @@ |
283 | 283 | INDEX rev_timestamp (rev_timestamp), |
284 | 284 | INDEX page_timestamp (rev_page,rev_timestamp), |
285 | 285 | INDEX user_timestamp (rev_user,rev_timestamp), |
286 | | - INDEX usertext_timestamp (rev_user_text,rev_timestamp), |
287 | | - INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp) |
| 286 | + INDEX usertext_timestamp (rev_user_text,rev_timestamp) |
288 | 287 | |
289 | 288 | ) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=1024; |
290 | 289 | -- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit |
Index: trunk/phase3/includes/Article.php |
— | — | @@ -2461,8 +2461,8 @@ |
2462 | 2462 | * |
2463 | 2463 | * @param Revision $rev |
2464 | 2464 | * |
2465 | | - * @todo This is a lousy interface function. Kill it and replace the |
2466 | | - * other cruddy functions like editUpdates and such so it's not needed |
| 2465 | + * @todo This is a shitty interface function. Kill it and replace the |
| 2466 | + * other shitty functions like editUpdates and such so it's not needed |
2467 | 2467 | * anymore. |
2468 | 2468 | */ |
2469 | 2469 | function createUpdates( $rev ) { |