http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97811
Revision: 97811
Author: reedy
Date: 2011-09-22 12:33:25 +0000 (Thu, 22 Sep 2011)
Log Message:
-----------
Fix ums_conversation.sql patch per changes on r72707
Drop ums_read index, add ums_user_conversation
<pre>
Index: trunk/extensions/LiquidThreads/lqt.sql
===================================================================
--- trunk/extensions/LiquidThreads/lqt.sql (revision 72706)
+++ trunk/extensions/LiquidThreads/lqt.sql (revision 72707)
@@ -57,11 +57,12 @@
CREATE TABLE /*$wgDBprefix*/user_message_state (
ums_user int unsigned NOT NULL,
ums_thread int(8) unsigned NOT NULL,
+ ums_conversation int(8) unsigned NOT NULL DEFAULT 0,
ums_read_timestamp varbinary(14),
PRIMARY KEY (ums_user, ums_thread)
) /*$wgDBTableOptions*/;
-CREATE INDEX ums_user_read ON /*$wgDBprefix*/user_message_state
(ums_user,ums_read_timestamp);
+CREATE INDEX ums_user_conversation ON /*$wgDBprefix*/user_message_state
(ums_user,ums_conversation);
</pre>
Modified Paths:
--------------
trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
Modified: trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
===================================================================
--- trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2011-09-22 12:14:21 UTC (rev 97810)
+++ trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2011-09-22 12:33:25 UTC (rev 97811)
@@ -3,7 +3,7 @@
ALTER TABLE /*_*/user_message_state ADD COLUMN ums_conversation int(8)
unsigned NOT NULL DEFAULT 0;
CREATE INDEX /*i*/ums_user_conversation ON /*_*/user_message_state
(ums_user,ums_conversation);
-DROP INDEX /*i*/ums_user_conversation ON /*_*/user_message_state;
+DROP INDEX /*i*/ums_read ON /*_*/user_message_state;
UPDATE /*_*/user_message_state, /*_*/thread
SET /*_*/user_message_state.ums_conversation = if(/*_*/thread.thread_ancestor,
/*_*/thread.thread_ancestor, /*_*/thread.thread_id)
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
