r45240 MediaWiki - Code Review archive

Repository:	MediaWiki
Revision:	< r45239‎ \| r45240 \| r45241 >
Date:	18:51, 31 December 2008
Author:	aaron
Status:	reverted
Tags:
Comment:	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
Modified paths:	/trunk/phase3/maintenance/archives/patch-user_restrictions.sql (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/archives/patch-user_restrictions.sql
—	—	@@ -29,7 +29,6 @@
30	30
31	31	PRIMARY KEY ur_id (ur_id),
32	32	-- For looking up restrictions for user and title
33		~~- INDEX ur_user (ur_user),~~
34	33	INDEX ur_user_page(ur_user,ur_page_namespace,ur_page_title(255)),
35	34	INDEX ur_user_namespace(ur_user,ur_namespace),
36	35	-- For Special:ListUserRestrictions

19:06, 31 December 2008 VasilievVV (talk | contribs) changed the status of r45240 [removed: new added: reverted]