From c69dd0d922bba433b16e3408f71f1cac0e16a069 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 29 Jul 2004 21:49:10 +0000
Subject: [PATCH] add index on cust_main.refnum, speeds up advertising source
 list

---
 FS/bin/freeside-setup | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index 119b09d5d..386c4c7cd 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -498,7 +498,7 @@ sub tables_hash_hack {
       'unique' => [],
       #'index' => [ ['last'], ['company'] ],
       'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ],
-                   [ 'daytime' ], [ 'night' ], [ 'fax' ],
+                   [ 'daytime' ], [ 'night' ], [ 'fax' ], [ 'refnum' ],
                  ],
     },
 
-- 
2.11.0