From ffc48db948189fbce594d1a86be3fa197315aaed Mon Sep 17 00:00:00 2001 From: sostler Date: Mon, 17 May 2010 11:58:28 -0400 Subject: test page for feed import --- db/0-create.psql | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index 979363d..a90d23e 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -10,6 +10,7 @@ CREATE TABLE users ( avatar text NOT NULL DEFAULT '', contact text NOT NULL DEFAULT '', bio text NOT NULL DEFAULT '', + is_bot NOT NULL DEFAULT false, profile_bg text ); CREATE INDEX users_nick_lowercase_idx ON users (lower(nick)); @@ -74,3 +75,15 @@ INSERT INTO rooms (key, name, description, admin_only) 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, + added_on timestamp NOT NULL DEFAULT now(), + room_id integer REFERENCES rooms +); + +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); + + -- cgit v1.2.3-70-g09d2