diff options
Diffstat (limited to 'db')
| -rwxr-xr-x | db/0-create.psql | 4 | ||||
| -rwxr-xr-x | db/0-create.psql-altered | 4 |
2 files changed, 4 insertions, 4 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 ( 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 ( |