http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97921
Revision: 97921
Author: catrope
Date: 2011-09-23 14:52:51 +0000 (Fri, 23 Sep 2011)
Log Message:
-----------
Add updater for r97920
Modified Paths:
--------------
trunk/extensions/MoodBar/MoodBar.hooks.php
Added Paths:
-----------
trunk/extensions/MoodBar/sql/mbf_timestamp.sql
Modified: trunk/extensions/MoodBar/MoodBar.hooks.php
===================================================================
--- trunk/extensions/MoodBar/MoodBar.hooks.php 2011-09-23 14:49:21 UTC (rev
97920)
+++ trunk/extensions/MoodBar/MoodBar.hooks.php 2011-09-23 14:52:51 UTC (rev
97921)
@@ -74,6 +74,10 @@
$updater->addExtensionUpdate( array( 'addField',
'moodbar_feedback',
'mbf_user_editcount',
dirname(__FILE__).'/sql/mbf_user_editcount.sql', true )
);
+
+ $updater->addExtensionUpdate( array( 'addIndex',
'moodbar_feedback',
+ 'mbf_timestamp', dirname( __FILE__ ) .
'/sql/mbf_timestamp.sql', true )
+ );
return true;
}
Added: trunk/extensions/MoodBar/sql/mbf_timestamp.sql
===================================================================
--- trunk/extensions/MoodBar/sql/mbf_timestamp.sql
(rev 0)
+++ trunk/extensions/MoodBar/sql/mbf_timestamp.sql 2011-09-23 14:52:51 UTC
(rev 97921)
@@ -0,0 +1,5 @@
+-- Add some indexes to the moodbar_feedback table
+
+CREATE INDEX /*i*/mbf_userid_ip_timestamp ON /*_*/moodbar_feedback
(mbf_user_id, mbf_user_ip, mbf_timestamp);
+CREATE INDEX /*i*/mbf_type_userid_ip_timestamp ON /*_*/moodbar_feedback
(mbf_type, mbf_user_id, mbf_user_ip, mbf_timestamp);
+CREATE INDEX /*i*/mbf_timestamp ON /*_*/moodbar_feedback (mbf_timestamp);
Property changes on: trunk/extensions/MoodBar/sql/mbf_timestamp.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
