From 74e1bf30a51bf4e8c1d335d2e40fb4bcc513bad7 Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Wed, 5 Sep 2007 08:14:18 +0000 Subject: [PATCH] destroy rc_patrolling index, no removers added, I hope not that many people did run update with that revision :) --- maintenance/archives/patch-rc_patrol_index.sql | 4 ---- maintenance/postgres/tables.sql | 1 - maintenance/tables.sql | 3 +-- maintenance/updaters.inc | 4 +--- 4 files changed, 2 insertions(+), 10 deletions(-) delete mode 100644 maintenance/archives/patch-rc_patrol_index.sql diff --git a/maintenance/archives/patch-rc_patrol_index.sql b/maintenance/archives/patch-rc_patrol_index.sql deleted file mode 100644 index d7062720f4..0000000000 --- a/maintenance/archives/patch-rc_patrol_index.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Index to speed up locating unpatrolled changes --- matching specific edit criteria -ALTER TABLE /*$wgDBprefix*/recentchanges - ADD INDEX `rc_patrolling` ( `rc_this_oldid` , `rc_last_oldid` , `rc_patrolled` ); \ No newline at end of file diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 6f91efaff5..360dd9cbac 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -344,7 +344,6 @@ CREATE INDEX rc_namespace_title ON recentchanges (rc_namespace, rc_title); CREATE INDEX rc_cur_id ON recentchanges (rc_cur_id); CREATE INDEX new_name_timestamp ON recentchanges (rc_new, rc_namespace, rc_timestamp); CREATE INDEX rc_ip ON recentchanges (rc_ip); -CREATE INDEX rc_patrolling ON recentchanges (rc_this_oldid, rc_last_oldid, rc_patrolled); CREATE TABLE watchlist ( diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 7477e5bea0..72a779a912 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -882,8 +882,7 @@ CREATE TABLE /*$wgDBprefix*/recentchanges ( INDEX new_name_timestamp (rc_new,rc_namespace,rc_timestamp), INDEX rc_ip (rc_ip), INDEX rc_ns_usertext (rc_namespace, rc_user_text), - INDEX rc_user_text (rc_user_text, rc_timestamp), - INDEX rc_patrolling (rc_this_oldid, rc_last_oldid, rc_patrolled) + INDEX rc_user_text (rc_user_text, rc_timestamp) ) /*$wgDBTableOptions*/; diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index aeab487131..3527d5eb48 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -860,7 +860,6 @@ function do_rc_indices_update() { $indexes = array( 'rc_ns_usertext' => 'patch-recentchanges-utindex.sql', 'rc_user_text' => 'patch-rc_user_text-index.sql', - 'rc_patrolling' => 'patch-rc_patrol_index.sql', ); foreach( $indexes as $index => $patch ) { @@ -1369,7 +1368,6 @@ function do_postgres_updates() { array("archive", "archive_user_text", "(ar_user_text)"), array("image", "img_sha1", "(img_sha1)"), array("oldimage", "oi_sha1", "(oi_sha1)"), - array("recentchanges", "rc_patrolling", "(rc_this_oldid, rc_last_oldid, rc_patrolled)"), array("revision", "rev_text_id_idx", "(rev_text_id)"), ); @@ -1530,4 +1528,4 @@ function do_postgres_updates() { } return; -} \ No newline at end of file +} -- 2.20.1