From: Ivan Kohler <ivan@freeside.biz>
Date: Mon, 3 Nov 2014 00:08:51 +0000 (-0800)
Subject: add indices on cust_pay_pending.paynum .void_paynum and .jobnum, RT#23357, github... 
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=7a8867ad490e465c138859e9d8b3eb81b9b587c9

add indices on cust_pay_pending.paynum .void_paynum and .jobnum, RT#23357, github pull request #31
---

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',