http://www.mediawiki.org/wiki/Special:Code/MediaWiki/88462
Revision: 88462
Author: catrope
Date: 2011-05-20 16:39:29 +0000 (Fri, 20 May 2011)
Log Message:
-----------
ClickTracking: Remove useless index on session_id (is an initial prefix of the
UNIQUE KEY below), and add an index for querying property names and values
across users
Modified Paths:
--------------
trunk/extensions/ClickTracking/patches/ClickTrackingUserProperties.sql
Modified: trunk/extensions/ClickTracking/patches/ClickTrackingUserProperties.sql
===================================================================
--- trunk/extensions/ClickTracking/patches/ClickTrackingUserProperties.sql
2011-05-20 16:25:39 UTC (rev 88461)
+++ trunk/extensions/ClickTracking/patches/ClickTrackingUserProperties.sql
2011-05-20 16:39:29 UTC (rev 88462)
@@ -18,6 +18,6 @@
) /*$wgDBTableOptions*/;
-CREATE INDEX /*i*/click_tracking_user_properties_session_idx ON
/*_*/click_tracking_user_properties (session_id);
+CREATE INDEX /*i*/ct_version_name_value ON
/*_*/click_tracking_user_properties(property_version, property_name,
property_value);
CREATE UNIQUE INDEX ct_user_prop_id_name_value_version ON
/*_*/click_tracking_user_properties(session_id, property_name, property_value,
property_version);
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
