开源中国 2018 年度最后一场技术盛会邀你来约~错过就要等明年啦!点此立即预约

白云飞 / whisper_tp5PHPGPL-3.0

Watch 36 Star 162 Fork 45
加入码云
与超过 300 万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
whisper.sql 13.83 KB
一键复制 编辑 Web IDE 原始数据 按行查看 历史
byf 提交于 2018-05-04 16:11 . update
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50553
Source Host : 127.0.0.1:3306
Source Database : whisper
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2018-03-17 15:03:51
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ws_admins
-- ----------------------------
DROP TABLE IF EXISTS `ws_admins`;
CREATE TABLE `ws_admins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密码',
`last_login_ip` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '最后登录IP',
`last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
`status` int(1) NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of ws_admins
-- ----------------------------
INSERT INTO `ws_admins` VALUES ('1', 'admin', 'cbb2fc826b6cbb2305cca827529b739b', '127.0.0.1', '1521187852', '1');
INSERT INTO `ws_admins` VALUES ('2', '小白', 'cb78913de44f5a36ab63e8ffacde44b0', '', '0', '1');
-- ----------------------------
-- Table structure for ws_chat_log
-- ----------------------------
DROP TABLE IF EXISTS `ws_chat_log`;
CREATE TABLE `ws_chat_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from_id` varchar(55) NOT NULL COMMENT '网页用户随机编号(仅为记录参考记录)',
`from_name` varchar(255) NOT NULL COMMENT '发送者名称',
`from_avatar` varchar(255) NOT NULL COMMENT '发送者头像',
`to_id` varchar(55) NOT NULL COMMENT '接收方',
`to_name` varchar(255) NOT NULL COMMENT '接受者名称',
`content` text NOT NULL COMMENT '发送的内容',
`time_line` int(10) NOT NULL COMMENT '记录时间',
PRIMARY KEY (`id`),
KEY `fromid` (`from_id`(4)) USING BTREE,
KEY `toid` (`to_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_chat_log
-- ----------------------------
INSERT INTO `ws_chat_log` VALUES ('1', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '你在干嘛呢?', '1521177459');
INSERT INTO `ws_chat_log` VALUES ('2', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '啊大大啊阿达是', '1521177463');
INSERT INTO `ws_chat_log` VALUES ('3', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', '嗯嗯嗯', '1521177471');
INSERT INTO `ws_chat_log` VALUES ('4', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', '其味无穷二群翁群翁', '1521177480');
INSERT INTO `ws_chat_log` VALUES ('5', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '怎么解释', '1521177488');
INSERT INTO `ws_chat_log` VALUES ('6', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', '驱蚊器二', '1521179009');
INSERT INTO `ws_chat_log` VALUES ('7', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '说话没法关闭', '1521179074');
INSERT INTO `ws_chat_log` VALUES ('8', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', ' face[猪头] ', '1521179109');
INSERT INTO `ws_chat_log` VALUES ('9', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', ' face[黑线] ', '1521179115');
INSERT INTO `ws_chat_log` VALUES ('10', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '你们干嘛呢?', '1521179267');
INSERT INTO `ws_chat_log` VALUES ('11', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '阿萨德', '1521179419');
INSERT INTO `ws_chat_log` VALUES ('12', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', ' face[猪头] ', '1521179862');
INSERT INTO `ws_chat_log` VALUES ('13', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '好朋友', '1521187501');
INSERT INTO `ws_chat_log` VALUES ('14', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', 'qwewq ', '1521188657');
INSERT INTO `ws_chat_log` VALUES ('15', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', 'sdasd ', '1521188837');
INSERT INTO `ws_chat_log` VALUES ('16', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', 'asda ', '1521188849');
INSERT INTO `ws_chat_log` VALUES ('17', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', 'asdas ', '1521188868');
INSERT INTO `ws_chat_log` VALUES ('18', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', '干么的', '1521188880');
INSERT INTO `ws_chat_log` VALUES ('19', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '阿达', '1521189214');
INSERT INTO `ws_chat_log` VALUES ('20', '2', '会员2', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '请问', '1521189860');
INSERT INTO `ws_chat_log` VALUES ('21', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '2', '会员2', 'AS ', '1521190128');
INSERT INTO `ws_chat_log` VALUES ('22', 'KF1', '客服', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '1', '会员1', '驱蚊器无', '1521194101');
INSERT INTO `ws_chat_log` VALUES ('23', '1', '会员1', 'http://wx2.sinaimg.cn/mw690/5db11ff4gy1flxmew7edlj203d03wt8n.jpg', 'KF1', '客服', '请问', '1521194123');
-- ----------------------------
-- Table structure for ws_groups
-- ----------------------------
DROP TABLE IF EXISTS `ws_groups`;
CREATE TABLE `ws_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分组id',
`name` varchar(255) NOT NULL COMMENT '分组名称',
`status` tinyint(1) NOT NULL COMMENT '分组状态',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_groups
-- ----------------------------
INSERT INTO `ws_groups` VALUES ('1', '售前组', '1');
INSERT INTO `ws_groups` VALUES ('2', '售后组', '1');
-- ----------------------------
-- Table structure for ws_kf_config
-- ----------------------------
DROP TABLE IF EXISTS `ws_kf_config`;
CREATE TABLE `ws_kf_config` (
`id` int(11) NOT NULL,
`max_service` int(11) NOT NULL COMMENT '每个客服最大服务的客户数',
`change_status` tinyint(1) NOT NULL COMMENT '是否启用转接',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_kf_config
-- ----------------------------
INSERT INTO `ws_kf_config` VALUES ('1', '5', '1');
-- ----------------------------
-- Table structure for ws_now_data
-- ----------------------------
DROP TABLE IF EXISTS `ws_now_data`;
CREATE TABLE `ws_now_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_talking` int(5) NOT NULL DEFAULT '0' COMMENT '正在咨询的人数',
`in_queue` int(5) NOT NULL DEFAULT '0' COMMENT '排队等待的人数',
`online_kf` int(5) NOT NULL COMMENT '在线客服数',
`success_in` int(5) NOT NULL COMMENT '成功接入用户',
`total_in` int(5) NOT NULL COMMENT '今日累积接入的用户',
`now_date` varchar(10) NOT NULL COMMENT '当前日期',
PRIMARY KEY (`id`),
KEY `now_date` (`now_date`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_now_data
-- ----------------------------
INSERT INTO `ws_now_data` VALUES ('1', '1', '0', '1', '14', '14', '2018-03-16');
-- ----------------------------
-- Table structure for ws_reply
-- ----------------------------
DROP TABLE IF EXISTS `ws_reply`;
CREATE TABLE `ws_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`word` varchar(255) NOT NULL COMMENT '自动回复的内容',
`status` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否自动回复',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_reply
-- ----------------------------
INSERT INTO `ws_reply` VALUES ('1', '欢迎使用whisper', '2');
-- ----------------------------
-- Table structure for ws_service_data
-- ----------------------------
DROP TABLE IF EXISTS `ws_service_data`;
CREATE TABLE `ws_service_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_talking` int(5) NOT NULL DEFAULT '0' COMMENT '正在咨询的人数',
`in_queue` int(5) NOT NULL DEFAULT '0' COMMENT '排队等待的人数',
`online_kf` int(5) NOT NULL COMMENT '在线客服数',
`success_in` int(5) NOT NULL COMMENT '成功接入用户',
`total_in` int(5) NOT NULL COMMENT '今日累积接入的用户',
`add_date` varchar(10) NOT NULL COMMENT '写入的日期',
`add_hour` varchar(2) NOT NULL COMMENT '写入的小时数',
`add_minute` varchar(2) NOT NULL COMMENT '写入的分钟数',
PRIMARY KEY (`id`),
KEY `add_date,add_hour` (`add_date`,`add_hour`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_service_data
-- ----------------------------
INSERT INTO `ws_service_data` VALUES ('1', '2', '1', '1', '2', '4', '2018-03-15', '09', '10');
INSERT INTO `ws_service_data` VALUES ('2', '0', '0', '0', '3', '4', '2018-03-15', '10', '15');
INSERT INTO `ws_service_data` VALUES ('3', '3', '4', '1', '4', '6', '2018-03-15', '11', '20');
INSERT INTO `ws_service_data` VALUES ('4', '0', '0', '0', '0', '2', '2018-03-15', '12', '25');
INSERT INTO `ws_service_data` VALUES ('5', '0', '0', '0', '0', '2', '2018-03-15', '13', '30');
INSERT INTO `ws_service_data` VALUES ('6', '0', '1', '0', '0', '3', '2018-03-15', '14', '35');
INSERT INTO `ws_service_data` VALUES ('7', '0', '0', '0', '0', '4', '2018-03-15', '15', '40');
INSERT INTO `ws_service_data` VALUES ('8', '0', '0', '0', '0', '4', '2018-03-15', '16', '45');
INSERT INTO `ws_service_data` VALUES ('9', '0', '0', '0', '0', '4', '2018-03-15', '17', '50');
INSERT INTO `ws_service_data` VALUES ('10', '0', '0', '0', '0', '4', '2018-03-15', '18', '55');
INSERT INTO `ws_service_data` VALUES ('11', '0', '0', '0', '1', '4', '2018-03-15', '08', '05');
INSERT INTO `ws_service_data` VALUES ('12', '0', '0', '1', '99', '100', '2018-03-16', '11', '35');
INSERT INTO `ws_service_data` VALUES ('13', '0', '0', '1', '102', '103', '2018-03-16', '12', '15');
INSERT INTO `ws_service_data` VALUES ('14', '0', '0', '1', '102', '103', '2018-03-16', '12', '55');
INSERT INTO `ws_service_data` VALUES ('15', '0', '0', '1', '1', '1', '2018-03-16', '14', '37');
INSERT INTO `ws_service_data` VALUES ('16', '0', '0', '1', '1', '1', '2018-03-16', '15', '17');
INSERT INTO `ws_service_data` VALUES ('17', '0', '0', '1', '1', '1', '2018-03-16', '15', '57');
INSERT INTO `ws_service_data` VALUES ('18', '1', '0', '1', '3', '3', '2018-03-16', '17', '31');
INSERT INTO `ws_service_data` VALUES ('19', '2', '0', '1', '14', '14', '2018-03-16', '18', '11');
-- ----------------------------
-- Table structure for ws_service_log
-- ----------------------------
DROP TABLE IF EXISTS `ws_service_log`;
CREATE TABLE `ws_service_log` (
`user_id` varchar(55) NOT NULL COMMENT '会员的id',
`client_id` varchar(20) NOT NULL COMMENT '会员的客户端标识',
`user_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
`user_avatar` varchar(155) NOT NULL COMMENT '会员头像',
`user_ip` varchar(15) NOT NULL COMMENT '会员的ip',
`kf_id` varchar(55) NOT NULL COMMENT '服务的客服id',
`start_time` int(10) NOT NULL COMMENT '开始服务时间',
`end_time` int(10) DEFAULT '0' COMMENT '结束服务时间',
`group_id` int(11) NOT NULL COMMENT '服务的客服的分组id',
KEY `user_id,client_id` (`user_id`,`client_id`) USING BTREE,
KEY `kf_id,start_time,end_time` (`kf_id`,`start_time`,`end_time`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_service_log
-- ----------------------------
-- ----------------------------
-- Table structure for ws_users
-- ----------------------------
DROP TABLE IF EXISTS `ws_users`;
CREATE TABLE `ws_users` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服id',
`user_name` varchar(255) NOT NULL COMMENT '客服名称',
`user_pwd` varchar(32) NOT NULL COMMENT '客服登录密码',
`user_avatar` varchar(255) NOT NULL COMMENT '客服头像',
`status` tinyint(1) NOT NULL COMMENT '用户状态',
`online` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否在线',
`group_id` int(11) DEFAULT '0' COMMENT '所属分组id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_users
-- ----------------------------
INSERT INTO `ws_users` VALUES ('1', '客服小白', 'cb78913de44f5a36ab63e8ffacde44b0', '/uploads/20171024/902b5294f41f6a7d1e1451c7c0969a21.jpg', '1', '2', '1');
INSERT INTO `ws_users` VALUES ('2', '客服小美', 'cb78913de44f5a36ab63e8ffacde44b0', '/uploads/20171024/43cb54a995b89d0926e1de31af0074fc.jpg', '1', '2', '1');
-- ----------------------------
-- Table structure for ws_words
-- ----------------------------
DROP TABLE IF EXISTS `ws_words`;
CREATE TABLE `ws_words` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(255) NOT NULL COMMENT '常用语内容',
`add_time` datetime NOT NULL COMMENT '添加时间',
`status` tinyint(1) NOT NULL COMMENT '是否启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ws_words
-- ----------------------------
INSERT INTO `ws_words` VALUES ('1', '欢迎来到whisper v1.0.0', '2017-10-25 12:51:09', '1');

评论 ( 0 )

你可以在登录后,发表评论

搜索帮助