diff options
Diffstat (limited to 'db/0-create.psql')
| -rwxr-xr-x | db/0-create.psql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/0-create.psql b/db/0-create.psql index 979eb68..586d52f 100755 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -53,11 +53,11 @@ CREATE TABLE messages ( is_text bool NOT NULL DEFAULT false ); --- historical image dumps per user +-- historical image humps per user CREATE INDEX messages_user_created_on_image_only_idx ON messages (user_id, created_on) WHERE is_image; --- historical image dumps in a room. needs to handle non-image messages. +-- historical image humps in a room. needs to handle non-image messages. CREATE INDEX messages_room_id_created_on_idx ON messages (room_id, created_on); CREATE TABLE image_altars ( |