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
