From 58c036fab9ec7f116c5c3f60f20116b433b1930a Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sun, 25 Dec 2005 03:00:33 +0000
Subject: update indices for better tax report performance

---
 FS/FS/Schema.pm | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'FS')

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' => {
-- 
cgit v1.2.1