From a98104eb39c4f74dd5f06ac89bc908e1476a85c7 Mon Sep 17 00:00:00 2001
From: Christopher Allan Webber <cwebber@dustycloud.org>
Date: Thu, 30 Jun 2011 12:51:32 -0500
Subject: [PATCH] Comment indexes

---
 mediagoblin/db/indexes.py | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/mediagoblin/db/indexes.py b/mediagoblin/db/indexes.py
index bbcceb6d..d379a52b 100644
--- a/mediagoblin/db/indexes.py
+++ b/mediagoblin/db/indexes.py
@@ -111,6 +111,16 @@ USER_INDEXES = {
 ACTIVE_INDEXES['users'] = USER_INDEXES
 
 
+# MediaComment indexes
+
+MEDIA_COMMENT_INDEXES = {
+   'mediaentry_created': {
+        'index': [('media_entry', ASCENDING),
+                  ('created', DESCENDING)]}}
+
+ACTIVE_INDEXES['media_comments'] = MEDIA_COMMENT_INDEXES
+
+
 ####################
 # Deprecated indexes
 ####################
-- 
2.25.1