[Asterisk-Users] ASTCC MySQL CDR's

[Kanuri, Seshu (Company IT)]

/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.