projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(from parent 1:
7a8867a
)
add index on cust_payu_pending.invnum, RT#23357, githum #32
author
Ivan Kohler
<ivan@freeside.biz>
Mon, 3 Nov 2014 00:21:09 +0000
(16:21 -0800)
committer
Ivan Kohler
<ivan@freeside.biz>
Mon, 3 Nov 2014 00:21:09 +0000
(16:21 -0800)
FS/FS/Schema.pm
patch
|
blob
|
history
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
e5f9c05
..
ce58dbf
100644
(file)
--- 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',