From fe2c0f1ba082bd3d30696551b1fdc49e4aea5ed4 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 9 Aug 2007 14:58:02 +0000 Subject: [PATCH] Add rc_patrolling index to Postgres schema --- maintenance/postgres/tables.sql | 1 + maintenance/tables.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index fbcc135692..30ea077711 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -344,6 +344,7 @@ 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 21e925d789..d76e5a85fa 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -880,7 +880,7 @@ CREATE TABLE /*$wgDBprefix*/recentchanges ( 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_patrolling (rc_this_oldid, rc_last_oldid, rc_patrolled) ) /*$wgDBTableOptions*/; -- 2.20.1