| Index: trunk/phase3/maintenance/archives/patch-rc_patrol_index.sql |
| — | — | @@ -1,4 +0,0 @@ |
| 2 | | -ALTER TABLE /*$wgDBprefix*/recentchanges |
| 3 | | - ADD INDEX `rc_patrolling` ( `rc_this_oldid` , `rc_last_oldid` , `rc_patrolled` ); |
| \ No newline at end of file |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -344,7 +344,6 @@ |
| 345 | 345 | CREATE INDEX rc_cur_id ON recentchanges (rc_cur_id); |
| 346 | 346 | CREATE INDEX new_name_timestamp ON recentchanges (rc_new, rc_namespace, rc_timestamp); |
| 347 | 347 | CREATE INDEX rc_ip ON recentchanges (rc_ip); |
| 348 | | -CREATE INDEX rc_patrolling ON recentchanges (rc_this_oldid, rc_last_oldid, rc_patrolled); |
| 349 | 348 | |
| 350 | 349 | |
| 351 | 350 | CREATE TABLE watchlist ( |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -860,7 +860,6 @@ |
| 861 | 861 | $indexes = array( |
| 862 | 862 | 'rc_ns_usertext' => 'patch-recentchanges-utindex.sql', |
| 863 | 863 | 'rc_user_text' => 'patch-rc_user_text-index.sql', |
| 864 | | - 'rc_patrolling' => 'patch-rc_patrol_index.sql', |
| 865 | 864 | ); |
| 866 | 865 | |
| 867 | 866 | foreach( $indexes as $index => $patch ) { |
| — | — | @@ -1369,7 +1368,6 @@ |
| 1370 | 1369 | array("archive", "archive_user_text", "(ar_user_text)"), |
| 1371 | 1370 | array("image", "img_sha1", "(img_sha1)"), |
| 1372 | 1371 | array("oldimage", "oi_sha1", "(oi_sha1)"), |
| 1373 | | - array("recentchanges", "rc_patrolling", "(rc_this_oldid, rc_last_oldid, rc_patrolled)"), |
| 1374 | 1372 | array("revision", "rev_text_id_idx", "(rev_text_id)"), |
| 1375 | 1373 | ); |
| 1376 | 1374 | |
| — | — | @@ -1530,4 +1528,4 @@ |
| 1531 | 1529 | } |
| 1532 | 1530 | |
| 1533 | 1531 | return; |
| 1534 | | -} |
| \ No newline at end of file |
| | 1532 | +} |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -882,8 +882,7 @@ |
| 883 | 883 | INDEX new_name_timestamp (rc_new,rc_namespace,rc_timestamp), |
| 884 | 884 | INDEX rc_ip (rc_ip), |
| 885 | 885 | INDEX rc_ns_usertext (rc_namespace, rc_user_text), |
| 886 | | - INDEX rc_user_text (rc_user_text, rc_timestamp), |
| 887 | | - INDEX rc_patrolling (rc_this_oldid, rc_last_oldid, rc_patrolled) |
| | 886 | + INDEX rc_user_text (rc_user_text, rc_timestamp) |
| 888 | 887 | |
| 889 | 888 | ) /*$wgDBTableOptions*/; |
| 890 | 889 | |