| Index: trunk/extensions/Survey/sql/AddMissingIndexes.sql |
| — | — | @@ -0,0 +1,21 @@ |
| | 2 | +-- SQL for the Survey extension. |
| | 3 | +-- Licence: GNU GPL v3+ |
| | 4 | +-- Author: Jeroen De Dauw < jeroendedauw@gmail.com > |
| | 5 | + |
| | 6 | +CREATE INDEX /*i*/surveys_survey_title ON /*_*/surveys (survey_title); |
| | 7 | +CREATE INDEX /*i*/surveys_survey_enabled ON /*_*/surveys (survey_enabled); |
| | 8 | +CREATE INDEX /*i*/surveys_survey_user_type ON /*_*/surveys (survey_user_type); |
| | 9 | +CREATE INDEX /*i*/surveys_survey_ratio ON /*_*/surveys (survey_ratio); |
| | 10 | +CREATE INDEX /*i*/surveys_survey_expiry ON /*_*/surveys (survey_expiry); |
| | 11 | +CREATE INDEX /*i*/surveys_survey_min_pages ON /*_*/surveys (survey_min_pages); |
| | 12 | + |
| | 13 | +CREATE INDEX /*i*/survey_questions_survey_id ON /*_*/survey_questions (question_survey_id); |
| | 14 | +CREATE INDEX /*i*/survey_questions_type ON /*_*/survey_questions (question_type); |
| | 15 | +CREATE INDEX /*i*/survey_questions_required ON /*_*/survey_questions (question_required); |
| | 16 | +CREATE INDEX /*i*/survey_questions_removed ON /*_*/survey_questions (question_removed); |
| | 17 | + |
| | 18 | +CREATE INDEX /*i*/survey_submissions_survey_id ON /*_*/survey_submissions (submission_survey_id); |
| | 19 | +CREATE INDEX /*i*/survey_submissions_user_name ON /*_*/survey_submissions (submission_user_name); |
| | 20 | +CREATE INDEX /*i*/survey_submissions_page_id ON /*_*/survey_submissions (submission_page_id); |
| | 21 | +CREATE INDEX /*i*/survey_submissions_time ON /*_*/survey_submissions (submission_time); |
| | 22 | + |
| Property changes on: trunk/extensions/Survey/sql/AddMissingIndexes.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 23 | + native |
| Index: trunk/extensions/Survey/Survey.hooks.php |
| — | — | @@ -60,6 +60,14 @@ |
| 61 | 61 | dirname( __FILE__ ) . '/sql/Survey.sql', |
| 62 | 62 | true |
| 63 | 63 | ) ); |
| | 64 | + |
| | 65 | + $updater->addExtensionUpdate( array( |
| | 66 | + 'addIndex', |
| | 67 | + 'surveys', |
| | 68 | + '', |
| | 69 | + dirname( __FILE__ ) . '/sql/AddMissingIndexes.sql', |
| | 70 | + true |
| | 71 | + ) ); |
| 64 | 72 | |
| 65 | 73 | return true; |
| 66 | 74 | } |
| Index: trunk/extensions/Survey/RELEASE-NOTES |
| — | — | @@ -10,6 +10,7 @@ |
| 11 | 11 | * Dropped compatibility with MediaWiki 1.17. |
| 12 | 12 | * Use of RequestContext methods to get rid of globals. |
| 13 | 13 | * Cleanup of database table index code. |
| | 14 | +* Added missing database table indexes. |
| 14 | 15 | |
| 15 | 16 | === Version 0.1.2 === |
| 16 | 17 | 2011-11-14 |