summaryrefslogtreecommitdiff
path: root/db/0-create.psql
diff options
context:
space:
mode:
authoryo momma <shutup@oops.wtf>2026-02-04 19:50:53 +0000
committeryo momma <shutup@oops.wtf>2026-02-04 19:50:53 +0000
commitb3f1adfbe7705819ecbae9114f470307146627c2 (patch)
tree74f8f5174c493a6043a10c9c77b00ca9de645be8 /db/0-create.psql
parente08bd3d51eed082c86b282e44c253040cc2bdfd8 (diff)
Rebrand: remove dump refs from scripts/db/routes
Diffstat (limited to 'db/0-create.psql')
-rwxr-xr-xdb/0-create.psql4
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 (