diff options
author | Brion Vibber <brion@pobox.com> | 2010-12-17 16:08:37 -0800 |
---|---|---|
committer | Brion Vibber <brion@pobox.com> | 2010-12-17 16:08:37 -0800 |
commit | fb65d5901d586a13886b81d84de8959b67b6aa9e (patch) | |
tree | 00cb879e21f055479f997ead9bd2c99404655af7 /db/statusnet.sql | |
parent | 71151b3bc0e1b1d4d560bf296eb0a572485389e8 (diff) |
Update sorting for conversation views: adds notice_conversation_created_id_idx index on notice, replacing more limited notice_conversation_idx
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r-- | db/statusnet.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql index 9624edd6f..8b38f9ffe 100644 --- a/db/statusnet.sql +++ b/db/statusnet.sql @@ -140,11 +140,11 @@ create table notice ( -- For api/statuses/repeats... index notice_repeat_of_created_id_idx (repeat_of, created, id), - -- Are these enough? - index notice_conversation_idx (conversation), - index notice_created_idx (created), + -- For conversation views + index notice_conversation_created_id_idx (conversation, created, id), + + -- Are these needed/used? index notice_replyto_idx (reply_to), - index notice_repeatof_idx (repeat_of), FULLTEXT(content) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci; |