From 7a8867ad490e465c138859e9d8b3eb81b9b587c9 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Sun, 2 Nov 2014 16:08:51 -0800 Subject: [PATCH] add indices on cust_pay_pending.paynum .void_paynum and .jobnum, RT#23357, github pull request #31 --- FS/FS/Schema.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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', -- 2.11.0