diff options
author | Ivan Kohler <ivan@freeside.biz> | 2017-01-25 19:53:55 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2017-01-25 19:53:55 -0800 |
commit | ca78f4530f7d5ee0b1b9f708e318108ad3aa1a7a (patch) | |
tree | 7528fe4fe5a0f90600e1d7637ba427c16281fda6 /FS/FS/Schema.pm | |
parent | 87762d33fc08d6a063bc16edab550bdb42f34c9f (diff) |
improve performance of CDR queries, RT#73889
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r-- | FS/FS/Schema.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index bacef72..1630f02 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -5621,7 +5621,8 @@ sub tables_hashref { 'unique' => [], 'index' => [ [ 'calldate' ], [ 'src' ], [ 'dst' ], [ 'dcontext' ], [ 'charged_party' ], - [ 'startdate' ], + [ 'startdate' ], [ 'duration' ], + [ 'cdrtypenum' ], [ 'calltypenum' ], [ 'lastapp' ], ['accountcode'], ['uniqueid'], ['carrierid'], ['cdrid'], [ 'sessionnum' ], [ 'subscriber' ], |