r97848 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r97847‎ | r97848 | r97849 >
Date:20:24, 22 September 2011
Author:reedy
Status:ok
Tags:
Comment:
LQT schema seems to be a sham
Modified paths:
  • /branches/REL1_18/extensions/LiquidThreads/schema-changes/ums_conversation.sql (modified) (history)
  • /trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
——@@ -3,7 +3,7 @@
44 ALTER TABLE /*_*/user_message_state ADD COLUMN ums_conversation int(8) unsigned NOT NULL DEFAULT 0;
55
66 CREATE INDEX /*i*/ums_user_conversation ON /*_*/user_message_state (ums_user,ums_conversation);
7 -DROP INDEX /*i*/ums_read ON /*_*/user_message_state;
 7+DROP INDEX /*i*/ums_user_read ON /*_*/user_message_state;
88
99 UPDATE /*_*/user_message_state, /*_*/thread
1010 SET /*_*/user_message_state.ums_conversation = if(/*_*/thread.thread_ancestor, /*_*/thread.thread_ancestor, /*_*/thread.thread_id)
Index: branches/REL1_18/extensions/LiquidThreads/schema-changes/ums_conversation.sql
——@@ -3,7 +3,7 @@
44 ALTER TABLE /*_*/user_message_state ADD COLUMN ums_conversation int(8) unsigned NOT NULL DEFAULT 0;
55
66 CREATE INDEX /*i*/ums_user_conversation ON /*_*/user_message_state (ums_user,ums_conversation);
7 -DROP INDEX /*i*/ums_read ON /*_*/user_message_state;
 7+DROP INDEX /*i*/ums_user_read ON /*_*/user_message_state;
88
99 UPDATE /*_*/user_message_state, /*_*/thread
1010 SET /*_*/user_message_state.ums_conversation = if(/*_*/thread.thread_ancestor, /*_*/thread.thread_ancestor, /*_*/thread.thread_id)

Status & tagging log