From 6c26b9033743b6551869ad3e14e47aa4eae99a76 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Wed, 31 Dec 2008 18:51:48 +0000 Subject: [PATCH] Remove ur_user index. We can just use the user_namespace to load all blocked namespaces, and the user_page index to to lookup for titles as needed --- maintenance/archives/patch-user_restrictions.sql | 1 - 1 file changed, 1 deletion(-) diff --git a/maintenance/archives/patch-user_restrictions.sql b/maintenance/archives/patch-user_restrictions.sql index b64146f013..535b9cd833 100644 --- a/maintenance/archives/patch-user_restrictions.sql +++ b/maintenance/archives/patch-user_restrictions.sql @@ -29,7 +29,6 @@ CREATE TABLE /*$wgDBprefix*/user_restrictions ( PRIMARY KEY ur_id (ur_id), -- For looking up restrictions for user and title - INDEX ur_user (ur_user), INDEX ur_user_page(ur_user,ur_page_namespace,ur_page_title(255)), INDEX ur_user_namespace(ur_user,ur_namespace), -- For Special:ListUserRestrictions -- 2.20.1