From: ivan <ivan>
Date: Sun, 26 Apr 2009 23:43:34 +0000 (+0000)
Subject: would help to have an index on priority if we're going to order based on it
X-Git-Tag: root_of_svc_elec_features~1236
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=03f48dbf4e5621efc428a1e7c3bbd64d0f533f29

would help to have an index on priority if we're going to order based on it
---

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' => {