| Index: trunk/phase3/maintenance/archives/patch-rev_bot.sql |
| — | — | @@ -1,5 +0,0 @@ |
| 2 | | -ALTER TABLE /*$wgDBprefix*/revision |
| 3 | | - ADD COLUMN rev_bot tinyint unsigned NOT NULL default 0 AFTER rev_deleted; |
| 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 |
| — | — | @@ -83,7 +83,6 @@ |
| 84 | 84 | array( 'oldimage', 'oi_metadata', 'patch-oi_metadata.sql'), |
| 85 | 85 | array( 'archive', 'ar_page_id', 'patch-archive-page_id.sql'), |
| 86 | 86 | array( 'image', 'img_sha1', 'patch-img_sha1.sql' ), |
| 87 | | - array( 'revision', 'rev_bot', 'patch-rev_bot.sql' ), |
| 88 | 87 | ); |
| 89 | 88 | |
| 90 | 89 | # For extensions only, should be populated via hooks |
| — | — | @@ -1032,8 +1031,6 @@ |
| 1033 | 1032 | |
| 1034 | 1033 | do_oldimage_user_index(); flush (); |
| 1035 | 1034 | |
| 1036 | | - do_revision_page_user_index(); flush (); |
| 1037 | | - |
| 1038 | 1035 | echo "Deleting old default messages (this may take a long time!)..."; flush(); |
| 1039 | 1036 | deleteDefaultMessages(); |
| 1040 | 1037 | echo "Done\n"; flush(); |
| — | — | @@ -1132,17 +1129,6 @@ |
| 1133 | 1130 | |
| 1134 | 1131 | } |
| 1135 | 1132 | |
| 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 | 1133 | function |
| 1148 | 1134 | pg_describe_table($table) |
| 1149 | 1135 | { |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -270,9 +270,6 @@ |
| 271 | 271 | -- Not yet used; reserved for future changes to the deletion system. |
| 272 | 272 | rev_deleted tinyint unsigned NOT NULL default '0', |
| 273 | 273 | |
| 274 | | - -- Was this edit made by a bot (and marked as such)? |
| 275 | | - rev_bot tinyint unsigned NOT NULL default '0', |
| 276 | | - |
| 277 | 274 | -- Length of this revision in bytes |
| 278 | 275 | rev_len int unsigned, |
| 279 | 276 | |
| — | — | @@ -285,8 +282,7 @@ |
| 286 | 283 | INDEX rev_timestamp (rev_timestamp), |
| 287 | 284 | INDEX page_timestamp (rev_page,rev_timestamp), |
| 288 | 285 | INDEX user_timestamp (rev_user,rev_timestamp), |
| 289 | | - INDEX usertext_timestamp (rev_user_text,rev_timestamp), |
| 290 | | - INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp) |
| | 286 | + INDEX usertext_timestamp (rev_user_text,rev_timestamp) |
| 291 | 287 | |
| 292 | 288 | ) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=1024; |
| 293 | 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 |
| — | — | @@ -2463,8 +2463,8 @@ |
| 2464 | 2464 | * |
| 2465 | 2465 | * @param Revision $rev |
| 2466 | 2466 | * |
| 2467 | | - * @todo This is a lousy interface function. Kill it and replace the |
| 2468 | | - * other cruddy functions like editUpdates and such so it's not needed |
| | 2467 | + * @todo This is a shitty interface function. Kill it and replace the |
| | 2468 | + * other shitty functions like editUpdates and such so it's not needed |
| 2469 | 2469 | * anymore. |
| 2470 | 2470 | */ |
| 2471 | 2471 | function createUpdates( $rev ) { |