From dc58e4cddba3ff5ea1daadfbee7a7a3621715024 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 26 Apr 2009 23:43:43 +0000 Subject: [PATCH] would help to have an index on priority if we're going to order based on it --- FS/FS/Schema.pm | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) 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' => { -- 2.20.1