From 878072579607ed3e01c9f430d8b259626483aaec Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Sun, 2 Nov 2014 16:21:09 -0800 Subject: [PATCH] add index on cust_payu_pending.invnum, RT#23357, githum #32 --- 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 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', -- 2.11.0