diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/0-create.psql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/0-create.psql b/db/0-create.psql index 3a8f1c4..112e774 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -10,7 +10,7 @@ CREATE TABLE users ( avatar text NOT NULL DEFAULT '', contact text NOT NULL DEFAULT '', bio text NOT NULL DEFAULT '', - is_bot NOT NULL DEFAULT false, + is_bot boolean NOT NULL DEFAULT false, profile_bg text ); CREATE INDEX users_nick_lowercase_idx ON users (lower(nick)); @@ -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) |