diff options
| author | sostler <sbostler@gmail.com> | 2010-04-11 02:55:16 -0400 |
|---|---|---|
| committer | sostler <sbostler@gmail.com> | 2010-04-11 02:55:16 -0400 |
| commit | 8011da4e04a44d6245f7f5e1750c0c627b41e182 (patch) | |
| tree | 7286c3d0e70973cbdece63ff9dc9a7eaca38ed31 | |
| parent | 3b502423fc5bb2ed22051c465e8384f3e44519cc (diff) | |
Removed unused favorites table in sql file
| -rw-r--r-- | db/0-create.psql | 13 |
1 files changed, 0 insertions, 13 deletions
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 @@ -37,19 +37,6 @@ 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? -- 3) Which of my things are tagged x? |