projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
add index to rate_prefix.npa for a performance improvement on CDR billing, RT#6386
[freeside.git]
/
FS
/
FS
/
Schema.pm
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
cf6844e
..
690cba5
100644
(file)
--- 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' => {