diff options
| author | ivan <ivan> | 2009-04-26 23:43:43 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-04-26 23:43:43 +0000 |
| commit | dc58e4cddba3ff5ea1daadfbee7a7a3621715024 (patch) | |
| tree | 7528383edddc14b421e4968ea5b3e87b39c406c0 | |
| parent | 519c86750194fed79146872cba8e848d29e07821 (diff) | |
would help to have an index on priority if we're going to order based on it
| -rw-r--r-- | FS/FS/Schema.pm | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 6aae91652..9fc857ba8 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1196,7 +1196,9 @@ sub tables_hashref { ], 'primary_key' => 'jobnum', 'unique' => [], - 'index' => [ [ 'svcnum' ], [ 'status' ] ], + 'index' => [ [ 'priority', ], + [ 'job' ], [ 'svcnum' ], [ 'custnum' ], [ 'status' ], + ], }, 'queue_arg' => { |