X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=e5f9c05d1e0be4f9151f07ab3646d3dd7e27e9b9;hp=53e78dee8f7735c155fdd3f66074748042f55bc9;hb=7a8867ad490e465c138859e9d8b3eb81b9b587c9;hpb=e679fff4ed72a972cc650a394814e6869719f98b

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 53e78dee8..e5f9c05d1 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -2292,7 +2292,7 @@ sub tables_hashref {
       ],
       'primary_key'  => 'paypendingnum',
       'unique'       => [ [ 'payunique' ] ],
-      'index'        => [ [ 'custnum' ], [ 'status' ], ],
+      'index'        => [ [ 'custnum' ], [ 'status' ], ['paynum'], ['void_paynum'], ['jobnum'], ],
       'foreign_keys' => [
                           { columns    => [ 'custnum' ],
                             table      => 'cust_main',