diff options
| author | sostler <sbostler@gmail.com> | 2010-05-24 20:36:14 -0400 |
|---|---|---|
| committer | sostler <sbostler@gmail.com> | 2010-05-24 20:36:14 -0400 |
| commit | 0de81097eb19f1948cc40b6cb182628298380700 (patch) | |
| tree | 53c3eaa18b2074c0cb32a311719bbc42320000ed /db | |
| parent | a8fe35fcf494f3e7a19418ee614347e198c58177 (diff) | |
Added scores to directory
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 3a8f1c4..d034bbe 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) |