-- 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 '图标代码-请点此查看图标代码', `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 */;