From 8011da4e04a44d6245f7f5e1750c0c627b41e182 Mon Sep 17 00:00:00 2001 From: sostler Date: Sun, 11 Apr 2010 02:55:16 -0400 Subject: Removed unused favorites table in sql file --- db/0-create.psql | 13 ------------- 1 file changed, 13 deletions(-) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index 3ab384c..e0c5443 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -36,19 +36,6 @@ CREATE INDEX messages_room_id_idx ON messages (room_id); CREATE INDEX messages_created_on_idx ON messages (created_on); CREATE INDEX messages_is_image_idx ON messages (is_image); --- Queries to support: --- 1) What are my favorite images? (By room, time, or author) --- 2) Who favorited me? (By user, image, or time) --- 3) What are the most favorited images? (By room, time, or author) -CREATE TABLE favorites ( - favorite_id SERIAL PRIMARY KEY, - src_user_id integer NOT NULL REFERENCES users, - message_id integer NOT NULL REFERENCES messages, - created_on timestamp NOT NULL DEFAULT now() -); -CREATE INDEX src_user_id_idx ON favorites (src_user_id); -CREATE INDEX favorites_created_on_idx on favorites (created_on); - -- Queries to support: -- 1) What messages are tagged x? (ordered by time, popularity) -- 2) What did I tag x? -- cgit v1.2.3-70-g09d2