From 7843a9e533260ef42fdfab4f889f0c79da4dc41a Mon Sep 17 00:00:00 2001 From: Sean Pringle Date: Mon, 16 Feb 2015 16:16:58 +1000 Subject: [PATCH] Reorder backlinks indexes Bug: T89630 Change-Id: I2b04268545b9a88c584f6461f67a38fe3944c17a --- maintenance/archives/patch-il_from_namespace.sql | 2 +- maintenance/archives/patch-pl_from_namespace.sql | 2 +- maintenance/archives/patch-tl_from_namespace.sql | 2 +- maintenance/tables.sql | 6 +++--- 4 files changed, 6 insertions(+), 6 deletions(-) diff --git a/maintenance/archives/patch-il_from_namespace.sql b/maintenance/archives/patch-il_from_namespace.sql index 4c858f44fc..2a2d361be4 100644 --- a/maintenance/archives/patch-il_from_namespace.sql +++ b/maintenance/archives/patch-il_from_namespace.sql @@ -1,4 +1,4 @@ ALTER TABLE /*_*/imagelinks ADD COLUMN il_from_namespace int NOT NULL default 0; -CREATE INDEX /*i*/il_backlinks_namespace ON /*_*/imagelinks (il_to,il_from_namespace,il_from); \ No newline at end of file +CREATE INDEX /*i*/il_backlinks_namespace ON /*_*/imagelinks (il_from_namespace,il_to,il_from); \ No newline at end of file diff --git a/maintenance/archives/patch-pl_from_namespace.sql b/maintenance/archives/patch-pl_from_namespace.sql index 2f7ff046dd..dcf2b60a1f 100644 --- a/maintenance/archives/patch-pl_from_namespace.sql +++ b/maintenance/archives/patch-pl_from_namespace.sql @@ -1,4 +1,4 @@ ALTER TABLE /*_*/pagelinks ADD COLUMN pl_from_namespace int NOT NULL default 0; -CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_namespace,pl_title,pl_from_namespace,pl_from); +CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_from_namespace,pl_namespace,pl_title,pl_from); diff --git a/maintenance/archives/patch-tl_from_namespace.sql b/maintenance/archives/patch-tl_from_namespace.sql index 8d6c76b866..edfb7a5280 100644 --- a/maintenance/archives/patch-tl_from_namespace.sql +++ b/maintenance/archives/patch-tl_from_namespace.sql @@ -1,4 +1,4 @@ ALTER TABLE /*_*/templatelinks ADD COLUMN tl_from_namespace int NOT NULL default 0; -CREATE INDEX /*i*/tl_backlinks_namespace ON /*_*/templatelinks (tl_namespace,tl_title,tl_from_namespace,tl_from); +CREATE INDEX /*i*/tl_backlinks_namespace ON /*_*/templatelinks (tl_from_namespace,tl_namespace,tl_title,tl_from); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 112ac0534c..cc6a16968d 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -490,7 +490,7 @@ CREATE TABLE /*_*/pagelinks ( CREATE UNIQUE INDEX /*i*/pl_from ON /*_*/pagelinks (pl_from,pl_namespace,pl_title); CREATE INDEX /*i*/pl_namespace ON /*_*/pagelinks (pl_namespace,pl_title,pl_from); -CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_namespace,pl_title,pl_from_namespace,pl_from); +CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_from_namespace,pl_namespace,pl_title,pl_from); -- @@ -512,7 +512,7 @@ CREATE TABLE /*_*/templatelinks ( CREATE UNIQUE INDEX /*i*/tl_from ON /*_*/templatelinks (tl_from,tl_namespace,tl_title); CREATE INDEX /*i*/tl_namespace ON /*_*/templatelinks (tl_namespace,tl_title,tl_from); -CREATE INDEX /*i*/tl_backlinks_namespace ON /*_*/templatelinks (tl_namespace,tl_title,tl_from_namespace,tl_from); +CREATE INDEX /*i*/tl_backlinks_namespace ON /*_*/templatelinks (tl_from_namespace,tl_namespace,tl_title,tl_from); -- @@ -534,7 +534,7 @@ CREATE TABLE /*_*/imagelinks ( CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to); CREATE INDEX /*i*/il_to ON /*_*/imagelinks (il_to,il_from); -CREATE INDEX /*i*/il_backlinks_namespace ON /*_*/imagelinks (il_to,il_from_namespace,il_from); +CREATE INDEX /*i*/il_backlinks_namespace ON /*_*/imagelinks (il_from_namespace,il_to,il_from); -- -- 2.20.1