wonderful/sql/wechat.sql

-- MySQL dump 10.16  Distrib 10.1.32-MariaDB, for Linux (x86_64)
--
-- Host: 0.0.0.0    Database: wechat
-- ------------------------------------------------------
-- Server version	10.1.32-MariaDB

/*!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 */;

--
-- Table structure for table `upload_manage_admin`
--

DROP TABLE IF EXISTS `upload_manage_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `username` varchar(24) DEFAULT NULL COMMENT '管理员名',
  `email` varchar(150) DEFAULT NULL COMMENT '邮箱-可用于登录，请准确填写，不允许重复',
  `mobile` varchar(32) DEFAULT NULL COMMENT '手机号',
  `password` varchar(64) DEFAULT NULL COMMENT '管理员密码',
  `config` int(11) NOT NULL DEFAULT '1' COMMENT '后台配置',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `group` int(11) NOT NULL DEFAULT '1' COMMENT '分组',
  `top` text COMMENT '头部菜单-这里的头部菜单如果设置，则会覆盖角色中的头部菜单',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据状态',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_admin`
--

LOCK TABLES `upload_manage_admin` WRITE;
/*!40000 ALTER TABLE `upload_manage_admin` DISABLE KEYS */;
INSERT INTO `upload_manage_admin` VALUES (1,'admin@admin.com','admin@admin.com',NULL,'8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92',1,'1',1,NULL,1,1,1543889304);
/*!40000 ALTER TABLE `upload_manage_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_auth`
--

DROP TABLE IF EXISTS `upload_manage_auth`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_auth` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `project` varchar(50) DEFAULT NULL COMMENT '项目KEY',
  `project_name` varchar(50) DEFAULT NULL COMMENT '项目名',
  `name` varchar(50) DEFAULT NULL COMMENT '权限名',
  `auth_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级权限',
  `key` varchar(100) DEFAULT NULL COMMENT '权限KEY',
  `value` varchar(30) DEFAULT NULL COMMENT '对应的值',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_auth`
--

LOCK TABLES `upload_manage_auth` WRITE;
/*!40000 ALTER TABLE `upload_manage_auth` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_manage_auth` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_config`
--

DROP TABLE IF EXISTS `upload_manage_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(32) DEFAULT NULL COMMENT '配置名',
  `template` int(1) NOT NULL DEFAULT '1' COMMENT '后台模板',
  `title` varchar(32) DEFAULT NULL COMMENT '后台TITLE',
  `info` varchar(40) DEFAULT NULL COMMENT '控制台欢迎标题',
  `content` text COMMENT '控制台欢迎内容',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_config`
--

LOCK TABLES `upload_manage_config` WRITE;
/*!40000 ALTER TABLE `upload_manage_config` DISABLE KEYS */;
INSERT INTO `upload_manage_config` VALUES (1,'默认配置',1,NULL,NULL,NULL,1,1543889304);
/*!40000 ALTER TABLE `upload_manage_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_group`
--

DROP TABLE IF EXISTS `upload_manage_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '组ID',
  `name` varchar(50) DEFAULT NULL COMMENT '组名称',
  `area` varchar(255) DEFAULT NULL COMMENT '区域',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_group`
--

LOCK TABLES `upload_manage_group` WRITE;
/*!40000 ALTER TABLE `upload_manage_group` DISABLE KEYS */;
INSERT INTO `upload_manage_group` VALUES (1,'默认分组',NULL,1,1543889305);
/*!40000 ALTER TABLE `upload_manage_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_log`
--

DROP TABLE IF EXISTS `upload_manage_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `project` varchar(32) DEFAULT NULL COMMENT '项目名',
  `table` varchar(32) DEFAULT NULL COMMENT '项目下的表名',
  `info` longtext COMMENT '日志记录',
  `admin` int(11) NOT NULL DEFAULT '0' COMMENT '操作人',
  `tid` int(11) NOT NULL DEFAULT '0' COMMENT '来源表ID',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_log`
--

LOCK TABLES `upload_manage_log` WRITE;
/*!40000 ALTER TABLE `upload_manage_log` DISABLE KEYS */;
INSERT INTO `upload_manage_log` VALUES (1,'token','project','PHRhYmxlIGNsYXNzPSJkZXZlci1pbWciIGJvcmRlcj0xIHdpZHRoPTEwMCUgaGVpZ2h0PTEwMCUgIGlkPSJkZXZlci1pbWciPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7mk43kvZw8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7Pmluc2VydDwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+5pON5L2c5Lq6PC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz5hZG1pbkBhZG1pbi5jb20tMTwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+5pON5L2cSVA8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7PjM2LjExMC44LjIyNjwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+5pON5L2c5pe26Ze0PC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz4yMDE4LTEyLTA0IDEwOjEwOjAzPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7mlbDmja5JRDwvdGQ+PHRkIHN0eWxlPXdpZHRoOjMwJTt3b3JkLWJyZWFrOmJyZWFrLWFsbDt3b3JkLXdyYXA6YnJlYWstd29yZDs+MTwvdGQ+PC90cj48dHI+PHRkIHN0eWxlPXdpZHRoOjMwJTtsaW5lLWhlaWdodDoxLjc1O2ZvbnQtd2VpZ2h0OmJvbGQ+6aG555uu5ZCN56ewPC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz7nsr7nvo7lsI/nqIvluo88L3RkPjwvdHI+PHRyPjx0ZCBzdHlsZT13aWR0aDozMCU7bGluZS1oZWlnaHQ6MS43NTtmb250LXdlaWdodDpib2xkPumhueebruexu+WeizwvdGQ+PHRkIHN0eWxlPXdpZHRoOjMwJTt3b3JkLWJyZWFrOmJyZWFrLWFsbDt3b3JkLXdyYXA6YnJlYWstd29yZDs+5bCP56iL5bqPPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7lvq7kv6FhcHBpZDwvdGQ+PHRkIHN0eWxlPXdpZHRoOjMwJTt3b3JkLWJyZWFrOmJyZWFrLWFsbDt3b3JkLXdyYXA6YnJlYWstd29yZDs+d3hkMDU5MDY2NGQwMDA0ZjIzPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7lvq7kv6FzZWNyZXQ8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7PjAwOWJmNDhmZmQ1YTNjZWVjYjZhOTMzNDkyZDY0MWQyPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7pgJrkv6F0b2tlbijms6jmhI/kuI3mmK9hY2Nlc3NfdG9rZW4pPC90ZD48dGQgc3R5bGU9d2lkdGg6MzAlO3dvcmQtYnJlYWs6YnJlYWstYWxsO3dvcmQtd3JhcDpicmVhay13b3JkOz5udWxsPC90ZD48L3RyPjx0cj48dGQgc3R5bGU9d2lkdGg6MzAlO2xpbmUtaGVpZ2h0OjEuNzU7Zm9udC13ZWlnaHQ6Ym9sZD7mtojmga/liqDop6Plr4blr4bpkqU8L3RkPjx0ZCBzdHlsZT13aWR0aDozMCU7d29yZC1icmVhazpicmVhay1hbGw7d29yZC13cmFwOmJyZWFrLXdvcmQ7Pm51bGw8L3RkPjwvdHI+PC90YWJsZT4=',1,1,1,1543889403);
/*!40000 ALTER TABLE `upload_manage_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_menu`
--

DROP TABLE IF EXISTS `upload_manage_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `menu_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级菜单',
  `key` varchar(100) DEFAULT NULL COMMENT '菜单唯一KEY',
  `link` varchar(150) DEFAULT NULL COMMENT '链接(或路径)',
  `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
  `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '开启子菜单',
  `icon` varchar(100) DEFAULT NULL COMMENT '图标代码-请<A HREF="HTTPS://WWW.LAYUI.COM/DOC/ELEMENT/ICON.HTML" TARGET="_BLANK">点此</A>查看图标代码',
  `fast` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否快捷菜单',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_menu`
--

LOCK TABLES `upload_manage_menu` WRITE;
/*!40000 ALTER TABLE `upload_manage_menu` DISABLE KEYS */;
INSERT INTO `upload_manage_menu` VALUES (1,'主页',-1,'console','console:主页',10000,2,'layui-icon-home',2,1,1543889305),(2,'控制台',1,'console.index','http://www.huoxingkandiqiu.com/wechat/manage/?l=console',10,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(3,'后台设置',-1,'manage','/share/lib/php/dever_package/manage/:后台设置',-100,2,'glyphicon glyphicon-wrench layui-icon-set-sm',2,1,1543889305),(4,'管理账户设置',3,'manage.admin','project/database/list?project=manage&table=admin&menu=manage&search_option_state=1',9,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(5,'后台个性化',3,'manage.config','project/database/list?project=manage&table=config&menu=manage&search_option_state=1',10,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(6,'计划任务',3,'manage.cron','project/database/list?project=manage&table=cron&menu=manage&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(7,'管理组设置',3,'manage.group','project/database/list?project=manage&table=group&menu=manage&search_option_state=1',8,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(8,'管理操作日志',3,'manage.log','project/database/list?project=manage&table=log&menu=manage&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(9,'管理菜单设置',3,'manage.menu','project/database/list?project=manage&table=menu&menu=manage&search_option_state=1',2,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(10,'后台公告管理',3,'manage.notice','project/database/list?project=manage&table=notice&menu=manage&search_option_state=1',7,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(11,'字段记录表',3,'manage.opt','project/database/list?project=manage&table=opt&menu=manage&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(12,'管理角色设置',3,'manage.role','project/database/list?project=manage&table=role&menu=manage&search_option_state=1',8,2,'glyphicon glyphicon-folder-close',2,1,1543889305),(13,'微信开发管理',-1,'token','/share/lib/php/dever_package/token/:微信开发管理',-1,2,'glyphicon glyphicon-road',2,1,1543889336),(14,'请求日志',13,'token.log','project/database/list?project=token&table=log&menu=token&search_option_state=1',1,2,'glyphicon glyphicon-folder-close',2,1,1543889336),(15,'项目管理',13,'token.project','project/database/list?project=token&table=project&menu=token&search_option_state=1',-10,2,'glyphicon glyphicon-folder-close',2,1,1543889336),(16,'小程序管理',-1,'wechat_applet','/share/lib/php/dever_package/wechat_applet/:小程序管理',90,2,'glyphicon glyphicon-tint',2,1,1543889345),(17,'模板消息列表',16,'wechat_applet.msg','project/database/list?project=wechat_applet&table=msg&menu=wechat_applet&search_option_state=1',100,2,'glyphicon glyphicon-folder-close',2,1,1543889345),(18,'模板消息日志',16,'wechat_applet.msg_log','project/database/list?project=wechat_applet&table=msg_log&menu=wechat_applet&search_option_state=1',90,2,'glyphicon glyphicon-folder-close',2,1,1543889345),(19,'发送模板消息',16,'wechat_applet.msg_send','project/database/list?project=wechat_applet&table=msg_send&menu=wechat_applet&search_option_state=1',90,2,'glyphicon glyphicon-folder-close',2,1,1543889345),(20,'统计概览',16,'wechat_applet.total_base','project/database/list?project=wechat_applet&table=total_base&menu=wechat_applet&search_option_state=1',20,2,'glyphicon glyphicon-folder-close',2,1,1543889345);
/*!40000 ALTER TABLE `upload_manage_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_notice`
--

DROP TABLE IF EXISTS `upload_manage_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `name` varchar(32) DEFAULT NULL COMMENT '公告标题',
  `config` int(11) NOT NULL DEFAULT '1' COMMENT '后台配置',
  `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)',
  `content` text COMMENT '内容',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_notice`
--

LOCK TABLES `upload_manage_notice` WRITE;
/*!40000 ALTER TABLE `upload_manage_notice` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_manage_notice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_role`
--

DROP TABLE IF EXISTS `upload_manage_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(24) DEFAULT NULL COMMENT '角色名',
  `role_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级角色',
  `self` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否只能管理自己发布的内容-请在需要此项权限的表中增加[数据查询时影响的字段]',
  `col_select` varchar(30) DEFAULT NULL COMMENT '数据查询时影响的字段-该项影响数据查询，如果在表中增加该字段，则后台在查询数据时自动查询当前管理员的ID下的数据，多个用逗号隔开，与[是否只能管理自己发布的内容]相关',
  `col_insert` varchar(30) DEFAULT NULL COMMENT '数据插入时影响的字段-该项影响数据插入，如果在表中增加该字段，则后台操作时自动为该字段赋值为当前管理员的ID，多个用逗号隔开',
  `col_update` varchar(30) DEFAULT NULL COMMENT '数据更新时影响的字段-该项影响数据更新，如果在表中增加该字段，则后台操作时自动为该字段赋值为当前管理员的ID，多个用逗号隔开',
  `oper` varchar(24) DEFAULT NULL COMMENT '操作权限',
  `auth` text COMMENT '左侧菜单',
  `top` text COMMENT '右侧头部菜单',
  `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序-数值越大越靠前',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_role`
--

LOCK TABLES `upload_manage_role` WRITE;
/*!40000 ALTER TABLE `upload_manage_role` DISABLE KEYS */;
INSERT INTO `upload_manage_role` VALUES (1,'系统管理员',-1,2,'admin','admin','admin','1,2,3,4,5','all',NULL,1,1,1,1543889305),(2,'普通管理员',-1,2,'admin','admin','admin','1,2,3,4,5','',NULL,1,1,1,1543889305);
/*!40000 ALTER TABLE `upload_manage_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_manage_top`
--

DROP TABLE IF EXISTS `upload_manage_top`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_manage_top` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) DEFAULT NULL COMMENT '权限名',
  `top_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级权限',
  `key` varchar(100) DEFAULT NULL COMMENT '权限KEY',
  `value` varchar(30) DEFAULT NULL COMMENT '对应的值',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_manage_top`
--

LOCK TABLES `upload_manage_top` WRITE;
/*!40000 ALTER TABLE `upload_manage_top` DISABLE KEYS */;
INSERT INTO `upload_manage_top` VALUES (1,'微信开发管理-项目选择',-1,'main/project_id','1',1,1543889336),(2,'精美小程序',1,'main/project_id-3_1','1',1,1543889403);
/*!40000 ALTER TABLE `upload_manage_top` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_token_log`
--

DROP TABLE IF EXISTS `upload_token_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_token_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) DEFAULT NULL COMMENT '请求名称',
  `url` varchar(255) DEFAULT NULL COMMENT '请求地址',
  `param` text COMMENT '请求信息',
  `result` longtext COMMENT '微信返回信息',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_token_log`
--

LOCK TABLES `upload_token_log` WRITE;
/*!40000 ALTER TABLE `upload_token_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_token_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_token_project`
--

DROP TABLE IF EXISTS `upload_token_project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_token_project` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(60) DEFAULT NULL COMMENT '项目名称',
  `type` tinyint(11) NOT NULL DEFAULT '1' COMMENT '项目类型',
  `appid` varchar(150) DEFAULT NULL COMMENT '微信APPID',
  `secret` varchar(150) DEFAULT NULL COMMENT '微信SECRET',
  `token` varchar(150) DEFAULT NULL COMMENT '通信TOKEN(注意不是ACCESS_TOKEN)',
  `key` varchar(150) DEFAULT NULL COMMENT '消息加解密密钥',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_token_project`
--

LOCK TABLES `upload_token_project` WRITE;
/*!40000 ALTER TABLE `upload_token_project` DISABLE KEYS */;
INSERT INTO `upload_token_project` VALUES (1,'精美小程序',3,'wxd0590664d0004f23','009bf48ffd5a3ceecb6a933492d641d2','','',1,1543889403);
/*!40000 ALTER TABLE `upload_token_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_wechat_applet_msg`
--

DROP TABLE IF EXISTS `upload_wechat_applet_msg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_wechat_applet_msg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目ID',
  `name` varchar(120) DEFAULT NULL COMMENT '模板标题',
  `key` varchar(20) DEFAULT NULL COMMENT '模板消息KEY-通过KEY值搜索数据',
  `template_id` varchar(120) DEFAULT NULL COMMENT '模板ID',
  `content` varchar(600) DEFAULT NULL COMMENT '模板内容',
  `example` varchar(600) DEFAULT NULL COMMENT '模板样例',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_wechat_applet_msg`
--

LOCK TABLES `upload_wechat_applet_msg` WRITE;
/*!40000 ALTER TABLE `upload_wechat_applet_msg` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_wechat_applet_msg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_wechat_applet_msg_log`
--

DROP TABLE IF EXISTS `upload_wechat_applet_msg_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_wechat_applet_msg_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目',
  `msg_id` int(11) NOT NULL DEFAULT '0' COMMENT '消息ID',
  `touser` varchar(120) DEFAULT NULL COMMENT '接收者',
  `page` varchar(200) DEFAULT NULL COMMENT '跳转页面',
  `data` text COMMENT '模板内容',
  `form_id` varchar(30) DEFAULT NULL COMMENT '表单或者支付ID',
  `emphasis_keyword` varchar(200) DEFAULT NULL COMMENT '模板需要放大的关键词',
  `num` int(11) NOT NULL DEFAULT '0' COMMENT '发送次数',
  `result` text COMMENT '微信返回信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_wechat_applet_msg_log`
--

LOCK TABLES `upload_wechat_applet_msg_log` WRITE;
/*!40000 ALTER TABLE `upload_wechat_applet_msg_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_wechat_applet_msg_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_wechat_applet_msg_send`
--

DROP TABLE IF EXISTS `upload_wechat_applet_msg_send`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_wechat_applet_msg_send` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `project_id` varchar(300) DEFAULT NULL COMMENT '选择项目',
  `key` varchar(20) DEFAULT NULL COMMENT '模板消息KEY',
  `page` varchar(200) DEFAULT NULL COMMENT '页面路径',
  `content` text COMMENT '模板内容',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_wechat_applet_msg_send`
--

LOCK TABLES `upload_wechat_applet_msg_send` WRITE;
/*!40000 ALTER TABLE `upload_wechat_applet_msg_send` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_wechat_applet_msg_send` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_wechat_applet_total_base`
--

DROP TABLE IF EXISTS `upload_wechat_applet_total_base`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_wechat_applet_total_base` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目',
  `day` varchar(60) DEFAULT NULL COMMENT '统计日期',
  `daynum` int(11) NOT NULL DEFAULT '0' COMMENT '统计日期',
  `session_cnt` int(11) NOT NULL DEFAULT '0' COMMENT '打开次数',
  `visit_pv` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数',
  `visit_uv` int(11) NOT NULL DEFAULT '0' COMMENT '访问人数',
  `visit_uv_new` int(11) NOT NULL DEFAULT '0' COMMENT '新用户数',
  `stay_time_uv` varchar(30) DEFAULT NULL COMMENT '人均停留时长',
  `stay_time_session` varchar(30) DEFAULT NULL COMMENT '次均停留时长',
  `visit_depth` varchar(30) DEFAULT NULL COMMENT '平均访问深度',
  `visit_total` int(11) NOT NULL DEFAULT '0' COMMENT '累计用户数',
  `share_pv` int(11) NOT NULL DEFAULT '0' COMMENT '转发次数',
  `share_uv` int(11) NOT NULL DEFAULT '0' COMMENT '转发人数',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_wechat_applet_total_base`
--

LOCK TABLES `upload_wechat_applet_total_base` WRITE;
/*!40000 ALTER TABLE `upload_wechat_applet_total_base` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload_wechat_applet_total_base` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-12-04 10:35:14