<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3516.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>For the information of others (and Google) this is
the table structure I used to get cdr_mysql working:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>CREATE TABLE cdr (<BR> calldate varchar(255)
NOT NULL default '',<BR> clid varchar(255) NOT NULL default '',<BR>
src varchar(255) NOT NULL default '',<BR> dst varchar(255) NOT NULL
default '',<BR> dcontext varchar(255) NOT NULL default '',<BR>
channel varchar(255) NOT NULL default '',<BR> dstchannel varchar(255) NOT
NULL default '',<BR> lastapp varchar(255) NOT NULL default '',<BR>
lastdata varchar(255) NOT NULL default '',<BR> duration int(11) NOT NULL
default 0,<BR> billsec int(11) NOT NULL default 0,<BR> disposition
int(11) NOT NULL default 0,<BR> amaflags int(11) NOT NULL default
0,<BR> accountcode varchar(255) NOT NULL default '',<BR> KEY src
(src),<BR> KEY clid (clid),<BR> KEY dst (dst),<BR> KEY
accountcode (accountcode)<BR>) TYPE=MyISAM COMMENT='Asterisk CDR
table';</FONT></DIV>
<DIV> </DIV></BODY></HTML>