Cant have been that obvious...
----- Original Message ----- From: "Tilghman Lesher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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: > > [EMAIL PROTECTED]:/cvs/asterisk# head -11 doc/cdr_mysql.txt | tail -1 > CREATE TABLE cdr ( > [EMAIL PROTECTED]:/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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
