projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add indices on cust_pay_pending.paynum .void_paynum and .jobnum, RT#23357, github...
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
53e78de
..
e5f9c05
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-2292,7
+2292,7
@@
sub tables_hashref {
],
'primary_key' => 'paypendingnum',
'unique' => [ [ 'payunique' ] ],
],
'primary_key' => 'paypendingnum',
'unique' => [ [ 'payunique' ] ],
- 'index' => [ [ 'custnum' ], [ 'status' ], ],
+ 'index' => [ [ 'custnum' ], [ 'status' ],
['paynum'], ['void_paynum'], ['jobnum'],
],
'foreign_keys' => [
{ columns => [ 'custnum' ],
table => 'cust_main',
'foreign_keys' => [
{ columns => [ 'custnum' ],
table => 'cust_main',