diff options
| author | ivan <ivan> | 2003-06-14 02:02:25 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-06-14 02:02:25 +0000 |
| commit | e669002f6922433385e34f0b4ad4469ab63811e1 (patch) | |
| tree | 1c1f8db0af4dc8257faee0ecc75cc75ef7e4dcc1 | |
| parent | ff7b2042620d4e31b0a55f3a9efb4c8ded3efaee (diff) | |
add index on cust_bill._date
| -rwxr-xr-x | FS/bin/freeside-setup | 2 | ||||
| -rwxr-xr-x | 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' => { |