diff options
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Schema.pm | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index aaca5ef3b..7fc208f18 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -334,7 +334,7 @@ sub tables_hashref { ], 'primary_key' => 'billpkgnum', 'unique' => [], - 'index' => [ ['invnum'] ], + 'index' => [ ['invnum'], [ 'pkgnum' ] ], }, 'cust_bill_pkg_detail' => { @@ -433,6 +433,8 @@ sub tables_hashref { #'index' => [ ['last'], ['company'] ], 'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ], [ 'daytime' ], [ 'night' ], [ 'fax' ], [ 'refnum' ], + [ 'ship_last' ], [ 'ship_company' ], + [ 'county' ], [ 'state' ], [ 'country' ] ], }, @@ -465,7 +467,7 @@ sub tables_hashref { 'primary_key' => 'taxnum', 'unique' => [], # 'unique' => [ ['taxnum'], ['state', 'county'] ], - 'index' => [], + 'index' => [ [ 'county' ], [ 'state' ], [ 'country' ] ], }, 'cust_pay' => { |