http://www.mediawiki.org/wiki/Special:Code/MediaWiki/72811
Revision: 72811
Author: nikerabbit
Date: 2010-09-11 14:51:57 +0000 (Sat, 11 Sep 2010)
Log Message:
-----------
Fix half-working schema change patch
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
2010-09-11 14:31:16 UTC (rev 72810)
+++ trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql
2010-09-11 14:51:57 UTC (rev 72811)
@@ -2,9 +2,9 @@
-- Adds and populates the ums_conversation field, along with relevant indices.
ALTER TABLE /*_*/user_message_state ADD COLUMN ums_conversation int(8)
unsigned NOT NULL DEFAULT 0;
-CREATE INDEX /*i*/ums_user_conversation ON /*$wgDBprefix*/user_message_state
(ums_user,ums_conversation);
+CREATE INDEX /*i*/ums_user_conversation ON /*_*/user_message_state
(ums_user,ums_conversation);
DROP INDEX /*i*/ums_user_conversation 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)
-WHERE ums_conversation = 0 AND thread.thread_id =
user_message_state.ums_thread;
+SET /*_*/user_message_state.ums_conversation = if(/*_*/thread.thread_ancestor,
/*_*/thread.thread_ancestor, /*_*/thread.thread_id)
+WHERE ums_conversation = 0 AND /*_*/thread.thread_id =
/*_*/user_message_state.ums_thread;
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
