From e3f32fc0ba82dd15a8f89f7c4965c68b39123e20 Mon Sep 17 00:00:00 2001 From: sostler Date: Wed, 19 May 2010 14:58:08 -0400 Subject: Basic rooms functionality --- db/0-create.psql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index a90d23e..3cb7236 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -76,14 +76,15 @@ INSERT INTO rooms (key, name, description, admin_only) VALUES ('VIP', 'The VIP Room', 'Command Post', true); CREATE TABLE feed_images ( - external_url text NOT NULL, - local_url text NOT NULL, feed_url text NOT NULL, + image_url text NOT NULL, + room_id integer REFERENCES rooms, + message_id integer REFERENCES messages, added_on timestamp NOT NULL DEFAULT now(), - room_id integer REFERENCES rooms + UNIQUE (room_id, image_url) ); -CREATE INDEX feed_images_external_url_idx ON feed_images (external_url); -CREATE INDEX feed_images_image_posted_idx ON feed_images (external_url, room_id); +CREATE INDEX feed_images_url_idx ON feed_images (image_url); +CREATE INDEX feed_images_url_room_idx ON feed_images (image_url, room_id); -- cgit v1.2.3-70-g09d2