diff options
author | ivan <ivan> | 2002-10-04 12:57:06 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-10-04 12:57:06 +0000 |
commit | c4d2226e0cc4bdd6d9f689b061b5f4f5b9609b0b (patch) | |
tree | a2d1cfde286607ecfcded7c6a1726310098effab /FS/bin/freeside-setup | |
parent | 54a27b35957baddb725e2b7544d9f134989bfd99 (diff) |
working on the road:
- easier "change package" link for changing one package to another
- sqlradius export now compatible with Pg
- indices on phone numbers
- install instructions specify Pg 7.1 (at least until ILIKE thing is changed)
- searching on phone number fragments
Diffstat (limited to 'FS/bin/freeside-setup')
-rwxr-xr-x | FS/bin/freeside-setup | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index f6a543fc8..d61e8b0bf 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -111,8 +111,9 @@ my($dbdef) = new DBIx::DBSchema ( map { my $cust_main = $dbdef->table('cust_main'); unless ($ship) { #remove ship_ from cust_main $cust_main->delcolumn($_) foreach ( grep /^ship_/, $cust_main->columns ); -} else { #add indices on ship_last and ship_company - push @{$cust_main->index->lol_ref}, ( ['ship_last'], ['ship_company'] ) +} else { #add indices + push @{$cust_main->index->lol_ref}, + map { [ "ship_$_" ] } qw( last company daytime night fax ); } #add radius attributes to svc_acct @@ -496,7 +497,9 @@ sub tables_hash_hack { 'primary_key' => 'custnum', 'unique' => [], #'index' => [ ['last'], ['company'] ], - 'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ] ], + 'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ], + [ 'daytime' ], [ 'night' ], [ 'fax' ], + ], }, 'cust_main_invoice' => { |