diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-11-02 16:21:09 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-11-02 16:21:09 -0800 |
| commit | 878072579607ed3e01c9f430d8b259626483aaec (patch) | |
| tree | d07b7a8f92b89a267964904ee4cf54c70e4d3064 | |
| parent | 7a8867ad490e465c138859e9d8b3eb81b9b587c9 (diff) | |
add index on cust_payu_pending.invnum, RT#23357, githum #32
| -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 e5f9c05d1..ce58dbf67 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2292,7 +2292,9 @@ sub tables_hashref { ], 'primary_key' => 'paypendingnum', 'unique' => [ [ 'payunique' ] ], - 'index' => [ [ 'custnum' ], [ 'status' ], ['paynum'], ['void_paynum'], ['jobnum'], ], + 'index' => [ [ 'custnum' ], [ 'status' ], + ['paynum'], ['void_paynum'], ['jobnum'], ['invnum'], + ], 'foreign_keys' => [ { columns => [ 'custnum' ], table => 'cust_main', |