diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-11-02 16:08:51 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-11-02 16:08:51 -0800 |
| commit | 7a8867ad490e465c138859e9d8b3eb81b9b587c9 (patch) | |
| tree | bc82f62b910f483ab0ddf2a8b6681ad64afbd6b2 | |
| parent | e679fff4ed72a972cc650a394814e6869719f98b (diff) | |
add indices on cust_pay_pending.paynum .void_paynum and .jobnum, RT#23357, github pull request #31
| -rw-r--r-- | FS/FS/Schema.pm | 2 |
1 files changed, 1 insertions, 1 deletions
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', |