From 7a3bf6cf4266b4c431d42ac57a070dffda6a4084 Mon Sep 17 00:00:00 2001 From: Scott Ostler Date: Mon, 15 Mar 2010 22:44:33 -0400 Subject: Add image index --- db/0-create.psql | 1 + 1 file changed, 1 insertion(+) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index 0360d22..00ea012 100755 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -44,6 +44,7 @@ CREATE TABLE favorites ( CREATE INDEX user_id_idx ON messages (user_id); CREATE INDEX room_id_idx ON messages (room_id); CREATE INDEX created_on_idx ON messages (created_on); +CREATE INDEX is_image_idx ON messages (is_image); CREATE INDEX src_user_id_idx ON favorites (src_user_id); CREATE INDEX favorites_created_on_idx on favorites (created_on); -- cgit v1.2.3-70-g09d2