一、安装mysql服务(不管实在哪个服务器上,只要是能连上就行)
创建数据库
CREATE DATABASE asterisk;
USE asterisk;
创建cdr表
CREATE TABLE `cdr` (
`calldate` DATETIME NOT NULL ,
`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 '',