From ca7ea84a7489d5385726292f5301907ef07a4ae6 Mon Sep 17 00:00:00 2001 From: Yuri Astrakhan Date: Fri, 22 Jun 2007 15:19:55 +0000 Subject: [PATCH] Forgot to update table sql per bug 10280 --- maintenance/postgres/tables.sql | 2 +- maintenance/tables.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index c6bd87dd81..5d2868c016 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -177,7 +177,7 @@ CREATE TABLE categorylinks ( cl_timestamp TIMESTAMPTZ NOT NULL ); CREATE UNIQUE INDEX cl_from ON categorylinks (cl_from, cl_to); -CREATE INDEX cl_sortkey ON categorylinks (cl_to, cl_sortkey); +CREATE INDEX cl_sortkey ON categorylinks (cl_to, cl_sortkey, cl_from); CREATE TABLE externallinks ( el_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, diff --git a/maintenance/tables.sql b/maintenance/tables.sql index c32653665a..02b61a2805 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -473,7 +473,7 @@ CREATE TABLE /*$wgDBprefix*/categorylinks ( UNIQUE KEY cl_from (cl_from,cl_to), -- We always sort within a given category... - KEY cl_sortkey (cl_to,cl_sortkey), + KEY cl_sortkey (cl_to,cl_sortkey,cl_from), -- Not really used? KEY cl_timestamp (cl_to,cl_timestamp) -- 2.20.1