-- -- Table structure for table `fscdr` -- DROP TABLE IF EXISTS `fscdr`; CREATE TABLE IF NOT EXISTS `fscdr` ( `accountcode` varchar(20) NOT NULL default '', `src` varchar(80) NOT NULL default '', `dst` varchar(80) NOT NULL default '', `dcontext` varchar(80) NOT NULL default '', `clid` 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 '', `calldate` datetime NOT NULL default '0000-00-00 00:00:00', `answerdate` datetime NOT NULL default '0000-00-00 00:00:00', `enddate` 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', `uniqueid` varchar(60) NOT NULL, `originator` varchar(60), `userfield` varchar(255) NOT NULL default '', `read_codec` varchar(60) NOT NULL default '', `write_codec` varchar(60) NOT NULL default '', `cost` varchar(20) NOT NULL default 'none', `vendor` varchar(20) NOT NULL default 'none', `provider` varchar(60) NOT NULL, `trunk` varchar(60) NOT NULL, `outbound_route` varchar(60) NOT NULL, `progressmsec` varchar(20) NOT NULL, `answermsec` varchar(20) NOT NULL, `progress_mediamsec` varchar(20) NOT NULL, KEY `calldate` (`calldate`), KEY `dst` (`dst`), KEY `accountcode` (`accountcode`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;