/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50643
Source Host           : localhost:3306
Source Database       : tp6cms

Target Server Type    : MYSQL
Target Server Version : 50643
File Encoding         : 65001

Date: 2021-04-25 14:14:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tp_admin
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin`;
CREATE TABLE `tp_admin` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `username` varchar(20) NOT NULL COMMENT '管理员用户名',
  `password` varchar(200) NOT NULL COMMENT '管理员密码',
  `group_id` mediumint(8) DEFAULT NULL COMMENT '分组ID',
  `email` varchar(30) DEFAULT NULL COMMENT '邮箱',
  `realname` varchar(10) DEFAULT NULL COMMENT '真实姓名',
  `mobile` varchar(30) DEFAULT NULL COMMENT '电话号码',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `status` tinyint(2) DEFAULT '1' COMMENT '审核状态',
  `avatar` varchar(120) DEFAULT '' COMMENT '头像',
  `create_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `lastlogintime` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='后台管理员';

-- ----------------------------
-- Records of tp_admin
-- ----------------------------
INSERT INTO `tp_admin` VALUES ('1', 'admin', '$2y$10$.syQPD6H.ZHDivUUohIrcuoC1zNvFALOeJKN7/.cCZitandAJEVmq', '1', 'admin@admin.com', '', '18397423845', '127.0.0.1', '1', '/storage/images/20200904\\9c74e9e2fafaddf558f07871f9ab419c.jpg', '1482132862', '1619331173');
INSERT INTO `tp_admin` VALUES ('3', 'demo', '$2y$10$kOCxm8zyd.hV2DHr1Qz9J.Vihjq8voA.8OxYYPOX0psjO/Q/iu0V2', '3', '994927909@qq.com', '', '18311112222', '127.0.0.1', '1', '/storage/uploads/20190817\\a17c794ac7fae7db012aa6e997cf3400.jpg', '1564041575', '1595315271');
INSERT INTO `tp_admin` VALUES ('4', 'demo1', '$2y$10$l8ZhOo4EFbsbT8Eu66idB.Dkb/G7M4EtZN62TmGzvT0kyvJlib2Ym', '3', '1234@163.com', null, '18377002233', '127.0.0.1', '1', '', '1603336318', '1617692116');
INSERT INTO `tp_admin` VALUES ('7', 'demo02', '$2y$10$SIevylPT05HZOz8l8WLhteNIfKPeAgFg3QbKjxTpVR59Ruo9kbUum', '1', '598556716@qq.com', null, '18300000006', null, '1', '', '1617975157', null);

-- ----------------------------
-- Table structure for tp_attach
-- ----------------------------
DROP TABLE IF EXISTS `tp_attach`;
CREATE TABLE `tp_attach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员id',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户表id',
  `name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `thumb` varchar(255) DEFAULT NULL COMMENT '缩略图',
  `path` varchar(255) DEFAULT NULL COMMENT '路径',
  `url` varchar(255) DEFAULT NULL COMMENT '完整地址',
  `ext` varchar(5) DEFAULT NULL COMMENT '后缀',
  `size` int(11) DEFAULT '0' COMMENT '大小',
  `width` varchar(30) DEFAULT '0' COMMENT '宽度',
  `height` varchar(30) DEFAULT '0' COMMENT '高度',
  `md5` char(32) DEFAULT NULL,
  `mime` varchar(80) DEFAULT NULL,
  `driver` varchar(20) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `sort` int(5) NOT NULL DEFAULT '50',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_attach
-- ----------------------------
INSERT INTO `tp_attach` VALUES ('1', '1', '0', '9c74e9e2fafaddf558f07871f9ab419c.jpg', '/storage/images/20200904/9c74e9e2fafaddf558f07871f9ab419c.jpg', '/storage/images/20200904/9c74e9e2fafaddf558f07871f9ab419c.jpg', 'http://test.tp6.com/storage/images/20200904/9c74e9e2fafaddf558f07871f9ab419c.jpg', 'jpg', '39', '500', '363', '100dee8f2bebe75140222e401b2112b2', 'image/jpeg', 'local', '1599207017', null, '1', '50');
INSERT INTO `tp_attach` VALUES ('2', '1', '0', '9027c99bb8a5822875727758e2b69a15.jpg', '/storage/images/20201022/9027c99bb8a5822875727758e2b69a15.jpg', '/storage/images/20201022/9027c99bb8a5822875727758e2b69a15.jpg', 'http://test.tp6.com/storage/images/20201022/9027c99bb8a5822875727758e2b69a15.jpg', 'jpg', '20', '276', '172', '5a744b8dee3e70f1bebf418ab1ef1839', 'image/jpeg', 'local', '1603336640', null, '1', '50');

