[Asterisk-Users] MYSQL Table Structure

[Aaron Martin]

Cant have been that obvious...


----- Original Message ----- 
From: "Tilghman Lesher" <tilghman at mail.jeffandtilghman.com>
To: <asterisk-users at lists.digium.com>
Sent: Tuesday, July 22, 2003 4:32 PM
Subject: Re: [Asterisk-Users] MYSQL Table Structure


> 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
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
>