wonderful_old/sql/wechat.sql

-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- 主机： rm-2ze2vvl80xp9t9827.mysql.rds.aliyuncs.com
-- 生成日期： 2018-12-04 10:06:44
-- 服务器版本： 5.7.20-log
-- PHP 版本： 7.1.17

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- 数据库： `wechat`
--

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_admin`
--

CREATE TABLE `upload_manage_admin` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_admin`
--

INSERT INTO `upload_manage_admin` (`id`, `username`, `email`, `mobile`, `password`, `config`, `role`, `group`, `top`, `state`, `status`, `cdate`) VALUES
(1, 'admin@admin.com', 'admin@admin.com', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1, '1', 1, NULL, 1, 1, 1543889304);

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_auth`
--

CREATE TABLE `upload_manage_auth` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_config`
--

CREATE TABLE `upload_manage_config` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_config`
--

INSERT INTO `upload_manage_config` (`id`, `name`, `template`, `title`, `info`, `content`, `state`, `cdate`) VALUES
(1, '默认配置', 1, NULL, NULL, NULL, 1, 1543889304);

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_group`
--

CREATE TABLE `upload_manage_group` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_group`
--

INSERT INTO `upload_manage_group` (`id`, `name`, `area`, `state`, `cdate`) VALUES
(1, '默认分组', NULL, 1, 1543889305);

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_log`
--

CREATE TABLE `upload_manage_log` (
  `id` int(11) UNSIGNED NOT NULL 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 '操作时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_log`
--

INSERT INTO `upload_manage_log` (`id`, `project`, `table`, `info`, `admin`, `tid`, `state`, `cdate`) 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);

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_menu`
--

CREATE TABLE `upload_manage_menu` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_menu`
--

INSERT INTO `upload_manage_menu` (`id`, `name`, `menu_id`, `key`, `link`, `reorder`, `type`, `icon`, `fast`, `state`, `cdate`) 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),
(21, '资源库', -1, 'upload', '/share/lib/php/dever_package/upload/:资源库', -90, 2, 'glyphicon glyphicon-upload layui-icon-picture', 2, 2, 1543915662),
(22, '资源分类', 21, 'upload.cate', 'project/database/list?project=upload&table=cate&menu=upload&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1543915662),
(23, '资源列表', 21, 'upload.file', 'project/database/list?project=upload&table=file&menu=upload&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1543915662),
(24, '资源配置', 21, 'upload.upload', 'project/database/list?project=upload&table=upload&menu=upload&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1543915662),
(25, '云端配置', 21, 'upload.yun', 'project/database/list?project=upload&table=yun&menu=upload&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1543915662);

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_notice`
--

CREATE TABLE `upload_manage_notice` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_role`
--

CREATE TABLE `upload_manage_role` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_role`
--

INSERT INTO `upload_manage_role` (`id`, `name`, `role_id`, `self`, `col_select`, `col_insert`, `col_update`, `oper`, `auth`, `top`, `reorder`, `state`, `status`, `cdate`) 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);

-- --------------------------------------------------------

--
-- 表的结构 `upload_manage_top`
--

CREATE TABLE `upload_manage_top` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_manage_top`
--

INSERT INTO `upload_manage_top` (`id`, `name`, `top_id`, `key`, `value`, `state`, `cdate`) VALUES
(1, '微信开发管理-项目选择', -1, 'main/project_id', '1', 1, 1543889336),
(2, '精美小程序', 1, 'main/project_id-3_1', '1', 1, 1543889403);

-- --------------------------------------------------------

--
-- 表的结构 `upload_token_log`
--

CREATE TABLE `upload_token_log` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 表的结构 `upload_token_project`
--

CREATE TABLE `upload_token_project` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转存表中的数据 `upload_token_project`
--

INSERT INTO `upload_token_project` (`id`, `name`, `type`, `appid`, `secret`, `token`, `key`, `state`, `cdate`) VALUES
(1, '精美小程序', 3, 'wxd0590664d0004f23', '009bf48ffd5a3ceecb6a933492d641d2', '', '', 1, 1543889403);

-- --------------------------------------------------------

--
-- 表的结构 `upload_wechat_applet_msg`
--

CREATE TABLE `upload_wechat_applet_msg` (
  `id` int(11) UNSIGNED NOT NULL 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 '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 表的结构 `upload_wechat_applet_msg_log`
--

CREATE TABLE `upload_wechat_applet_msg_log` (
  `id` int(11) UNSIGNED NOT NULL 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 '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 表的结构 `upload_wechat_applet_msg_send`
--

CREATE TABLE `upload_wechat_applet_msg_send` (
  `id` int(11) UNSIGNED NOT NULL 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 '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 表的结构 `upload_wechat_applet_total_base`
--

CREATE TABLE `upload_wechat_applet_total_base` (
  `id` int(11) UNSIGNED NOT NULL 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 '录入时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 转储表的索引
--

--
-- 表的索引 `upload_manage_admin`
--
ALTER TABLE `upload_manage_admin`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_auth`
--
ALTER TABLE `upload_manage_auth`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_config`
--
ALTER TABLE `upload_manage_config`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_group`
--
ALTER TABLE `upload_manage_group`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_log`
--
ALTER TABLE `upload_manage_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_menu`
--
ALTER TABLE `upload_manage_menu`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_notice`
--
ALTER TABLE `upload_manage_notice`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_role`
--
ALTER TABLE `upload_manage_role`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_manage_top`
--
ALTER TABLE `upload_manage_top`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_token_log`
--
ALTER TABLE `upload_token_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_token_project`
--
ALTER TABLE `upload_token_project`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_wechat_applet_msg`
--
ALTER TABLE `upload_wechat_applet_msg`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_wechat_applet_msg_log`
--
ALTER TABLE `upload_wechat_applet_msg_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_wechat_applet_msg_send`
--
ALTER TABLE `upload_wechat_applet_msg_send`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `upload_wechat_applet_total_base`
--
ALTER TABLE `upload_wechat_applet_total_base`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `upload_manage_admin`
--
ALTER TABLE `upload_manage_admin`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `upload_manage_auth`
--
ALTER TABLE `upload_manage_auth`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `upload_manage_config`
--
ALTER TABLE `upload_manage_config`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `upload_manage_group`
--
ALTER TABLE `upload_manage_group`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '组ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `upload_manage_log`
--
ALTER TABLE `upload_manage_log`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `upload_manage_menu`
--
ALTER TABLE `upload_manage_menu`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID', AUTO_INCREMENT=26;

--
-- 使用表AUTO_INCREMENT `upload_manage_notice`
--
ALTER TABLE `upload_manage_notice`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '公告ID';

--
-- 使用表AUTO_INCREMENT `upload_manage_role`
--
ALTER TABLE `upload_manage_role`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `upload_manage_top`
--
ALTER TABLE `upload_manage_top`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `upload_token_log`
--
ALTER TABLE `upload_token_log`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `upload_token_project`
--
ALTER TABLE `upload_token_project`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `upload_wechat_applet_msg`
--
ALTER TABLE `upload_wechat_applet_msg`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `upload_wechat_applet_msg_log`
--
ALTER TABLE `upload_wechat_applet_msg_log`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `upload_wechat_applet_msg_send`
--
ALTER TABLE `upload_wechat_applet_msg_send`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `upload_wechat_applet_total_base`
--
ALTER TABLE `upload_wechat_applet_total_base`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';
COMMIT;

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