diff options
| author | ivan <ivan> | 2009-12-02 20:58:48 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-12-02 20:58:48 +0000 |
| commit | 6235082affb5884d3caaaf18728771d322e0b2cf (patch) | |
| tree | 6f864125c386cf1c50b462c58d4ff42361c39fb6 /FS | |
| parent | 08b845d637fc6a54a88b019ed586bccdf0334b38 (diff) | |
add index to rate_prefix.npa for a performance improvement on CDR billing, RT#6386
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Schema.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index cf6844e18..690cba591 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2008,7 +2008,7 @@ sub tables_hashref { ], 'primary_key' => 'prefixnum', 'unique' => [], - 'index' => [ [ 'countrycode' ], [ 'regionnum' ] ], + 'index' => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ], }, 'usage_class' => { |