diff options
| author | ivan <ivan> | 2008-01-20 23:24:54 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2008-01-20 23:24:54 +0000 |
| commit | c453f14333df381156f154f458ba77bae1a1f4cf (patch) | |
| tree | 5a2ac2bc25f8f8cc639351d1c06fbf67ba9acea8 /FS | |
| parent | edb7652d50dcbabc4ec066a78ae8f65a4a7b5d24 (diff) | |
add and fix some indices, this should marginally (but not drastically) improve the time to pull up A/R report totals
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Schema.pm | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 5001c97bf..eb18964d5 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -517,7 +517,7 @@ sub tables_hashref { ], 'primary_key' => 'crednum', 'unique' => [], - 'index' => [ ['custnum'] ], + 'index' => [ ['custnum'], ['_date'] ], }, 'cust_credit_bill' => { @@ -694,7 +694,6 @@ sub tables_hashref { 'cust_pay' => { 'columns' => [ 'paynum', 'serial', '', '', '', '', - #now cust_bill_pay #'invnum', 'int', '', '', '', '', 'custnum', 'int', '', '', '', '', 'paid', @money_type, '', '', '_date', @date_type, '', '', @@ -873,7 +872,6 @@ sub tables_hashref { 'cust_refund' => { 'columns' => [ 'refundnum', 'serial', '', '', '', '', - #now cust_credit_refund #'crednum', 'int', '', '', '', '', 'custnum', 'int', '', '', '', '', '_date', @date_type, '', '', 'refund', @money_type, '', '', @@ -889,7 +887,7 @@ sub tables_hashref { ], 'primary_key' => 'refundnum', 'unique' => [], - 'index' => [ [ 'custnum' ] ], + 'index' => [ ['custnum'], ['_date'] ], }, 'cust_credit_refund' => { @@ -902,7 +900,7 @@ sub tables_hashref { ], 'primary_key' => 'creditrefundnum', 'unique' => [], - 'index' => [ [ 'crednum', 'refundnum' ] ], + 'index' => [ ['crednum'], ['refundnum'] ], }, |