[asterisk-dev] CDR variables

[Olle E. Johansson]

22 nov 2009 kl. 19.12 skrev Tilghman Lesher:

> On Sunday 22 November 2009 08:17:08 Olle E. Johansson wrote:
>> 22 nov 2009 kl. 15.05 skrev Benny Amorsen:
>>> "Olle E. Johansson" <oej at edvina.net> writes:
>>>> Can we make a distinction like channel variables, that system added
>>>> variables being UPPER CASE in the future? Obviously we all missed this
>>>> case when we added the CDR availables.
>>> 
>>> Case distinctions are not so useful if the CDR's are going to be stored
>>> in SQL. SQL is stuck with case-insensitive column names (often
>>> ASCII-only). Welcome to 1970.
>> 
>> Maybe it was more EBCDIC at that time.
>> 
>> I guess that the proposal at the bottom is better then - to prefix with
>> underscore.
> 
> That's fine, I guess.  I probably would need to make that underscore optional
> in the adaptive drivers, in terms of the column name.  I think I'd rather deal
> with an 'ast' prefix, much like how many databases reserve 'sys' for their own
> tables and column names.

The idea with the underscore was to use something stupid internally in Asterisk. Maybe each driver could determine how to translate the underscore to something else. 

I'm fine with "ast-" as a prefix too. Like "ast-rtp-qos-audio"

/O