[Asterisk-Users] ASTCC configuration problem

[Karl H. Putz]

> 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