| Index: trunk/extensions/ArticleFeedback/sql/AddArticleFeedbackPageIndex.sql |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +CREATE INDEX /*i*/aa_page_id ON /*_*/article_feedback (aa_page_id, aa_timestamp); |
| Index: trunk/extensions/ArticleFeedback/sql/ArticleFeedback.sql |
| — | — | @@ -39,6 +39,7 @@ |
| 40 | 40 | CREATE INDEX /*i*/aa_revision ON /*_*/article_feedback (aa_revision); |
| 41 | 41 | -- Create an index on the article_feedback.aa_timestamp field |
| 42 | 42 | CREATE INDEX /*i*/article_feedback_timestamp ON /*_*/article_feedback (aa_timestamp); |
| | 43 | +CREATE INDEX /*i*/aa_page_id ON /*_*/article_feedback (aa_page_id, aa_timestamp); |
| 43 | 44 | |
| 44 | 45 | -- Aggregate rating table for a page |
| 45 | 46 | CREATE TABLE IF NOT EXISTS /*_*/article_feedback_pages ( |
| Index: trunk/extensions/ArticleFeedback/ArticleFeedback.hooks.php |
| — | — | @@ -160,6 +160,16 @@ |
| 161 | 161 | ) ); |
| 162 | 162 | } |
| 163 | 163 | |
| | 164 | + if ( !$db->indexExists( 'article_feedback', 'aa_page_id', __METHOD__ ) ) { |
| | 165 | + $updater->addExtensionUpdate( array( |
| | 166 | + 'addIndex', |
| | 167 | + 'article_feedback', |
| | 168 | + 'aa_page_id', |
| | 169 | + $dir . '/sql/AddArticleFeedbackPageIndex.sql', |
| | 170 | + true |
| | 171 | + ) ); |
| | 172 | + } |
| | 173 | + |
| 164 | 174 | $updater->addExtensionUpdate( array( |
| 165 | 175 | 'addField', |
| 166 | 176 | 'article_feedback', |
| Property changes on: trunk/extensions/ArticleFeedback/api/ApiArticleFeedback.php |
| ___________________________________________________________________ |
| Modified: svn:mergeinfo |
| 167 | 177 | Merged /branches/REL1_18/extensions/ArticleFeedback/api/ApiArticleFeedback.php:r97350 |
| Property changes on: trunk/extensions/ArticleFeedback/api/ApiQueryArticleFeedback.php |
| ___________________________________________________________________ |
| Modified: svn:mergeinfo |
| 168 | 178 | Merged /branches/REL1_18/extensions/ArticleFeedback/api/ApiQueryArticleFeedback.php:r97350 |
| Property changes on: trunk/extensions/ArticleFeedback |
| ___________________________________________________________________ |
| Added: svn:mergeinfo |
| 169 | 179 | Merged /branches/REL1_18/extensions/ArticleFeedback:r97350 |