| Index: trunk/extensions/MoodBar/MoodBar.hooks.php |
| — | — | @@ -144,6 +144,7 @@ |
| 145 | 145 | ) ); |
| 146 | 146 | $updater->addExtensionIndex( 'moodbar_feedback_response', 'mbfr_mbf_mbfr_id', "$dir/mbfr_mbf_mbfr_id_index.sql" ); |
| 147 | 147 | $updater->addExtensionField( 'moodbar_feedback_response', 'mbfr_enotif_sent', "$dir/mbfr_enotif_sent.sql" ); |
| | 148 | + $updater->addExtensionIndex( 'moodbar_feedback_response', 'mbfr_user_id', "$dir/mbfr_user_id_index.sql" ); |
| 148 | 149 | |
| 149 | 150 | return true; |
| 150 | 151 | } |
| Index: trunk/extensions/MoodBar/sql/moodbar_feedback_response.sql |
| — | — | @@ -25,3 +25,4 @@ |
| 26 | 26 | |
| 27 | 27 | CREATE INDEX /*i*/mbfr_mbf_id ON /*_*/moodbar_feedback_response (mbfr_mbf_id); |
| 28 | 28 | CREATE INDEX /*i*/mbfr_mbf_mbfr_id ON /*_*/moodbar_feedback_response (mbfr_mbf_id, mbfr_id); |
| | 29 | +CREATE INDEX /*i*/mbfr_user_id ON /*_*/moodbar_feedback_response (mbfr_user_id); |
| Index: trunk/extensions/MoodBar/sql/mbfr_user_id_index.sql |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +CREATE INDEX /*i*/mbfr_user_id ON /*_*/moodbar_feedback_response (mbfr_user_id); |