From f0ee7f9b4a1d091a57ef236c6550b4ab7549731f Mon Sep 17 00:00:00 2001 From: Roan Kattouw Date: Fri, 11 Nov 2011 16:37:38 +0000 Subject: [PATCH] Followup r102785, fix wrong index order in tables.sql. The patches are fine --- maintenance/tables.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 865299372c..2121b08b8a 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -265,7 +265,7 @@ CREATE TABLE /*_*/page ( CREATE UNIQUE INDEX /*i*/name_title ON /*_*/page (page_namespace,page_title); CREATE INDEX /*i*/page_random ON /*_*/page (page_random); CREATE INDEX /*i*/page_len ON /*_*/page (page_len); -CREATE INDEX /*i*/page_len_redirect_namespace ON /*_*/page (page_len, page_is_redirect, page_namespace); +CREATE INDEX /*i*/page_redirect_namespace_len ON /*_*/page (page_is_redirect, page_namespace, page_len); -- -- Every edit of a page creates also a revision row. -- 2.20.1