[Asterisk-Users] ASTCC MySQL CDR's

[Nate Kapi]

Well the table is already there. All that info shows up under the
structure. I noticed it says "no index defined" for this table. But I
cant or dont know how to actually view all the data that its storing.
Can anyone else running astcc "browse" the cdrs table with phpmyadmin?
Thanks!


On Fri, 19 Nov 2004 12:30:14 -0500, Kanuri, Seshu (Company IT)
<seshu.kanuri at morganstanley.com> wrote:
> /SNIP/
> I am using phpmyadmin to view the astcc database and the cdr table is
> the only one that i cannot "browse"
> 
> Im sort of new to databases so if I am missing something here please let
> me know, as I would like to be able to have logs of all the cdr's for
> backup documentation. Thanks!
> /SNIP/
> 
> That means you don't have the CDR table. Create that first. Use the
> script below to create the table.
> 
> # Database: astcc
> # Table: 'cdrs'
> #
> 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;
> --------------------------------------------------------
> 
> NOTICE: If received in error, please destroy and notify sender.  Sender does not waive confidentiality or privilege, and use is prohibited.
> 
>