--- a/app/index.yaml	Fri Mar 13 13:49:07 2009 +0000
+++ b/app/index.yaml	Fri Mar 13 14:11:08 2009 +0000
@@ -1,5 +1,6 @@
 indexes:
 
+# used to list proposal in descending order of their score
 - kind: StudentProposal
   properties:
   - name: org
@@ -7,12 +8,27 @@
   - name: score
     direction: desc
 
+# used to list reviews in ascending order of date
 - kind: Review
   properties:
   - name: is_public
   - name: scope
   - name: created
 
+# used to determine which orgs have more then 0 slots assigned.
+- kind: Organization
+  properties:
+  - name: scope
+  - name: status
+  - name: slots
+
+# used to determine which proposals have a mentor assigned
+- kind: StudentProposal
+  properties:
+  - name: org
+  - name: status
+  - name: mentor
+
 # AUTOGENERATED
 
 # This index.yaml is automatically updated whenever the dev_appserver