代码人生

安装“市话验证及客服系统”数据库

cd /usr/local/mysql/bin

./mysql -uroot -p

mysql>

create database calllogdb;

grant all on calllogdb.* to mycalllog@localhost identified by ‘easysystem’;

use calllogdb;

DROP TABLE IF EXISTS incominglog;
CREATE TABLE incominglog (
id int(12) NOT NULL auto_increment,
callerid varchar(20) NOT NULL,
timeringcoming datetime NOT NULL default ‘0000-00-00 00:00:00′,
timehangup datetime NOT NULL default ‘0000-00-00 00:00:00′,
funname varchar(20) NOT NULL default ”,
status varchar(20) NOT NULL default ”,
tdmport int(1) NOT NULL default ‘0′,
PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS answerlog;
CREATE TABLE answerlog (
seqno int(12) NOT NULL auto_increment,
callerid varchar(20) NOT NULL,
agentid varchar(20) NOT NULL,
starttime datetime NOT NULL default ‘0000-00-00 00:00:00′,
endtime datetime NOT NULL default ‘0000-00-00 00:00:00′,
status varchar(20) NOT NULL default ”,
monitor_filename varchar(100) NOT NULL,
tdmport int(1) NOT NULL default ‘0′,
callid varchar(20) NOT NULL,
PRIMARY KEY (seqno)
) TYPE=MyISAM;

quit;