ZyXEL Communications X2002, Руководство пользователя

Страница: 401 / 562

Chapter 27 Call Detail Record (CDR)
X2002 User’s Guide
401
Each field is described in the following table.
27.5 CDR Technical Reference
This ia a sample of cdr.sql file content.
Table 159 CDR Query > Report
LABEL DESCRIPTION
Left / Right Use the Left and Right icons to change the page you want to view (if the
report has more than one page). Alternatively, use the drop down list
box to select the page you want to view.
Lines/Page Specify how many lines you want to display on each page of the report.
Total This field displays the total records created by this report.
Report Output
Fields The format of your report depends on the criteria you select in the
Report > LOGS > CDR > CDR Query page. See Section 27.4 on page
398 for explanation of all criteria.
-- mysql -u sqlzyxel -p123456 < cdr.sql
CREATE DATABASE cdr;
GRANT ALL PRIVILEGES ON cdr.* TO sqlzyxel IDENTIFIED BY '123456';
USE cdr;
-- create cdr table
CREATE TABLE IF NOT EXISTS `cdr` (
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` 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 '',
`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',
`accountcode` varchar(20) NOT NULL default '',
`userfield` varchar(255) NOT NULL default ''
);
ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );