[Asterisk-Users] cdr_mysql table definition

[Gijsbert van den Brink]

Hmm, I definitely need some more coffee!
I searched through all the documentation I could find, I even looked at
cdr/cdr_mysql.c... but I must have overlooked the docs directory :-/

Thanks for your quick response.

> I asked the same question a short while ago and got blasted for not
reading the documentation.. :)
>
> Look in the Asterisk source directory under /docs and look at
cdr_mysql.txt
>
> Here is the table schema anyway..
>
> CREATE TABLE cdr (
>   calldate datetime NOT NULL default '0000-00-00 00:00:00',
>   clid varchar(45) NOT NULL default '',
>   src varchar(45) NOT NULL default '',
>   dst varchar(45) NOT NULL default '',
>   dcontext varchar(45) NOT NULL default '',
>   channel varchar(45) NOT NULL default '',
>   dstchannel varchar(45) NOT NULL default '',
>   lastapp varchar(45) NOT NULL default '',
>   lastdata varchar(45) NOT NULL default '',
>   duration int(11) NOT NULL default '0',
>   billsec int(11) NOT NULL default '0',
>   disposition int(11) NOT NULL default '0',
>   amaflags int(11) NOT NULL default '0',
>   accountcode varchar(45) NOT NULL default ''
> );
>
> > Hi all,
> >
> > I'm looking at the mysql cdr backend to record call details, but I can't
> > find any documentation on how to set up my database.
> > Specifically, what is the table definition for the cdr table?
> > I saw that the dbname, user and password can be set in cdr_mysql.conf,
but
> > there's no information on what table to use.
> >
> > Thanks,
> > Gijsbert
> >
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-users
>
> --
> ______________________________________________
> http://www.linuxmail.org/
> Now with e-mail forwarding for only US$5.95/yr
>
> Powered by Outblaze
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
>