http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97350
Revision: 97350
Author: asher
Date: 2011-09-17 00:20:38 +0000 (Sat, 17 Sep 2011)
Log Message:
-----------
adding index to ArticleFeedback for reporting
Modified Paths:
--------------
branches/REL1_18/extensions/ArticleFeedback/ArticleFeedback.hooks.php
branches/REL1_18/extensions/ArticleFeedback/sql/ArticleFeedback.sql
Added Paths:
-----------
branches/REL1_18/extensions/ArticleFeedback/sql/AddArticleFeedbackPageIndex.sql
Modified: branches/REL1_18/extensions/ArticleFeedback/ArticleFeedback.hooks.php
===================================================================
--- branches/REL1_18/extensions/ArticleFeedback/ArticleFeedback.hooks.php
2011-09-16 23:25:24 UTC (rev 97349)
+++ branches/REL1_18/extensions/ArticleFeedback/ArticleFeedback.hooks.php
2011-09-17 00:20:38 UTC (rev 97350)
@@ -174,6 +174,15 @@
true
) );
}
+ if ( !db->indexExists( 'article_feedback',
'aa_page_id', __METHOD__ ) ) {
+ $updater->addExtensionUpdate( array(
+ 'addIndex',
+ 'article_feedback',
+ 'aa_page_id',
+ $dir .
'/sql/AddArticleFeedbackPageIndex.sql',
+ true
+ ) );
+ }
$updater->addExtensionUpdate( array(
'addTable',
'article_feedback_properties',
Added:
branches/REL1_18/extensions/ArticleFeedback/sql/AddArticleFeedbackPageIndex.sql
===================================================================
---
branches/REL1_18/extensions/ArticleFeedback/sql/AddArticleFeedbackPageIndex.sql
(rev 0)
+++
branches/REL1_18/extensions/ArticleFeedback/sql/AddArticleFeedbackPageIndex.sql
2011-09-17 00:20:38 UTC (rev 97350)
@@ -0,0 +1 @@
+CREATE INDEX /*i*/aa_page_id ON /*_*/article_feedback (aa_page_id,
aa_timestamp);
Modified: branches/REL1_18/extensions/ArticleFeedback/sql/ArticleFeedback.sql
===================================================================
--- branches/REL1_18/extensions/ArticleFeedback/sql/ArticleFeedback.sql
2011-09-16 23:25:24 UTC (rev 97349)
+++ branches/REL1_18/extensions/ArticleFeedback/sql/ArticleFeedback.sql
2011-09-17 00:20:38 UTC (rev 97350)
@@ -35,6 +35,7 @@
PRIMARY KEY (aa_revision, aa_user_text, aa_rating_id, aa_user_anon_token)
) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/aa_user_page_revision ON /*_*/article_feedback (aa_user_id,
aa_page_id, aa_revision);
+CREATE INDEX /*i*/aa_page_id ON /*_*/article_feedback (aa_page_id,
aa_timestamp);
-- Aggregate rating table for a page
CREATE TABLE IF NOT EXISTS /*_*/article_feedback_pages (
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
