diff options
| author | tim b <timb@camcompu.home> | 2010-05-25 01:01:42 -0700 |
|---|---|---|
| committer | tim b <timb@camcompu.home> | 2010-05-25 01:01:42 -0700 |
| commit | 41025f011fe761b9c5d4e580bf5d7288b05b7e0f (patch) | |
| tree | 4f9f8bba42e33e79e878eabfcba78c556db72bc8 /db | |
| parent | d479c54031401f8e7388c423a33c6d007e1ead1f (diff) | |
| parent | 0ac15a39f48ee8b0b7453e1dc5aed382f8e518f2 (diff) | |
Merge branch 'master' of ssh://dump.fm/pichat/repo
Diffstat (limited to 'db')
| -rw-r--r-- | db/0-create.psql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/db/0-create.psql b/db/0-create.psql index aea6d63..112e774 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -37,6 +37,7 @@ CREATE INDEX messages_user_id_idx ON messages (user_id); CREATE INDEX messages_room_id_idx ON messages (room_id); CREATE INDEX messages_created_on_idx ON messages (created_on); CREATE INDEX messages_is_image_idx ON messages (is_image); +CREATE INDEX messages_user_created_on_idx ON messages (user_id, created_on desc); -- Queries to support: -- 1) What messages are tagged x? (ordered by time, popularity) |