From e669002f6922433385e34f0b4ad4469ab63811e1 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sat, 14 Jun 2003 02:02:25 +0000
Subject: [PATCH] add index on cust_bill._date

---
 FS/bin/freeside-setup | 2 +-
 bin/fs-setup          | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index c91e816d1..797c1b147 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -381,7 +381,7 @@ sub tables_hash_hack {
       ],
       'primary_key' => 'invnum',
       'unique' => [],
-      'index' => [ ['custnum'] ],
+      'index' => [ ['custnum'], ['_date'] ],
     },
 
     'cust_bill_event' => {
diff --git a/bin/fs-setup b/bin/fs-setup
index c60181b92..973523cf2 100755
--- a/bin/fs-setup
+++ b/bin/fs-setup
@@ -1,6 +1,6 @@
 #!/usr/bin/perl -Tw
 #
-# $Id: fs-setup,v 1.96.4.6 2002-12-24 22:41:21 ivan Exp $
+# $Id: fs-setup,v 1.96.4.7 2003-06-14 02:02:25 ivan Exp $
 
 #to delay loading dbdef until we're ready
 BEGIN { $FS::Record::setup_hack = 1; }
@@ -377,7 +377,7 @@ sub tables_hash_hack {
       ],
       'primary_key' => 'invnum',
       'unique' => [],
-      'index' => [ ['custnum'] ],
+      'index' => [ ['custnum'], ['_date'] ],
     },
 
     'cust_bill_event' => {
-- 
2.20.1