1 files changed, 1 insertions, 0 deletions
diff --git a/db/0-create.psql b/db/0-create.psql
index 7c6b4b0..4a134f5 100755
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -44,6 +44,7 @@ CREATE INDEX room_id_idx ON messages (room_id);
 CREATE INDEX created_on_idx ON messages (created_on);
 
 CREATE INDEX src_user_id_idx ON favorites (src_user_id);
+CREATE INDEX favorites_created_on_idx on favorites (created_on);
 
 INSERT INTO rooms (key, name, description, admin_only) 
        VALUES ('RoomA', 'Room A', 'Hangout', false);