[asterisk-users] Asterisk + mySQL

[jonas kellens]

Thanks for your reply. I saw that info also on voip-info.org.

I was wondering if I could define other columns, like those used for
billing (as defined in my sip.conf).

Jonas.


On Tue, 2009-06-23 at 09:22 +0100, Ishfaq Malik wrote:

> Hi
> 
> The calldate column is the date and time of the call, here's the 
> definition of the cdr table
> 
> CREATE TABLE `cdr` (
> `calldate` datetime NOT NULL default '0000-00-00 00:00:00',
> `clid` varchar(80) NOT NULL default '',
> `src` varchar(80) NOT NULL default '',
> `dst` varchar(80) NOT NULL default '',
> `dcontext` varchar(80) NOT NULL default '', 
> `channel` varchar(80) NOT NULL default '',
> `dstchannel` varchar(80) NOT NULL default '',
> `lastapp` varchar(80) NOT NULL default '',
> `lastdata` varchar(80) NOT NULL default '',
> `duration` int(11) NOT NULL default '0',
> `billsec` int(11) NOT NULL default '0',
> `disposition` varchar(45) NOT NULL default '', 
> `amaflags` int(11) NOT NULL default '0',
> `accountcode` varchar(20) NOT NULL default '',
> `userfield` varchar(255) NOT NULL default ''
> );
> 
> ALTER TABLE `cdr` ADD `uniqueid` VARCHAR(32) NOT NULL default '';
> ALTER TABLE `cdr` ADD INDEX ( `calldate` );
> ALTER TABLE `cdr` ADD INDEX ( `dst` );
> ALTER TABLE `cdr` ADD INDEX ( `accountcode` );
> 
> 
> I got that info from here
> 
> http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql
> 
> Ish
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090623/6bc7c95d/attachment.htm