From 4ee9af5e96dfdf045d13afa3510937f82b06df5c Mon Sep 17 00:00:00 2001
From: dumpfmprod <dumpfmprod@ubuntu.(none)>
Date: Thu, 30 Sep 2010 21:21:45 -0400
Subject: timb: image altars

---
 db/0-create.psql | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

(limited to 'db')

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
+);
-- 
cgit v1.2.3-70-g09d2