diff options
Diffstat (limited to 'db/0-create.psql-altered')
| -rwxr-xr-x | db/0-create.psql-altered | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/0-create.psql-altered b/db/0-create.psql-altered index 48dba34..b070506 100755 --- a/db/0-create.psql-altered +++ b/db/0-create.psql-altered @@ -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 ( |