summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorsostler <sbostler@gmail.com>2010-03-16 08:21:48 -0400
committersostler <sbostler@gmail.com>2010-03-16 08:21:48 -0400
commit6ca298ac919071d2dd7b31f6a7f8f6ec528803c9 (patch)
tree30a9b1cb6d732d4b858adc767ec627585614f3a0 /db
parent0a9c5c4df26f3d8a9a322e6696667fab4be6676c (diff)
parentd5c626666add9443dd72497b56ae7472f3d810db (diff)
Merged
Diffstat (limited to 'db')
-rwxr-xr-xdb/0-create.psql1
1 files changed, 1 insertions, 0 deletions
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);