From: ivan <ivan>
Date: Thu, 29 Jul 2004 21:49:10 +0000 (+0000)
Subject: add index on cust_main.refnum, speeds up advertising source list
X-Git-Tag: BEFORE_FINAL_MASONIZE~979
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=c69dd0d922bba433b16e3408f71f1cac0e16a069

add index on cust_main.refnum, speeds up advertising source list
---

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' ],
                  ],
     },