[asterisk-users] CDR_MYSQL 1.4 Database Structure

[Gergo Csibra]

Wednesday, December 30, 2009, 6:48:37 PM, Robert wrote:

> Tilghman Lesher wrote:
>> On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote:
>>>
>>> Just curious if anyone has successfully patched cdr_addon_mysql to use
>>> accept the latest cdr fields from 1.4 ... namely: 'start', 'answer', 'end'?
>>> Seems logical that the cdr_mysql addon should be updated to reflect the
>>> current cdr. And for backwards compatibility it can still accept
>>> 'calldate'.
>>>     
>>
>> The MySQL driver contains all of the same information, albeit in a slightly
>> different form.  Calldate is the same as start, calldate plus duration minus
>> billsec is the same as answer, and calldate plus duration is the same as end.
>>
>> Generally, we do not make design changes in the middle of a release cycle,
>> especially given that such changes would break a great many existing systems.
>> Given that there's no security reason why we would need to make such a change,
>> it is out of the question.  While you're certainly welcome to make such a
>> change on your own systems, such a change will not be committed in the 1.4
>> addons.
>>
>> In the 1.6 series and forward, we've changed the mysql driver to scan the
>> table metadata and adapt the queries to the table structure.  Therefore, you
>> could, in fact, use 'start', 'answer', and 'end' in the 1.6 series, as you
>> suggested, above, and it would work perfectly well.  On the other hand, if you
>> kept the legacy structure, that would work, too.
>>
>>   
> Thanks for the reply.

> So my next question is could I take the cdr_mysql from 1.6's addons and 
> use it in 1.4?

I don't think so. But you can define more columns, and an insert
trigger which calculates the missing fields as defined in Tilghman's
reply.

-- 
Best regards,
 Gergo                            mailto:csibra at gmail.com