Index: /branches/release-30/lib/MT/TheSchwartz/Job.pm
===================================================================
--- /branches/release-30/lib/MT/TheSchwartz/Job.pm (revision 1401)
+++ /branches/release-30/lib/MT/TheSchwartz/Job.pm (revision 1417)
@@ -25,9 +25,13 @@
     primary_key => 'jobid',
     indexes => {
-        funcid => 1,
-        coalesce => 1,
-        uniqkey => 1,
-        run_after => 1,
-        priority => 1,
+        funccoal => {
+            columns => [ 'funcid', 'coalesce' ],
+        },
+        funcrun => {
+            columns => [ 'funcid', 'run_after' ],
+        },
+        funcpri => {
+            columns => [ 'funcid', 'priority' ],
+        },
         uniqfunc => {
             columns => [ 'funcid', 'uniqkey' ],
@@ -35,7 +39,4 @@
         },
     },
-    # not captured (but indexed separately)
-    # INDEX (funcid, run_after),
-    # INDEX (funcid, coalesce)
 });
 
Index: /branches/release-30/build/mt-dists/default.mk
===================================================================
--- /branches/release-30/build/mt-dists/default.mk (revision 1398)
+++ /branches/release-30/build/mt-dists/default.mk (revision 1417)
@@ -2,5 +2,5 @@
 
 PRODUCT_VERSION = 4.2
-SCHEMA_VERSION = 4.0038
+SCHEMA_VERSION = 4.0039
 API_VERSION = 4.2