语音通话插件的安装sql脚本

admin · 发表于 2016-5-18 22:15:28

CREATE TABLE IF NOT EXISTS pre_zhanmishu_call (
`cid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(20) NOT NULL,
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`calleduid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`call` varchar(20) NOT NULL,
`called` varchar(20) NOT NULL,
`request_id` varchar(20) NOT NULL,
`model` varchar(56) NOT NULL,
`iscall` tinyint(1) NOT NULL DEFAULT '0',
`issuccess` tinyint(1) NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`code` INT(6) unsigned NOT NULL DEFAULT '0',
`nums` SMALLINT(6) unsigned NOT NULL DEFAULT '0',
`ip1` smallint(3) NOT NULL default '0',
`ip2` smallint(3) NOT NULL default '0',
`ip3` smallint(3) NOT NULL default '0',
`ip4` smallint(3) NOT NULL default '0',
`msg` varchar(80) NOT NULL DEFAULT '',
`mts` int(6) unsigned NOT NULL DEFAULT '0',
`calltime` int(6) unsigned NOT NULL DEFAULT '0',
`maxcalltime` int(6) unsigned NOT NULL DEFAULT '0',
`pricepermin` int(6) unsigned NOT NULL DEFAULT '0',
`allcredits` int(6) unsigned NOT NULL DEFAULT '0',
`calledgetcredits` int(6) unsigned NOT NULL DEFAULT '0',
`sitegetcredits` int(6) unsigned NOT NULL DEFAULT '0',
`callbackcredits` int(6) unsigned NOT NULL DEFAULT '0',
`iscallback` tinyint(1) NOT NULL DEFAULT '0',
`iscalledback` tinyint(1) NOT NULL DEFAULT '0',
`issiteget` tinyint(1) NOT NULL DEFAULT '0',
`province` varchar(20) NOT NULL DEFAULT '',
`catname` varchar(20) NOT NULL DEFAULT '',
`telstring` varchar(20) NOT NULL DEFAULT '',
`areavid` int(6) unsigned NOT NULL DEFAULT '0',
`ispvid` int(6) unsigned NOT NULL DEFAULT '0',
`carrier` varchar(20) NOT NULL DEFAULT '',
`sub_code` varchar(80) NOT NULL DEFAULT '',
`err_code` varchar(80) NOT NULL DEFAULT '',
`sub_msg` varchar(80) NOT NULL DEFAULT '',
PRIMARY KEY (cid),
KEY uid (uid),
KEY calleduid (calleduid),
KEY type (type),
KEY id (id),
KEY called (called),
KEY `call` (`call`),
KEY mts (mts),
KEY province (province),
KEY allcredits (allcredits),
KEY calledgetcredits (calledgetcredits),
KEY callbackcredits (callbackcredits),
KEY pricepermin (pricepermin),
KEY calltime (calltime),
KEY catname (catname),
KEY areavid (areavid),
KEY telstring (telstring),
KEY request_id (request_id),
KEY carrier (carrier),
KEY code (code),
KEY nums (nums),
KEY sub_code (sub_code),
KEY iscall (iscall),
KEY issuccess (issuccess),
KEY dateline (dateline),
KEY ip1 (ip1),
KEY ip2 (ip2),
KEY ip3 (ip3),
KEY ip4 (ip4)
);
CREATE TABLE IF NOT EXISTS pre_zhanmishu_called (
`biz_id` varchar(56) NOT NULL,
`id` varchar(20) NOT NULL,
`duration` int(6) unsigned NOT NULL DEFAULT '0',
`dtmf` varchar(56) NOT NULL,
`extend` varchar(56) NOT NULL,
`isconfirm` tinyint(1) NOT NULL DEFAULT '0',
`end_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`start_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`pub_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`status_code` varchar(25) NOT NULL DEFAULT '',
`status_msg` varchar(80) NOT NULL DEFAULT '',
PRIMARY KEY (biz_id),
KEY dtmf (dtmf),
KEY duration (duration),
KEY id (id),
KEY extend (extend),
KEY isconfirm (isconfirm),
KEY end_time (end_time),
KEY start_time (start_time),
KEY status_code (status_code)
);
INSERT INTO `pre_common_cron` (`available`, `type`, `name`, `filename`, `lastrun`, `nextrun`, `weekday`, `day`, `hour`, `minute`) VALUES ('1', 'user', 'zhanmishu_tel', 'zhanmishu_tel:cron_zhanmishu_tel_called.php', '1463479243', '1463479380', '-1', '-1', '-1', '3,5,9,11,21,31,37,41,44,51,59');

复制代码

		自动登录	找回密码
密码			立即注册

[教程分享] 语音通话插件的安装sql脚本

相关帖子