timb: image altars

1 files changed, 7 insertions, 2 deletions

diff --git a/db/0-create.psql b/db/0-create.psql
index 1162f86..d2d4bfc 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -57,7 +57,12 @@ CREATE INDEX messages_user_created_on_image_only_idx ON messages (user_id, creat
 -- historical image dumps 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 (
+  message_id integer NOT NULL,
+  user_id integer NOT NULL,
+  PRIMARY KEY(message_id)
+);
+  
 CREATE TABLE image_urls (
   url text,
   last_posted timestamp NOT NULL DEFAULT now(),
@@ -150,4 +155,4 @@ CREATE TABLE avatars (
 CREATE TABLE images (
   image_id SERIAL PRIMARY KEY,
   
-);
\ No newline at end of file
+);