From: ivan <ivan>
Date: Sat, 14 Jun 2003 02:02:55 +0000 (+0000)
Subject: add index on cust_bill._date
X-Git-Tag: freeside_1_5_0pre3~42
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=9e6413e476a3516a08710efa5ff4d5949c1aa88c

add index on cust_bill._date
---

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index d2a98dd0c..734744efe 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -373,7 +373,7 @@ sub tables_hash_hack {
       ],
       'primary_key' => 'invnum',
       'unique' => [],
-      'index' => [ ['custnum'] ],
+      'index' => [ ['custnum'], ['_date'] ],
     },
 
     'cust_bill_event' => {