How store the complete cdr to mysql

Asterisk Asterisk Support
1

hello forum,

I had setup my MySQL Database like this:

CREATE TABLE `cdr` ( `calldate` datetime NOT NULL default '0000-00-00 00:00:00', `clid` varchar(80) NOT NULL default '', `src` varchar(80) NOT NULL default '', `dst` varchar(80) NOT NULL default '', `dcontext` varchar(80) NOT NULL default '', `channel` varchar(80) NOT NULL default '', `dstchannel` varchar(80) NOT NULL default '', `lastapp` varchar(80) NOT NULL default '', `lastdata` varchar(80) NOT NULL default '', `start` datetime NOT NULL default '0000-00-00 00:00:00', `answer` datetime NOT NULL default '0000-00-00 00:00:00', `end` datetime NOT NULL default '0000-00-00 00:00:00', `duration` int(11) NOT NULL default '0', `billsec` int(11) NOT NULL default '0', `disposition` varchar(45) NOT NULL default '', `amaflags` int(11) NOT NULL default '0', `accountcode` varchar(20) NOT NULL default '', `uniqueid` varchar(32) NOT NULL default '', `userfield` varchar(255) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Why I can not store the fields start, answer and stop in my MySQL table?
all fields are stored, but only start, answer and stop not in my table :angry: