| Index: branches/wmf/1.18wmf1/maintenance/ums_conversation.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | ALTER TABLE /*_*/user_message_state ADD COLUMN ums_conversation int(8) unsigned NOT NULL DEFAULT 0; |
| 5 | 5 | |
| 6 | 6 | 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 ON /*_*/user_message_state; |
| 8 | 8 | |
| 9 | 9 | UPDATE /*_*/user_message_state, /*_*/thread |
| 10 | 10 | SET /*_*/user_message_state.ums_conversation = if(/*_*/thread.thread_ancestor, /*_*/thread.thread_ancestor, /*_*/thread.thread_id) |