| Index: trunk/extensions/MoodBar/sql/mbf_timestamp.sql |
| — | — | @@ -0,0 +1,5 @@ |
| | 2 | +-- Add some indexes to the moodbar_feedback table |
| | 3 | + |
| | 4 | +CREATE INDEX /*i*/mbf_userid_ip_timestamp ON /*_*/moodbar_feedback (mbf_user_id, mbf_user_ip, mbf_timestamp); |
| | 5 | +CREATE INDEX /*i*/mbf_type_userid_ip_timestamp ON /*_*/moodbar_feedback (mbf_type, mbf_user_id, mbf_user_ip, mbf_timestamp); |
| | 6 | +CREATE INDEX /*i*/mbf_timestamp ON /*_*/moodbar_feedback (mbf_timestamp); |
| Property changes on: trunk/extensions/MoodBar/sql/mbf_timestamp.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 7 | + native |
| Index: trunk/extensions/MoodBar/MoodBar.hooks.php |
| — | — | @@ -74,6 +74,10 @@ |
| 75 | 75 | $updater->addExtensionUpdate( array( 'addField', 'moodbar_feedback', |
| 76 | 76 | 'mbf_user_editcount', dirname(__FILE__).'/sql/mbf_user_editcount.sql', true ) |
| 77 | 77 | ); |
| | 78 | + |
| | 79 | + $updater->addExtensionUpdate( array( 'addIndex', 'moodbar_feedback', |
| | 80 | + 'mbf_timestamp', dirname( __FILE__ ) . '/sql/mbf_timestamp.sql', true ) |
| | 81 | + ); |
| 78 | 82 | |
| 79 | 83 | return true; |
| 80 | 84 | } |