projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add and fix some indices, this should marginally (but not drastically) improve the...
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
5001c97
..
eb18964
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-517,7
+517,7
@@
sub tables_hashref {
],
'primary_key' => 'crednum',
'unique' => [],
],
'primary_key' => 'crednum',
'unique' => [],
- 'index' => [ ['custnum'] ],
+ 'index' => [ ['custnum']
, ['_date']
],
},
'cust_credit_bill' => {
},
'cust_credit_bill' => {
@@
-694,7
+694,6
@@
sub tables_hashref {
'cust_pay' => {
'columns' => [
'paynum', 'serial', '', '', '', '',
'cust_pay' => {
'columns' => [
'paynum', 'serial', '', '', '', '',
- #now cust_bill_pay #'invnum', 'int', '', '', '', '',
'custnum', 'int', '', '', '', '',
'paid', @money_type, '', '',
'_date', @date_type, '', '',
'custnum', 'int', '', '', '', '',
'paid', @money_type, '', '',
'_date', @date_type, '', '',
@@
-873,7
+872,6
@@
sub tables_hashref {
'cust_refund' => {
'columns' => [
'refundnum', 'serial', '', '', '', '',
'cust_refund' => {
'columns' => [
'refundnum', 'serial', '', '', '', '',
- #now cust_credit_refund #'crednum', 'int', '', '', '', '',
'custnum', 'int', '', '', '', '',
'_date', @date_type, '', '',
'refund', @money_type, '', '',
'custnum', 'int', '', '', '', '',
'_date', @date_type, '', '',
'refund', @money_type, '', '',
@@
-889,7
+887,7
@@
sub tables_hashref {
],
'primary_key' => 'refundnum',
'unique' => [],
],
'primary_key' => 'refundnum',
'unique' => [],
- 'index' => [ [
'custnum'
] ],
+ 'index' => [ [
'custnum'], ['_date'
] ],
},
'cust_credit_refund' => {
},
'cust_credit_refund' => {
@@
-902,7
+900,7
@@
sub tables_hashref {
],
'primary_key' => 'creditrefundnum',
'unique' => [],
],
'primary_key' => 'creditrefundnum',
'unique' => [],
- 'index' => [ [
'crednum', 'refundnum'
] ],
+ 'index' => [ [
'crednum'], ['refundnum'
] ],
},
},