| Index: trunk/extensions/Survey/sql/Survey_indexQuestionId.sql |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +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 |
| 1 | 3 | + native |
| Index: trunk/extensions/Survey/sql/Survey_indexSubmissionId.sql |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +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 |
| 1 | 3 | + native |
| Index: trunk/extensions/Survey/Survey.hooks.php |
| — | — | @@ -85,6 +85,20 @@ |
| 86 | 86 | dirname( __FILE__ ) . '/sql/Survey_indexSurveyName.sql', |
| 87 | 87 | true |
| 88 | 88 | ) ); |
| | 89 | + $updater->addExtensionUpdate( array( |
| | 90 | + 'addIndex', |
| | 91 | + 'survey_answers', |
| | 92 | + 'answer_question_id', |
| | 93 | + dirname( __FILE__ ) . '/sql/Survey_indexQuestionId.sql', |
| | 94 | + true |
| | 95 | + ) ); |
| | 96 | + $updater->addExtensionUpdate( array( |
| | 97 | + 'addIndex', |
| | 98 | + 'survey_answers', |
| | 99 | + 'answer_submission_id', |
| | 100 | + dirname( __FILE__ ) . '/sql/Survey_indexSubmissionId.sql', |
| | 101 | + true |
| | 102 | + ) ); |
| 89 | 103 | |
| 90 | 104 | return true; |
| 91 | 105 | } |