r33382 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r33381‎ | r33382 | r33383 >
Date:18:31, 15 April 2008
Author:aaron
Status:old
Tags:
Comment:
Simplify index
Modified paths:
  • /trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql (modified) (history)
  • /trunk/extensions/FlaggedRevs/FlaggedRevs.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/FlaggedRevs/FlaggedRevs.sql
@@ -91,5 +91,5 @@
9292 -- Note that this may not be set to display by default though.
9393 ADD page_ext_quality tinyint(1) default NULL,
9494
95 - ADD INDEX ext_namespace_reviewed (page_namespace,page_is_redirect,page_ext_reviewed,page_id),
 95+ ADD INDEX ext_namespace_reviewed (page_namespace,page_ext_reviewed,page_id),
9696 ADD INDEX ext_namespace_quality (page_namespace,page_ext_quality,page_title);
Index: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql
@@ -51,7 +51,7 @@
5252 ADD page_ext_stable INTEGER NULL,
5353 ADD page_ext_quality SMALLINT DEFAULT NULL;
5454
55 -CREATE INDEX ext_namespace_reviewed ON page (page_namespace,page_is_redirect,page_ext_reviewed,page_id);
 55+CREATE INDEX ext_namespace_reviewed ON page (page_namespace,page_ext_reviewed,page_id);
5656 CREATE INDEX ext_namespace_quality ON page (page_namespace,page_ext_quality,page_title);
5757
5858 COMMIT;

Status & tagging log