summaryrefslogtreecommitdiff
path: root/FS/bin/freeside-setup
diff options
context:
space:
mode:
authorivan <ivan>2004-07-29 21:49:10 +0000
committerivan <ivan>2004-07-29 21:49:10 +0000
commitc69dd0d922bba433b16e3408f71f1cac0e16a069 (patch)
tree1b89ee1afcd6cc3cb1cc42a03568d7f46b4088f7 /FS/bin/freeside-setup
parent6ced9264b8ec79e4b460be90ede25ec72a7dfc16 (diff)
add index on cust_main.refnum, speeds up advertising source list
Diffstat (limited to 'FS/bin/freeside-setup')
-rwxr-xr-xFS/bin/freeside-setup2
1 files changed, 1 insertions, 1 deletions
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' ],
],
},