[Asterisk-Users] MYSQL Table Structure

Tilghman Lesher tilghman at mail.jeffandtilghman.com
Mon Jul 21 21:32:17 MST 2003


On Monday 21 July 2003 23:21, Aaron Martin wrote:
> For the information of others (and Google) this is the table
> structure I used to get cdr_mysql working:
>
> CREATE TABLE cdr (
>   calldate varchar(255) NOT NULL default '',
>   clid varchar(255) NOT NULL default '',
>   src varchar(255) NOT NULL default '',
>   dst varchar(255) NOT NULL default '',
>   dcontext varchar(255) NOT NULL default '',
>   channel varchar(255) NOT NULL default '',
>   dstchannel varchar(255) NOT NULL default '',
>   lastapp varchar(255) NOT NULL default '',
>   lastdata varchar(255) 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(255) NOT NULL default '',
>   KEY src (src),
>   KEY clid (clid),
>   KEY dst (dst),
>   KEY accountcode (accountcode)
> ) TYPE=MyISAM COMMENT='Asterisk CDR table';

Captain Obvious says:

root at tweedledee:/cvs/asterisk# head -11 doc/cdr_mysql.txt | tail -1
CREATE TABLE cdr (
root at tweedledee:/cvs/asterisk# grep cdr_mysql.txt doc/CVS/Entries
/cdr_mysql.txt/1.1.1.1/Wed Feb 12 13:59:15 2003//

-Tilghman




More information about the asterisk-users mailing list