diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2017-01-25 19:53:57 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2017-01-25 19:53:57 -0800 |
| commit | 0ba992bb60f8895f926b18e22957e821d2b25bf0 (patch) | |
| tree | 9694f5d10882379875ca518e4427379bda378fdc /FS/FS/Schema.pm | |
| parent | 6397b13373e15c80a8c4623bdbbae90417b038f6 (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 39e0d11..36bd56b 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -5593,7 +5593,8 @@ sub tables_hashref { 'unique' => [], 'index' => [ [ 'calldate' ], [ 'src' ], [ 'dst' ], [ 'dcontext' ], [ 'charged_party' ], - [ 'startdate' ], + [ 'startdate' ], [ 'duration' ], + [ 'cdrtypenum' ], [ 'calltypenum' ], [ 'lastapp' ], ['accountcode'], ['uniqueid'], ['carrierid'], ['cdrid'], [ 'sessionnum' ], [ 'subscriber' ], |