+ 'index' => [ [ 'calldate' ],
+ [ 'src' ], [ 'dst' ], [ 'dcontext' ], [ 'charged_party' ],
+ [ 'accountcode' ], [ 'carrierid' ], [ 'cdrid' ],
+ [ 'freesidestatus' ], [ 'freesiderewritestatus' ],
+ [ 'cdrbatch' ],
+ ],
+ },
+
+ #'cdr_batch' => {
+ # 'columns' => [
+ # 'cdrbatchnum', 'serial', '', '', '', '',
+ # 'cdrbatch', 'varchar', 'NULL', 255, '', '',
+ # '_date', @date_type, '', '',
+ # ],
+ # 'primary_key' => 'cdrbatchnum',
+ # 'unique' => [ [ 'cdrbatch' ] ],
+ # 'index' => [],
+ #},
+
+ 'cdr_termination' => {
+ 'columns' => [
+ 'cdrtermnum', 'bigserial', '', '', '', '',
+ 'acctid', 'bigint', '', '', '', '',
+ 'termpart', 'int', '', '', '', '',#future use see below
+ 'rated_price', 'decimal', 'NULL', '10,4', '', '',
+ 'status', 'varchar', 'NULL', 32, '', '',
+ ],
+ 'primary_key' => 'cdrtermnum',
+ 'unique' => [ [ 'acctid', 'termpart' ] ],
+ 'index' => [ [ 'acctid' ], [ 'status' ], ],