> CREATE TABLE `cdrs` ( > > `cardnum` char(40) default NULL, > > `callerid` char(80) default NULL, > > `callednum` char(80) default NULL, > > `trunk` char(40) default NULL, > > `disposition` char(20) default NULL, > > `billseconds` int(11) default NULL, > > `billcost` int(11) default NULL > ) TYPE=MyISAM;
The cdrs table creation script is missing the callstart field. I use the sql below: CREATE TABLE `cdrs` ( `cardnum` varchar(40) default NULL, `callerid` varchar(80) default NULL, `callednum` varchar(80) default NULL, `trunk` varchar(40) default NULL, `disposition` varchar(20) default NULL, `billseconds` int(11) default NULL, `billcost` int(11) default NULL, `callstart` varchar(24) ) TYPE=MyISAM; Karl Putz _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
