From c396f11ab311876c2907b233eaa75ffcb757cf0e Mon Sep 17 00:00:00 2001 From: Brad Jorsch Date: Tue, 3 Jun 2014 15:20:04 -0400 Subject: [PATCH] Add wl_user_notificationtimestamp index Bug: 65246 Change-Id: If3e9e855c8a21874ca69c4976af207833dcc53f2 --- includes/installer/MysqlUpdater.php | 1 + includes/installer/PostgresUpdater.php | 1 + includes/installer/SqliteUpdater.php | 1 + .../patch-watchlist-user-notificationtimestamp-index.sql | 4 ++++ maintenance/postgres/tables.sql | 1 + maintenance/tables.sql | 1 + 6 files changed, 9 insertions(+) create mode 100644 maintenance/archives/patch-watchlist-user-notificationtimestamp-index.sql diff --git a/includes/installer/MysqlUpdater.php b/includes/installer/MysqlUpdater.php index c5389213a5..2f77021986 100644 --- a/includes/installer/MysqlUpdater.php +++ b/includes/installer/MysqlUpdater.php @@ -254,6 +254,7 @@ class MysqlUpdater extends DatabaseUpdater { // 1.24 array( 'addField', 'page_props', 'pp_sortkey', 'patch-pp_sortkey.sql' ), array( 'dropField', 'recentchanges', 'rc_cur_time', 'patch-drop-rc_cur_time.sql' ), + array( 'addIndex', 'watchlist', 'wl_user_notificationtimestamp', 'patch-watchlist-user-notificationtimestamp-index.sql' ), ); } diff --git a/includes/installer/PostgresUpdater.php b/includes/installer/PostgresUpdater.php index 8c81080f37..e8de7de450 100644 --- a/includes/installer/PostgresUpdater.php +++ b/includes/installer/PostgresUpdater.php @@ -250,6 +250,7 @@ class PostgresUpdater extends DatabaseUpdater { array( 'addPgIndex', 'recentchanges', 'rc_timestamp_bot', '(rc_timestamp) WHERE rc_bot = 0' ), array( 'addPgIndex', 'templatelinks', 'templatelinks_from', '(tl_from)' ), array( 'addPgIndex', 'watchlist', 'wl_user', '(wl_user)' ), + array( 'addPgIndex', 'watchlist', 'wl_user_notificationtimestamp', '(wl_user, wl_notificationtimestamp)' ), array( 'addPgIndex', 'logging', 'logging_user_type_time', '(log_user, log_type, log_timestamp)' ), array( 'addPgIndex', 'logging', 'logging_page_id_time', '(log_page,log_timestamp)' ), diff --git a/includes/installer/SqliteUpdater.php b/includes/installer/SqliteUpdater.php index 7813115de2..111d654795 100644 --- a/includes/installer/SqliteUpdater.php +++ b/includes/installer/SqliteUpdater.php @@ -132,6 +132,7 @@ class SqliteUpdater extends DatabaseUpdater { // 1.24 array( 'addField', 'page_props', 'pp_sortkey', 'patch-pp_sortkey.sql' ), array( 'dropField', 'recentchanges', 'rc_cur_time', 'patch-drop-rc_cur_time.sql' ), + array( 'addIndex', 'watchlist', 'wl_user_notificationtimestamp', 'patch-watchlist-user-notificationtimestamp-index.sql' ), ); } diff --git a/maintenance/archives/patch-watchlist-user-notificationtimestamp-index.sql b/maintenance/archives/patch-watchlist-user-notificationtimestamp-index.sql new file mode 100644 index 0000000000..22ae44f196 --- /dev/null +++ b/maintenance/archives/patch-watchlist-user-notificationtimestamp-index.sql @@ -0,0 +1,4 @@ +-- +-- Creates the wl_user_notificationtimestamp index for the watchlist table +-- +CREATE INDEX /*i*/wl_user_notificationtimestamp ON /*_*/watchlist (wl_user, wl_notificationtimestamp); diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index abbfd3a166..be8cbdb46a 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -448,6 +448,7 @@ CREATE TABLE watchlist ( ); CREATE UNIQUE INDEX wl_user_namespace_title ON watchlist (wl_namespace, wl_title, wl_user); CREATE INDEX wl_user ON watchlist (wl_user); +CREATE INDEX wl_user_notificationtimestamp ON watchlist (wl_user, wl_notificationtimestamp); CREATE TABLE interwiki ( diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 1b8d618513..67696f29f5 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1129,6 +1129,7 @@ CREATE TABLE /*_*/watchlist ( CREATE UNIQUE INDEX /*i*/wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title); CREATE INDEX /*i*/namespace_title ON /*_*/watchlist (wl_namespace, wl_title); +CREATE INDEX /*i*/wl_user_notificationtimestamp ON /*_*/watchlist (wl_user, wl_notificationtimestamp); -- -- 2.20.1