-- ----------------------------
-- Table structure for tp_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_group`;
CREATE TABLE `tp_auth_group` (
  `id` smallint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '分组id',
  `title` char(100) NOT NULL DEFAULT '' COMMENT '标题',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态',
  `rules` longtext CHARACTER SET utf8mb4 COMMENT '规则',
  `create_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE,
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='管理员分组';

-- ----------------------------
-- Records of tp_auth_group
-- ----------------------------
INSERT INTO `tp_auth_group` VALUES ('1', '超级管理员', '1', '1,6,7,8,9,2,5,4,3,17,18,19,20,21,22,10,11,12,23,24,13,14,15,16,', '1465114224', '1595314688');
INSERT INTO `tp_auth_group` VALUES ('3', '客服管理员2', '1', '1,6,7,8,9,2,5,4,3,17,18,19,10,11,12,36,13,', '1594885700', '1617694646');

-- ----------------------------
-- Table structure for tp_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_rule`;
CREATE TABLE `tp_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `href` char(80) NOT NULL DEFAULT '' COMMENT '链接',
  `title` char(20) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态1 可以用，0 所有禁止使用',
  `auth_open` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0验证 1不验证',
  `menu_status` tinyint(1) DEFAULT '0' COMMENT '0 不显示，1 显示',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标样式',
  `condition` char(100) DEFAULT '' COMMENT '条件',
  `pid` int(5) NOT NULL DEFAULT '0' COMMENT '父栏目ID',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `href` (`href`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='权限节点';

-- ----------------------------
-- Records of tp_auth_rule
-- ----------------------------
INSERT INTO `tp_auth_rule` VALUES ('1', 'admin/sys', '系统', '1', '1', '0', '1', 'fa fa-home', '', '0', '1', '0', '1594884116');
INSERT INTO `tp_auth_rule` VALUES ('2', 'admin/sys.Auth', ' 权限管理', '1', '1', '0', '1', 'fa fa-cog', '', '1', '2', '0', '1594890878');
INSERT INTO `tp_auth_rule` VALUES ('3', 'admin/sys.AuthRule/index', '权限列表', '1', '1', '0', '1', 'fa fa-cog', '', '2', '3', '0', '1594970515');
INSERT INTO `tp_auth_rule` VALUES ('4', 'admin/sys.AuthGroup/index', '权限组', '1', '1', '0', '1', 'fa fa-cog', '', '2', '2', '0', '1594884192');
INSERT INTO `tp_auth_rule` VALUES ('5', 'admin/sys.Admin/index', '管理员列表', '1', '1', '0', '1', 'fa fa-cog', '', '2', '1', '0', '1594970516');
INSERT INTO `tp_auth_rule` VALUES ('6', 'admin/sys.System', '系统设置', '1', '1', '0', '1', 'fa fa-cogs', '', '1', '1', '0', '1594890802');
INSERT INTO `tp_auth_rule` VALUES ('7', 'admin/sys.System/index', '站点设置', '1', '1', '0', '1', 'fa fa-cogs', '', '6', '1', '0', '1594890830');
INSERT INTO `tp_auth_rule` VALUES ('8', 'admin/sys.SystemLog/index', '日志管理', '1', '1', '0', '1', 'fa fa-cogs', '', '6', '2', '0', '1618198091');
INSERT INTO `tp_auth_rule` VALUES ('9', 'admin/sys.System/configlist', '配置列表', '1', '1', '0', '1', 'fa fa-align-justify', '', '6', '3', '0', '1594891361');
INSERT INTO `tp_auth_rule` VALUES ('10', 'admin/ucenter', '用户', '1', '1', '0', '1', 'fa fa-users', '', '0', '3', '0', '1595208069');
INSERT INTO `tp_auth_rule` VALUES ('11', 'admin/ucenter.User', '用户管理', '1', '1', '0', '1', 'fa fa-adjust', '', '10', '1', '0', '1594971261');
INSERT INTO `tp_auth_rule` VALUES ('12', 'admin/ucenter.User/index', '用户列表', '1', '1', '0', '1', 'fa fa-adjust', '', '11', '1', '0', '1594971281');
INSERT INTO `tp_auth_rule` VALUES ('13', 'admin/ucenter.UserLevel/index', '用户等级', '1', '1', '0', '1', 'fa fa-adjust', '', '11', '2', '0', '1594973946');
INSERT INTO `tp_auth_rule` VALUES ('14', 'admin/wechat', '微信', '1', '1', '0', '1', 'fa fa-wechat', '', '0', '4', '0', '1595208075');
INSERT INTO `tp_auth_rule` VALUES ('15', 'admin/wechat.Wechat', '微信管理', '1', '1', '0', '1', 'fa fa-wechat', '', '14', '1', '0', '1595041034');
INSERT INTO `tp_auth_rule` VALUES ('16', 'admin/wechat.Wechat/config', '微信配置', '1', '1', '0', '1', 'fa fa-cogs', '', '15', '1', '0', '1595041072');
INSERT INTO `tp_auth_rule` VALUES ('17', 'admin/sys.database', '数据库管理', '1', '1', '0', '1', 'fa fa-database', '', '1', '3', '0', '1595051680');
INSERT INTO `tp_auth_rule` VALUES ('18', 'admin/sys.database/index', '数据列表', '1', '1', '0', '1', 'fa fa-adjust', '', '17', '1', '0', '1595051703');
INSERT INTO `tp_auth_rule` VALUES ('19', 'admin/sys.database/restore', ' 备份列表', '1', '1', '0', '1', 'fa fa-adjust', '', '17', '2', '0', '1595051743');
INSERT INTO `tp_auth_rule` VALUES ('20', 'admin/cms', '内容', '1', '1', '0', '1', 'fa fa-life-bouy', '', '0', '2', '0', '1595208052');
INSERT INTO `tp_auth_rule` VALUES ('21', 'admin/cms.cms', '内容管理', '1', '1', '0', '1', 'fa fa-adjust', '', '20', '1', '0', '1595293193');
INSERT INTO `tp_auth_rule` VALUES ('23', 'admin/ucenter.User/add', '操作-添加', '1', '1', '0', '1', 'fa fa-adjust', '', '12', '2', '0', '1617694600');
INSERT INTO `tp_auth_rule` VALUES ('24', 'admin/ucenter.User/del', '操作-删除', '1', '1', '0', '1', 'fa fa-adjust', '', '12', '2', '0', '1595314611');
INSERT INTO `tp_auth_rule` VALUES ('25', 'admin/cms.category/index', '栏目管理', '1', '1', '0', '1', 'fa fa-adjust', '', '21', '1', '0', '1618280250');
INSERT INTO `tp_auth_rule` VALUES ('26', 'admin/cms.article/index', '文章管理', '1', '1', '0', '1', 'fa fa-adjust', '', '21', '2', '0', '1618280602');
INSERT INTO `tp_auth_rule` VALUES ('27', 'admin/cms.cms/Function', '网站功能', '1', '1', '0', '1', 'fa fa-adjust', '', '20', '2', '0', '1595984002');
INSERT INTO `tp_auth_rule` VALUES ('28', 'admin/cms.Block/index', '区块管理', '1', '1', '0', '1', 'fa fa-adjust', '', '27', '1', '0', '1595984063');
INSERT INTO `tp_auth_rule` VALUES ('29', 'admin/wechat.Wxmenu/index', '微信菜单', '1', '1', '0', '1', 'fa fa-adjust', '', '15', '2', '0', '1595988274');
INSERT INTO `tp_auth_rule` VALUES ('30', 'admin/wechat.Wxfans/index', '微信粉丝', '1', '1', '0', '1', 'fa fa-adjust', '', '15', '3', '0', '1596530665');
INSERT INTO `tp_auth_rule` VALUES ('31', 'admin/wechat.Wxmaterial/index', '图文管理', '1', '1', '0', '1', 'fa fa-adjust', '', '15', '4', '0', '1596688299');
INSERT INTO `tp_auth_rule` VALUES ('32', 'admin/wechat.keys/index', '回复规则管理', '1', '1', '0', '1', 'fa fa-adjust', '', '15', '5', '0', '1597739348');
INSERT INTO `tp_auth_rule` VALUES ('33', 'admin/sys.Attach', '附件管理', '1', '1', '0', '1', 'fa fa-adjust', '', '1', '4', '0', '1599205615');
INSERT INTO `tp_auth_rule` VALUES ('34', 'admin/sys.Attach/index', '附件列表', '1', '1', '0', '1', 'fa fa-adjust', '', '33', '1', '0', '1599205661');
INSERT INTO `tp_auth_rule` VALUES ('35', 'admin/ucenter.Member/index', '微信用户', '1', '1', '0', '1', 'fa fa-adjust', '', '11', '3', '0', '1616463923');
INSERT INTO `tp_auth_rule` VALUES ('36', 'admin/ucenter.User/index', '操作-查看', '1', '1', '0', '1', 'fa fa-adjust', '', '12', '1', '0', '1617694588');
INSERT INTO `tp_auth_rule` VALUES ('37', 'admin/tools', '工具', '1', '1', '0', '1', 'fa fa-legal', '', '0', '5', '0', '1617940471');
INSERT INTO `tp_auth_rule` VALUES ('38', 'admin/tools.Develop', '开发管理', '1', '1', '0', '1', 'fa fa-adjust', '', '37', '1', '0', '1617940509');
INSERT INTO `tp_auth_rule` VALUES ('39', 'admin/tools.Develop/build', '创控制器', '1', '1', '0', '1', 'fa fa-adjust', '', '38', '1', '0', '1617977584');

-- ----------------------------
-- Table structure for tp_category
-- ----------------------------
DROP TABLE IF EXISTS `tp_category`;
CREATE TABLE `tp_category` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `catdir` varchar(30) NOT NULL DEFAULT '',
  `parentdir` varchar(50) NOT NULL DEFAULT '',
  `pid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `arrparentid` varchar(255) NOT NULL DEFAULT '',
  `arrchildid` varchar(100) NOT NULL DEFAULT '',
  `seo_title` varchar(150) NOT NULL DEFAULT '',
  `seo_keywords` varchar(200) NOT NULL DEFAULT '',
  `seo_desc` varchar(255) NOT NULL DEFAULT '',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0',
  `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `image` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  `pagesize` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parentid` (`pid`),
  KEY `listorder` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_category
-- ----------------------------
INSERT INTO `tp_category` VALUES ('1', '新闻', 'news', '', '0', '0', '1', '', '', '', '0', '1', '0', '', '', '20');
INSERT INTO `tp_category` VALUES ('2', '公司新闻', 'gsss', '', '1', '0', '2', '', '', '', '0', '1', '0', '', '', '20');
INSERT INTO `tp_category` VALUES ('3', '行业动态', 'dt', '', '0', '0', '3', '', '', '', '0', '0', '0', '', '', '20');

-- ----------------------------
-- Table structure for tp_cms_article
-- ----------------------------
DROP TABLE IF EXISTS `tp_cms_article`;
CREATE TABLE `tp_cms_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `title` varchar(80) NOT NULL DEFAULT '' COMMENT '文章标题',
  `style` varchar(100) DEFAULT '' COMMENT '样式',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图',
  `images` varchar(1500) NOT NULL DEFAULT '' COMMENT '组图',
  `seotitle` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO标题',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `content` text,
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 0禁用  1启用',
  PRIMARY KEY (`id`),
  KEY `status` (`catid`,`status`),
  KEY `channel` (`catid`,`sort`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='内容表';

-- ----------------------------
-- Records of tp_cms_article
-- ----------------------------
INSERT INTO `tp_cms_article` VALUES ('6', '2', '的撒大大是', '', '', '', '', '', '', '<p>的撒旦撒旦</p>', '0', '0', '1618286082', '1618286082', '0');

-- ----------------------------
-- Table structure for tp_cms_block
-- ----------------------------
DROP TABLE IF EXISTS `tp_cms_block`;
CREATE TABLE `tp_cms_block` (
  `id` smallint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '图片',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
  `content` mediumtext COMMENT '内容',
  `sort` int(10) DEFAULT '0' COMMENT '权重',
  `create_time` int(10) DEFAULT NULL COMMENT '添加时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `status` enum('normal','hidden') NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='区块表';

-- ----------------------------
-- Records of tp_cms_block
-- ----------------------------
INSERT INTO `tp_cms_block` VALUES ('2', 'index_banner', '首页广告', '/storage/images/20200729/4a71597f731dc691aff2f3384d69b010.png', 'http://www.baidu.com', '', '0', '1595987059', '1595987059', 'normal');
INSERT INTO `tp_cms_block` VALUES ('3', 'index_banner', '首页广告1', '/storage/images/20200729/4a71597f731dc691aff2f3384d69b010.png', 'http://www.baidu.com', '', '0', '1595987329', '1595987329', 'normal');
INSERT INTO `tp_cms_block` VALUES ('4', 'index_banner2', '首页中部广告', '/storage/images/20201022/9027c99bb8a5822875727758e2b69a15.jpg', '', '<div><p>友情链接</p></div>', '45', '1595987523', '1617978342', 'normal');

-- ----------------------------
-- Table structure for tp_config
-- ----------------------------
DROP TABLE IF EXISTS `tp_config`;
CREATE TABLE `tp_config` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `value` text,
  `group` varchar(100) DEFAULT NULL COMMENT 'basic email  user',
  `tip` varchar(100) DEFAULT NULL COMMENT '参数描述',
  `type` varchar(50) DEFAULT NULL COMMENT 'string text file',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_config
-- ----------------------------
INSERT INTO `tp_config` VALUES ('1', 'site_title', '站点名称', '后台管理系统', 'basic', '', 'string');
INSERT INTO `tp_config` VALUES ('2', 'sub_title', '副标题', '', 'basic', '', 'string');
INSERT INTO `tp_config` VALUES ('3', 'site_domain', '站点地址', 'http://test.tp6.com/', 'basic', '', 'string');
INSERT INTO `tp_config` VALUES ('4', 'site_logo', '站点LOGO', '/storage/images/20201022/9027c99bb8a5822875727758e2b69a15.jpg', 'basic', '', 'file');
INSERT INTO `tp_config` VALUES ('5', 'site_keyword', '站点关键字', '', 'basic', '', 'text');
INSERT INTO `tp_config` VALUES ('6', 'site_desc', '站点描述', '', 'basic', '', 'text');
INSERT INTO `tp_config` VALUES ('7', 'smtp', '服务器', '163', 'email', '', 'string');
INSERT INTO `tp_config` VALUES ('8', 'is_open', '开放注册', 'open', 'user', '', 'radio');
INSERT INTO `tp_config` VALUES ('10', 'smtp_user', '发件人', 'qinqijing888@163.com', 'email', '发件人', 'string');
INSERT INTO `tp_config` VALUES ('16', 'file_size', '文件大小', '5242880', 'uploads', '5M  单位：字节', 'string');
INSERT INTO `tp_config` VALUES ('17', 'file_pic_ext', '图片后缀', 'jpg,png,gif,jpeg', 'uploads', '允许上传的图片后缀名', 'string');
INSERT INTO `tp_config` VALUES ('18', 'file_file_ext', '文件后缀', 'txt,doc,docx,xls,xlsx,pdf', 'uploads', '允许上传的文件后缀', 'string');

-- ----------------------------
-- Table structure for tp_member
-- ----------------------------
DROP TABLE IF EXISTS `tp_member`;
CREATE TABLE `tp_member` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `wxopenid` varchar(200) NOT NULL DEFAULT '0' COMMENT '微信openid',
  `username` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
  `avatar` varchar(255) DEFAULT NULL,
  `nickname` varchar(100) DEFAULT NULL COMMENT '昵称',
  `realname` varchar(100) DEFAULT NULL COMMENT '真实姓名',
  `phone` char(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `province` varchar(100) NOT NULL DEFAULT '' COMMENT '省份',
  `sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别  0保密 1男2女',
  `city` varchar(100) NOT NULL DEFAULT '' COMMENT '城市',
  `area` varchar(100) NOT NULL DEFAULT '' COMMENT '区域',
  `address` tinytext NOT NULL COMMENT '详细地址',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `wx_appid` varchar(100) DEFAULT NULL COMMENT '微信APPID',
  `wx_unionid` varchar(100) DEFAULT NULL COMMENT '微信开放平台ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_member
-- ----------------------------

-- ----------------------------
-- Table structure for tp_system_log
-- ----------------------------
DROP TABLE IF EXISTS `tp_system_log`;
CREATE TABLE `tp_system_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host` char(200) NOT NULL DEFAULT '',
  `uri` char(200) NOT NULL DEFAULT '',
  `ip` char(50) NOT NULL DEFAULT '',
  `app` char(30) NOT NULL DEFAULT '',
  `method` char(50) NOT NULL DEFAULT '',
  `sql_list` text,
  `create_time` int(11) NOT NULL DEFAULT '0',
  `runtime` decimal(10,3) unsigned NOT NULL DEFAULT '0.000',
  `param` text,
  PRIMARY KEY (`id`),
  KEY `rumtime` (`runtime`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tp_system_log
-- ----------------------------

-- ----------------------------
-- Table structure for tp_user
-- ----------------------------
DROP TABLE IF EXISTS `tp_user`;
CREATE TABLE `tp_user` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '邮件',
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
  `paypwd` varchar(32) DEFAULT NULL COMMENT '支付密码',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 保密 1 男 2 女',
  `birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日',
  `user_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '用户金额',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `update_time` int(11) DEFAULT NULL,
  `last_login` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `login_num` int(11) DEFAULT '0' COMMENT '登录次数',
  `last_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码',
  `oauth` varchar(10) DEFAULT '' COMMENT '第三方来源 wx weibo alipay qq',
  `openid` varchar(100) DEFAULT NULL COMMENT '第三方唯一标示',
  `wx_appid` varchar(100) DEFAULT NULL,
  `unionid` varchar(100) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `province` int(6) DEFAULT '0' COMMENT '省份',
  `city` int(6) DEFAULT '0' COMMENT '市区',
  `district` int(6) DEFAULT '0' COMMENT '县',
  `nickname` varchar(50) DEFAULT NULL COMMENT '第三方返回昵称',
  `level_id` tinyint(1) DEFAULT '1' COMMENT '会员等级',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否被锁定冻结 0 冻结，1 正常',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`,`email`,`mobile`) USING BTREE,
  KEY `email` (`email`),
  KEY `openid` (`openid`),
  KEY `unionid` (`unionid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of tp_user
-- ----------------------------
INSERT INTO `tp_user` VALUES ('24', '', 'admin', 'e10adc3949ba59abbe56e057f20f883e', null, '1', '0', '0.00', '1617777007', '1617777007', '0', '0', '', '', '', null, null, null, '', '0', '0', '0', null, '1', '1');

-- ----------------------------
-- Table structure for tp_user_level
-- ----------------------------
DROP TABLE IF EXISTS `tp_user_level`;
CREATE TABLE `tp_user_level` (
  `id` smallint(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `level_name` varchar(30) DEFAULT NULL COMMENT '头衔名称',
  `status` tinyint(1) DEFAULT '1',
  `sort` int(5) DEFAULT '0',
  `description` varchar(200) DEFAULT NULL COMMENT '等级 描述',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='用户等级表';

-- ----------------------------
-- Records of tp_user_level
-- ----------------------------
INSERT INTO `tp_user_level` VALUES ('1', '倔强青铜', '1', '0', '人生若只如初相见', '0', '1576155565');
INSERT INTO `tp_user_level` VALUES ('2', '秩序白银', '1', '0', '', '0', '1575531170');
INSERT INTO `tp_user_level` VALUES ('5', '永恒钻石', '1', '0', '', '0', '1576723983');
INSERT INTO `tp_user_level` VALUES ('7', '最强王者', '1', '0', '123', '0', '1617958151');

-- ----------------------------
-- Table structure for tp_wx_config
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_config`;
CREATE TABLE `tp_wx_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) NOT NULL COMMENT '公众号名称',
  `domain` varchar(255) NOT NULL DEFAULT '' COMMENT '域名',
  `appid` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值json',
  `appsecret` varchar(255) NOT NULL DEFAULT '',
  `returnurl` varchar(255) NOT NULL,
  `token` varchar(100) NOT NULL DEFAULT '',
  `aeskey` varchar(100) DEFAULT NULL,
  `mchid` varchar(64) DEFAULT NULL COMMENT '商户ID',
  `paykey` varchar(32) DEFAULT NULL COMMENT '支付密钥',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用 1启用 0不启用',
  `createtime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(11) DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=963 COMMENT='微信配置表';

-- ----------------------------
-- Records of tp_wx_config
-- ----------------------------
INSERT INTO `tp_wx_config` VALUES ('1', '测试公众号', 'http://api.data.mmetp.top', 'wx76c78a5a996b5ff9', '3bb0b8529484437ef53ee67c49111aa4', 'http://test.tp6.com/wchat/wchat/relateWeixin', 'thinkphp6', '3bb0b8529484437ef53ee67c49111aa4', '5555', '6666', '1', '1595043862', '1595043862');

-- ----------------------------
-- Table structure for tp_wx_keys
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_keys`;
CREATE TABLE `tp_wx_keys` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `wx_id` char(100) DEFAULT '' COMMENT '公众号ID',
  `msgtype` varchar(20) DEFAULT '' COMMENT '类型(text,image,news)',
  `keys` varchar(100) DEFAULT NULL COMMENT '关键字',
  `content` text COMMENT '文本内容',
  `image_url` varchar(255) DEFAULT '' COMMENT '图片链接',
  `voice_url` varchar(255) DEFAULT '' COMMENT '语音链接',
  `music_title` varchar(100) DEFAULT '' COMMENT '音乐标题',
  `music_url` varchar(255) DEFAULT '' COMMENT '音乐链接',
  `music_image` varchar(255) DEFAULT '' COMMENT '缩略图片',
  `music_desc` varchar(255) DEFAULT '' COMMENT '音乐描述',
  `video_title` varchar(100) DEFAULT '' COMMENT '视频标题',
  `video_url` varchar(255) DEFAULT '' COMMENT '视频URL',
  `video_desc` varchar(255) DEFAULT '' COMMENT '视频描述',
  `news_id` bigint(20) unsigned DEFAULT NULL COMMENT '图文ID',
  `customservice` text,
  `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序字段',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(0禁用,1启用)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_wechat_keys_appid` (`wx_id`) USING BTREE,
  KEY `index_wechat_keys_type` (`msgtype`) USING BTREE,
  KEY `index_wechat_keys_keys` (`keys`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='微信-关键字';

-- ----------------------------
-- Records of tp_wx_keys
-- ----------------------------
INSERT INTO `tp_wx_keys` VALUES ('2', '1', 'text', 'bb', '说点什么吧', '', '', '音乐标题', '', 'http://test.tp6.com/static/admin/images/image.png', '', '视频标题', '', '', '3', null, '0', '1', '2020-09-04 11:43:24');
INSERT INTO `tp_wx_keys` VALUES ('3', '1', 'image', 'ccc', 'cccc', '/storage/images/20200904\\9c74e9e2fafaddf558f07871f9ab419c.jpg', '', '音乐标题', '', 'http://test.tp6.com/static/admin/images/image.png', '', '视频标题', '', '', '1', '', '0', '1', '2020-09-04 16:49:11');

-- ----------------------------
-- Table structure for tp_wx_media
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_media`;
CREATE TABLE `tp_wx_media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `appid` varchar(100) DEFAULT '' COMMENT '公众号ID',
  `md5` varchar(32) DEFAULT '' COMMENT '文件md5',
  `type` varchar(20) DEFAULT '' COMMENT '媒体类型',
  `media_id` varchar(100) DEFAULT '' COMMENT '永久素材MediaID',
  `local_url` varchar(300) DEFAULT '' COMMENT '本地文件链接',
  `media_url` varchar(300) DEFAULT '' COMMENT '远程图片链接',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_wechat_media_appid` (`appid`) USING BTREE,
  KEY `index_wechat_media_md5` (`md5`) USING BTREE,
  KEY `index_wechat_media_type` (`type`) USING BTREE,
  KEY `index_wechat_media_media_id` (`media_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信-素材';

-- ----------------------------
-- Records of tp_wx_media
-- ----------------------------

-- ----------------------------
-- Table structure for tp_wx_menu
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_menu`;
CREATE TABLE `tp_wx_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `wx_id` int(11) NOT NULL DEFAULT '0' COMMENT '公众号ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父菜单',
  `menu_event` enum('click','view','miniprogram') NOT NULL,
  `keys_id` int(11) NOT NULL DEFAULT '0',
  `media_id` int(11) NOT NULL DEFAULT '0' COMMENT '图文消息ID',
  `menu_event_url` varchar(255) NOT NULL DEFAULT '' COMMENT '菜单url',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `createtime` int(11) DEFAULT '0' COMMENT '创建日期',
  `updatetime` int(11) DEFAULT '0' COMMENT '修改日期',
  PRIMARY KEY (`id`),
  KEY `IDX_biz_shop_menu_orders` (`sort`),
  KEY `IDX_biz_shop_menu_shopId` (`wx_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=1638 COMMENT='微信菜单';

-- ----------------------------
-- Records of tp_wx_menu
-- ----------------------------
INSERT INTO `tp_wx_menu` VALUES ('1', '1', '首页', '0', 'click', '3', '0', '', '0', '1596532733', '1599210428');
INSERT INTO `tp_wx_menu` VALUES ('2', '1', '二级菜单', '1', 'view', '0', '0', 'http://api.data.mmetp.top/', '0', '1596533484', '1599186801');
INSERT INTO `tp_wx_menu` VALUES ('3', '1', '内页', '0', 'click', '3', '0', 'http://api.data.mmetp.top/', '0', '1596589592', '1603160860');

-- ----------------------------
-- Table structure for tp_wx_news
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_news`;
CREATE TABLE `tp_wx_news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wx_id` int(8) DEFAULT NULL,
  `article_id` varchar(60) DEFAULT '' COMMENT '素材标题',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='微信-文章';

-- ----------------------------
-- Records of tp_wx_news
-- ----------------------------
INSERT INTO `tp_wx_news` VALUES ('1', '1', '7,', '2020-08-18 16:11:43');
INSERT INTO `tp_wx_news` VALUES ('3', '1', '9,', '2020-08-18 16:14:32');

-- ----------------------------
-- Table structure for tp_wx_news_article
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_news_article`;
CREATE TABLE `tp_wx_news_article` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wx_id` int(8) DEFAULT NULL,
  `title` varchar(50) DEFAULT '' COMMENT '素材标题',
  `image` varchar(300) DEFAULT '' COMMENT '永久素材显示URL',
  `show_cover_pic` tinyint(4) unsigned DEFAULT '0' COMMENT '显示封面(0不显示,1显示)',
  `author` varchar(20) DEFAULT '' COMMENT '文章作者',
  `description` varchar(300) DEFAULT '' COMMENT '摘要内容',
  `content` longtext COMMENT '图文内容',
  `content_source_url` varchar(200) DEFAULT '' COMMENT '原文地址',
  `read_num` bigint(20) unsigned DEFAULT '0' COMMENT '阅读数量',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='微信-文章';

-- ----------------------------
-- Records of tp_wx_news_article
-- ----------------------------
INSERT INTO `tp_wx_news_article` VALUES ('7', '1', '新建图文1', '/static/admin/images/image.png', '0', '管理员', '', '', '', '0', '2020-08-18 16:03:56');
INSERT INTO `tp_wx_news_article` VALUES ('9', '1', '系统设置', '/static/admin/images/image.png', '0', '管理员', '', '', '', '0', '2020-08-18 16:14:32');