diff options
Diffstat (limited to 'db/0-create.psql')
| -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? |