summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2009-04-26 23:43:34 +0000
committerivan <ivan>2009-04-26 23:43:34 +0000
commit03f48dbf4e5621efc428a1e7c3bbd64d0f533f29 (patch)
tree7e72900ecd9cc7a636c5d4f7b49636fb0054862a
parenta80720cc443697b1be73e0570fa40d592ccbe8bd (diff)
would help to have an index on priority if we're going to order based on it
-rw-r--r--FS/FS/Schema.pm4
1 files changed, 3 insertions, 1 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 0aed3ccbe..5d5331ab4 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -1510,7 +1510,9 @@ sub tables_hashref {
],
'primary_key' => 'jobnum',
'unique' => [],
- 'index' => [ [ 'job' ], [ 'svcnum' ], [ 'custnum' ], [ 'status' ] ],
+ 'index' => [ [ 'secure' ], [ 'priority' ],
+ [ 'job' ], [ 'svcnum' ], [ 'custnum' ], [ 'status' ],
+ ],
},
'queue_arg' => {