-- MySQL dump 10.13 Distrib 5.7.26, for Linux (x86_64)
--
-- Host: localhost Database: nev
-- ------------------------------------------------------
-- Server version 5.7.26
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `nev`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `nev` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `nev`;
--
-- Table structure for table `web_chat_ems_2019_07`
--
DROP TABLE IF EXISTS `web_chat_ems_2019_07`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_chat_ems_2019_07` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`create_date_time` timestamp NULL DEFAULT NULL COMMENT '数据创建时间',
`session_id` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '七陌sessionId',
`sid` varchar(48) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '访客id',
`create_time` datetime DEFAULT NULL COMMENT '会话创建时间',
`seo_source` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '搜索来源',
`seo_keywords` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '关键字',
`ip` varchar(48) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'IP地址',
`area` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '地域',
`country` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '所在国家',
`province` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '省',
`city` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '城市',
`origin_channel` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '投放渠道',
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '所属坐席',
`manual_time` datetime DEFAULT NULL COMMENT '人工开始时间',
`begin_time` datetime DEFAULT NULL COMMENT '坐席领取时间 ',
`end_time` datetime DEFAULT NULL COMMENT '会话结束时间',
`last_customer_msg_time_stamp` datetime DEFAULT NULL COMMENT '客户最后一条消息的时间',
`last_agent_msg_time_stamp` datetime DEFAULT NULL COMMENT '坐席最后一下回复的时间',
`reply_msg_count` int(12) DEFAULT '0' COMMENT '客服回复消息数',
`msg_count` int(12) DEFAULT '0' COMMENT '客户发送消息数',
`browser_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '浏览器名称',
`os_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '系统名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=211198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `web_chat_ems_2019_07`
--
LOCK TABLES `web_chat_ems_2019_07` WRITE;
/*!40000 ALTER TABLE `web_chat_ems_2019_07` DISABLE KEYS */;
INSERT INTO `web_chat_ems_2019_07` VALUES (1,'2019-12-23 17:45:00','481aeb70-9c19-11e9-9a74-2f35b751ada5','3dba8460-9c19-11e9-ba58-a91e6c68cb36','2019-07-02 00:00:00','百度搜索','','113.119.156.105','中国 广东 广州','中国','广东','广州','未知','','2019-07-02 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 5.1.1'),(2,'2019-12-23 17:45:00','477cfdc0-9c19-11e9-88bf-291f631fb18c','4778b800-9c19-11e9-a6e6-49e71b626506','2019-07-01 23:59:00','其他网站','未知','223.90.243.56','中国 河南 许昌','中国','河南','许昌','未知','','2019-07-02 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','iOS 12.0'),(3,'2019-12-23 17:45:00','4597c300-9c19-11e9-9c9e-dd175450bfcc','97549c10-39b1-11e9-8c6b-a7d8c8ea8acb','2019-07-01 23:59:00','站内','','111.194.45.237','中国 北京 北京','中国','北京','北京','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','OS X 10.14.1'),(4,'2019-12-23 17:45:00','4414a570-9c19-11e9-bccd-45bba054701c','44101190-9c19-11e9-83d1-1762aa55e1f8','2019-07-01 23:59:00','百度搜索','SC4M','36.110.199.138','中国 北京 北京','中国','北京','北京','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 6.0.1'),(5,'2019-12-23 17:45:00','4335de30-9c19-11e9-83fd-8d8afacbd16c','43320da0-9c19-11e9-9381-292a67de89fc','2019-07-01 23:59:00','站内','','10.103.170.21','局域网 局域网','局域网','局域网','','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 8.0.0'),(6,'2019-12-23 17:45:00','428552e0-9c19-11e9-9d00-ebdfec890b7f','36f9b340-9c0e-11e9-a288-2f2ed132c7a1','2019-07-01 23:59:00','百度搜索','数学','117.162.113.246','中国 江西 上饶','中国','江西','上饶','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 8.1.0'),(7,'2019-12-23 17:45:00','41d033b0-9c19-11e9-ad1d-c78cc6b39ce0','19fcde40-7349-11e9-a393-2f1609eb2bc8','2019-07-01 23:59:00','其他网站','未知','112.96.173.162','中国 广东','中国','广东','','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','iOS 12.1.2'),(8,'2019-12-23 17:45:00','41fe2180-9c19-11e9-a46d-53534b574a0f','40a5a000-919d-11e9-aace-9bba37f2825e','2019-07-01 23:59:00','站内','','222.131.117.41','中国 北京 北京','中国','北京','北京','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome','OS X 10.14.5'),(9,'2019-12-23 17:45:00','403c2630-9c19-11e9-83fd-8d8afacbd16c','cdb65ea0-9c18-11e9-83d1-1762aa55e1f8','2019-07-01 23:59:00','站内','','223.104.11.60','中国 陕西','中国','陕西','','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome','Windows 7 / Server 2008 R2 64-bit'),(10,'2019-12-23 17:45:00','3eaa89b0-9c19-11e9-ad03-638d7474afec','3ea69210-9c19-11e9-bd15-81c8d4908f9a','2019-07-01 23:59:00','百度搜索','S3HB','36.110.199.244','中国 北京 北京','中国','北京','北京','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 6.0.1'),(11,'2019-12-23 17:45:00','3e31fe50-9c19-11e9-af30-2371659abf25','11d8b200-9c0e-11e9-844f-1508c4b66f88','2019-07-01 23:59:00','百度搜索','英语','39.170.223.134','中国 浙江 绍兴','中国','浙江','绍兴','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 5.1.1'),(12,'2019-12-23 17:45:00','3dbef130-9c19-11e9-bccd-45bba054701c','3dba8460-9c19-11e9-ba58-a91e6c68cb36','2019-07-01 23:59:00','百度搜索','','113.119.156.105','中国 广东 广州','中国','广东','广州','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 5.1.1'),(13,'2019-12-23 17:45:00','3c68d710-9c19-11e9-a46d-53534b574a0f','3c644330-9c19-11e9-8ce2-99bfe29661bd','2019-07-01 23:59:00','百度搜索','ETQH','36.110.199.135','中国 北京 北京','中国','北京','北京','百度竞价','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Chrome Mobile','Android 6.0.1'),(14,'2019-12-23 17:45:00','3bfe0750-9c19-11e9-a46d-53534b574a0f','3ba01200-996a-11e9-9381-292a67de89fc','2019-07-01 23:59:00','站内','','113.101.85.50','中国 广东 潮州','中国','广东','潮州','未知','','2019-07-01 23:59:00',NULL,NULL,NULL,NULL,NULL,NULL,'Safari','OS X 10.14.5'),(15,'2019-12-23 17:45:00','386a3230-9c19-11e9-bccd-45bba054701c','81e1ac00-812e-11e9-8b69-8301d33a1603','2019-07-01 23:59:00','百度搜索','三明php培训','111.40.197.141','中国 �
