http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97848
Revision: 97848
Author: reedy
Date: 2011-09-22 20:24:12 +0000 (Thu, 22 Sep 2011)
Log Message:
-----------
LQT schema seems to be a sham
Modified Paths:
--------------
branches/REL1_18/extensions/LiquidThreads/schema-changes/ums_conversation.sql
trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
Modified:
branches/REL1_18/extensions/LiquidThreads/schema-changes/ums_conversation.sql
===================================================================
---
branches/REL1_18/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2011-09-22 20:08:03 UTC (rev 97847)
+++
branches/REL1_18/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2011-09-22 20:24:12 UTC (rev 97848)
@@ -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_read ON /*_*/user_message_state;
+DROP INDEX /*i*/ums_user_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)
Modified: trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
===================================================================
--- trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2011-09-22 20:08:03 UTC (rev 97847)
+++ trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2011-09-22 20:24:12 UTC (rev 97848)
@@ -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_read ON /*_*/user_message_state;
+DROP INDEX /*i*/ums_user_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
