完整版短视频矩阵营销管理系统.zip

-- MySQL dump 10.13 Distrib 5.6.50, for Linux (x86_64) -- -- Host: localhost Database: ceshi1 -- ------------------------------------------------------ -- Server version 5.6.50-log /*!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 utf8mb4 */; /*!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 */; -- -- Table structure for table `think_account` -- DROP TABLE IF EXISTS `think_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `think_account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nickname` varchar(255) NOT NULL DEFAULT '', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '会员状态 1 正常 2 禁用 3.待审核', `member_id` int(11) NOT NULL DEFAULT '0', `open_id` varchar(255) DEFAULT '0', `union_id` varchar(255) DEFAULT '0', `video_count` int(11) NOT NULL DEFAULT '0' COMMENT '视频数量', `play_count` int(11) NOT NULL DEFAULT '0' COMMENT '曝光数量/播放数量', `comment_count` int(11) NOT NULL DEFAULT '0' COMMENT '评论数量', `digg_count` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数量', `download_count` int(11) NOT NULL DEFAULT '0' COMMENT '下载数量', `forward_count` int(11) NOT NULL DEFAULT '0' COMMENT '转发数量', `share_count` int(11) NOT NULL DEFAULT '0' COMMENT '分享数量', `chat_count` int(11) NOT NULL DEFAULT '0' COMMENT '私信数量', `e_account_role` varchar(255) DEFAULT '' COMMENT '`EAccountM` - 普通企业号 * `EAccountS` - 认证企业号 * `EAccountK` - 品牌企业号 ', `access_token` varchar(255) DEFAULT '' COMMENT 'access_token', `access_token_time` int(11) NOT NULL DEFAULT '0' COMMENT 'access_token的过期时间', `refresh_token` varchar(255) DEFAULT NULL COMMENT 'refresh_token', `refresh_token_time` int(11) NOT NULL DEFAULT '0' COMMENT 'refresh_token的过期时间', `user_refresh_count` int(11) NOT NULL DEFAULT '0' COMMENT '刷新数据次数', `user_refresh_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后一次刷新次数时间', `reply_refresh_count` int(11) NOT NULL DEFAULT '0' COMMENT '刷新评论次数', `reply_refresh_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后一次刷新评论时间', `customer_refresh_count` int(11) NOT NULL DEFAULT '0' COMMENT '刷新客户次数', `customer_refresh_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后一次刷新客户时间', `update_time` int(11) NOT NULL DEFAULT '0', `create_time` int(11) NOT NULL DEFAULT '0', `delete_time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `think_account` -- LOCK TABLES `think_account` WRITE; /*!40000 ALTER TABLE `think_account` DISABLE KEYS */; /*!40000 ALTER TABLE `think_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `think_account_chat` -- DROP TABLE IF EXISTS `think_account_chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `think_account_chat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL DEFAULT '0' COMMENT '企业号id', `text` text COMMENT '消息内容', `to_user_id` varchar(255) DEFAULT '' COMMENT '接受的open_id', `to_cust_id` int(11) NOT NULL DEFAULT '0' COMMENT '接受人的关联客户id', `from_user_id` varchar(255) DEFAULT '' COMMENT '发送的open_id', `from_cust_id` int(11) NOT NULL DEFAULT '0' COMMENT '发送人的关联客户id', `message_id` varchar(255) DEFAULT '' COMMENT '消息id', `message_type` varchar(255) DEFAULT '' COMMENT '消息类型', `log_id` varchar(255) DEFAULT '' COMMENT '记录id', `to_type` int(11) NOT NULL DEFAULT '0' COMMENT '1:平台发送 2:平台接收', `create_time` int(11) DEFAULT '0', `update_time` int(11) DEFAULT '0', `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id', `delete_time` int(11) DEFAULT '0', `work_status` int(11) NOT NULL DEFAULT '0' COMMENT '0:待通知 1:已通知', `look_status` int(11) NOT NULL DEFAULT '0' COMMENT '0:待查看 1:已查看', `chat_auto` int(11) NOT NULL DEFAULT '0' COMMENT '0:待匹配自动回复 1:已匹配', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `think_account_chat` -- LOCK TABLES `think_account_chat` WRITE; /*!40000 ALTER TABLE `think_account_chat` DISABLE KEYS */; /*!40000 ALTER TABLE `think_account_chat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `think_account_cust` -- DROP TABLE IF EXISTS `think_account_cust`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `think_account_cust` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nickname` varchar(255) NOT NULL DEFAULT '', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像', `age` int(11) NOT NULL DEFAULT '0' COMMENT '年龄', `city` char(50) DEFAULT NULL COMMENT '城市', `gender` int(11) NOT NULL DEFAULT '0' COMMENT '性别 * `0` - 未知 * `1` - 男 * `2` - 女 ', `is_follow` char(50) DEFAULT '0', `leads_level` int(11) DEFAULT '0' COMMENT '用户状态 * `-1` - 没兴趣 * `0` - 了解 * `1` - 有兴趣 * `2` - 有意愿 * `10` - 已转化', `telephone` varchar(255) DEFAULT NULL COMMENT '手机号', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '会员状态 1 正常 2 禁用 3.待审核', `account_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属企业号', `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属用户', `open_id` varchar(255) DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0', `create_time` int(11) NOT NULL DEFAULT '0', `delete_time` int(11) NOT NULL DEFAULT '0', `last_chat_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后聊天时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `think_account_cust` -- LOCK TABLES `think_account_cust` WRITE; /*!40000 ALTER TABLE `think_account_cust` DISABLE KEYS */; /*!40000 ALTER TABLE `think_account_cust` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `think_account_reply` -- DROP TABLE IF EXISTS `think_account_reply`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `think_account_reply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `comment_id` varchar(255) DEFAULT '' COMMENT '评论id', `comment_user_id` varchar(255) DEFAULT '' COMMENT '该条评论发布者的user_id ', `content` text COMMENT '评论的具体内容', `digg_count` int(11) NOT NULL DEFAULT '0' COMMENT '该评论的点赞数', `reply_comment_total` int(11) NOT NULL DEFAULT '0' COMMENT '该评论的回复数量', `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属用户', `account_id` int(11) NOT NULL DEFAULT '0' COMMENT '抖音账号id', `account_title` varchar(255) DEFAULT NULL COMMENT '抖音账号昵称', `video_id` int(11) NOT NULL DEFAULT '0' COMMENT '视频id', `video_title` varchar(255) DEFAULT NULL COMMENT '视频标题', `top` char(50) DEFAULT '' COMMENT '该评论是否被置顶', `reply_content` text COMMENT