diff options
| author | ivan <ivan> | 2009-12-02 20:58:51 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-12-02 20:58:51 +0000 |
| commit | c6db21c269f5a73986be7ab631def530392d185f (patch) | |
| tree | 8da2eb5b34e331d1aa78fbe43a13a089033a0a7a | |
| parent | bfb50b19988ff9010eda5d3ce87d99b5db32b9a0 (diff) | |
add index to rate_prefix.npa for a performance improvement on CDR billing, RT#6386
| -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 06baab6ed..c08a30032 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1969,7 +1969,7 @@ sub tables_hashref { ], 'primary_key' => 'prefixnum', 'unique' => [], - 'index' => [ [ 'countrycode' ], [ 'regionnum' ] ], + 'index' => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ], }, 'usage_class' => { |