http://www.mediawiki.org/wiki/Special:Code/MediaWiki/96786
Revision: 96786
Author: jeroendedauw
Date: 2011-09-11 15:32:43 +0000 (Sun, 11 Sep 2011)
Log Message:
-----------
added indexes to answers table
Modified Paths:
--------------
trunk/extensions/Survey/Survey.hooks.php
Added Paths:
-----------
trunk/extensions/Survey/sql/Survey_indexQuestionId.sql
trunk/extensions/Survey/sql/Survey_indexSubmissionId.sql
Modified: trunk/extensions/Survey/Survey.hooks.php
===================================================================
--- trunk/extensions/Survey/Survey.hooks.php 2011-09-11 15:24:19 UTC (rev
96785)
+++ trunk/extensions/Survey/Survey.hooks.php 2011-09-11 15:32:43 UTC (rev
96786)
@@ -85,6 +85,20 @@
dirname( __FILE__ ) . '/sql/Survey_indexSurveyName.sql',
true
) );
+ $updater->addExtensionUpdate( array(
+ 'addIndex',
+ 'survey_answers',
+ 'answer_question_id',
+ dirname( __FILE__ ) . '/sql/Survey_indexQuestionId.sql',
+ true
+ ) );
+ $updater->addExtensionUpdate( array(
+ 'addIndex',
+ 'survey_answers',
+ 'answer_submission_id',
+ dirname( __FILE__ ) .
'/sql/Survey_indexSubmissionId.sql',
+ true
+ ) );
return true;
}
Added: trunk/extensions/Survey/sql/Survey_indexQuestionId.sql
===================================================================
--- trunk/extensions/Survey/sql/Survey_indexQuestionId.sql
(rev 0)
+++ trunk/extensions/Survey/sql/Survey_indexQuestionId.sql 2011-09-11
15:32:43 UTC (rev 96786)
@@ -0,0 +1 @@
+CREATE INDEX /*i*/surveys_question_id ON /*_*/survey_answers
(answer_question_id);
\ No newline at end of file
Property changes on: trunk/extensions/Survey/sql/Survey_indexQuestionId.sql
___________________________________________________________________
Added: svn:eol-style
+ native
Added: trunk/extensions/Survey/sql/Survey_indexSubmissionId.sql
===================================================================
--- trunk/extensions/Survey/sql/Survey_indexSubmissionId.sql
(rev 0)
+++ trunk/extensions/Survey/sql/Survey_indexSubmissionId.sql 2011-09-11
15:32:43 UTC (rev 96786)
@@ -0,0 +1 @@
+CREATE INDEX /*i*/surveys_submission_id ON /*_*/survey_answers
(answer_submission_id);
\ No newline at end of file
Property changes on: trunk/extensions/Survey/sql/Survey_indexSubmissionId.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
