| Index: trunk/extensions/LiquidThreads/schema-changes/ums_conversation.sql |
| — | — | @@ -0,0 +1,10 @@ |
| | 2 | +-- ums_conversation |
| | 3 | +-- Adds and populates the ums_conversation field, along with relevant indices. |
| | 4 | +ALTER TABLE /*_*/user_message_state ADD COLUMN ums_conversation int(8) unsigned NOT NULL DEFAULT 0; |
| | 5 | + |
| | 6 | +CREATE INDEX /*i*/ums_user_conversation ON /*$wgDBprefix*/user_message_state (ums_user,ums_conversation); |
| | 7 | +DROP INDEX /*i*/ums_user_conversation ON /*_*/user_message_state; |
| | 8 | + |
| | 9 | +UPDATE /*_*/user_message_state, /*_*/thread |
| | 10 | +SET user_message_state.ums_conversation = if(thread.thread_ancestor, thread.thread_ancestor, thread.thread_id) |
| | 11 | +WHERE ums_conversation = 0 AND thread.thread_id = user_message_state.ums_thread; |