diff options
| -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'] ], }, |