https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113205
Revision: 113205
Author: catrope
Date: 2012-03-07 00:37:54 +0000 (Wed, 07 Mar 2012)
Log Message:
-----------
Followup r113062: this index needs af_page_id at the start too, hadn't realized
that until just now
Modified Paths:
--------------
trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql
Modified: trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql
===================================================================
--- trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql
2012-03-07 00:17:44 UTC (rev 113204)
+++ trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql
2012-03-07 00:37:54 UTC (rev 113205)
@@ -71,7 +71,7 @@
CREATE INDEX /*i*/article_feedback_timestamp ON /*_*/aft_article_feedback
(af_created);
CREATE INDEX /*i*/af_page_id ON /*_*/aft_article_feedback (af_page_id,
af_created);
CREATE INDEX /*i*/af_page_feedback_id ON /*_*/aft_article_feedback
(af_page_id, af_id);
-CREATE INDEX /*_*/af_net_helpfulness_af_id ON /*_*/aft_article_feedback
(af_net_helpfulness, af_id);
+CREATE INDEX /*_*/af_page_net_helpfulness_af_id ON /*_*/aft_article_feedback
(af_page_id, af_net_helpfulness, af_id);
-- Allows for organizing fields into fieldsets, for reporting or rendering.
-- A group is just a name and an ID.
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
