/*
Navicat MySQL Data Transfer

Source Server         : 本地数据库
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : tp6rc4

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

Date: 2019-08-27 15:57:20
*/

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(70) 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地址',
  `mdemail` varchar(50) DEFAULT '0' COMMENT '传递修改密码参数加密',
  `status` tinyint(2) DEFAULT '1' COMMENT '审核状态',
  `avatar` varchar(120) DEFAULT '' COMMENT '头像',
  `create_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='后台管理员';

-- ----------------------------
-- Records of tp_admin
-- ----------------------------
INSERT INTO `tp_admin` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '1', '994927909@qq.com', '', '18397423845', '127.0.0.1', '0', '1', '/storage/uploads/20190817\\294faa45405fa24da59c311f55ce313f.png', '1482132862', '1566111856');
INSERT INTO `tp_admin` VALUES ('2', 'yuege', 'e10adc3949ba59abbe56e057f20f883e', '2', '994927909@qq.com', '', '18397423845', '127.0.0.1', '0', '1', '/storage/uploads/20190817\\dc25c2714c46a0d2bee894a7d05eb15f.png', '1535512393', '1566030896');
INSERT INTO `tp_admin` VALUES ('3', 'dandan', '69d9387a9f1e957872943a2b957e4947', '2', '994927909@qq.com', null, '18397423845', '119.122.91.146', '0', '1', '/storage/uploads/20190817\\a17c794ac7fae7db012aa6e997cf3400.jpg', '1564041575', '1566001700');
INSERT INTO `tp_admin` VALUES ('4', 'admin1', 'e10adc3949ba59abbe56e057f20f883e', '1', '994927909@qq.com', null, '18397423845', '119.122.91.146', '0', '1', '/storage/uploads/20190816\\824fbacce27ce094eb3b1e115dfdb709.png', '1565941890', '1565942219');
INSERT INTO `tp_admin` VALUES ('5', 'admin2', 'e10adc3949ba59abbe56e057f20f883e', '2', '994927909@qq.com', null, '18397423845', '119.122.91.146', '0', '1', '/storage/uploads/20190816\\97255951134abef478f1af5a83b40523.jpg', '1565942044', '1565942280');
INSERT INTO `tp_admin` VALUES ('6', 'admin3', 'e10adc3949ba59abbe56e057f20f883e', '2', '994927909@qq.com', null, '18397423845', '119.122.91.146', '0', '1', '/storage/uploads/20190816\\97255951134abef478f1af5a83b40523.jpg', '1565942140', '1565942281');

-- ----------------------------
-- Table structure for tp_admin_entrance
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_entrance`;
CREATE TABLE `tp_admin_entrance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '管理员的id',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '快速入口名称',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转链接',
  `ico` varchar(255) DEFAULT 'fa fa-gears' COMMENT '图标',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '位置',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用',
  `create_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '修改时间',
  `delete_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='后台快速入口';

-- ----------------------------
-- Records of tp_admin_entrance
-- ----------------------------
INSERT INTO `tp_admin_entrance` VALUES ('1', '1', '系统设置', '', 'fa fa-gears', '100', '1', '1566887341', '1566887341', '0');

-- ----------------------------
-- Table structure for tp_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_log`;
CREATE TABLE `tp_admin_log` (
  `id` bigint(16) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `admin_id` int(10) DEFAULT NULL COMMENT '管理员id',
  `username` varchar(100) DEFAULT NULL,
  `log_url` varchar(100) DEFAULT NULL,
  `log_content` varchar(255) DEFAULT NULL,
  `log_title` varchar(100) DEFAULT NULL COMMENT '日志描述',
  `log_agent` varchar(100) DEFAULT NULL,
  `log_ip` varchar(30) DEFAULT NULL COMMENT 'ip地址',
  `create_time` int(11) DEFAULT NULL COMMENT '日志时间',
  `update_time` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE,
  KEY `admin_id` (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tp_admin_log
-- ----------------------------
INSERT INTO `tp_admin_log` VALUES ('4', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"Uqchd\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566809534', '1566809534', '1');
INSERT INTO `tp_admin_log` VALUES ('5', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"wb5bu\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566809606', '1566809606', '1');
INSERT INTO `tp_admin_log` VALUES ('6', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"xxn2v\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566809657', '1566809657', '1');
INSERT INTO `tp_admin_log` VALUES ('7', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"5jnuq\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566809792', '1566809792', '1');
INSERT INTO `tp_admin_log` VALUES ('8', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"tnavp\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566809808', '1566809808', '1');
INSERT INTO `tp_admin_log` VALUES ('9', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"uinpn\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566810046', '1566810046', '1');
INSERT INTO `tp_admin_log` VALUES ('10', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"qnndv\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566810070', '1566810070', '1');
INSERT INTO `tp_admin_log` VALUES ('11', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"Ane44\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566810128', '1566810128', '1');
INSERT INTO `tp_admin_log` VALUES ('12', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html?username=admin&password=123456&captcha=xszg&re', '{\"username\":\"admin\",\"captcha\":\"mct6x\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566810150', '1566810150', '1');
INSERT INTO `tp_admin_log` VALUES ('13', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html', '{\"username\":\"admin\",\"captcha\":\"1wj71\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566810644', '1566810644', '1');
INSERT INTO `tp_admin_log` VALUES ('14', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html', '{\"username\":\"admin\",\"captcha\":\"btxwv\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566810654', '1566810654', '1');
INSERT INTO `tp_admin_log` VALUES ('15', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html', '{\"username\":\"admin\",\"captcha\":\"hz4vp\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868440', '1566868440', '1');
INSERT INTO `tp_admin_log` VALUES ('16', '0', 'Unknown', '/demo/tp6/tp6/public/index.php/admin/login/index.html', '{\"username\":\"admin\",\"captcha\":\"jvv4b\",\"rememberMe\":\"true\"}', '[登录成功]', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868459', '1566868459', '1');
INSERT INTO `tp_admin_log` VALUES ('17', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868768', '1566868768', '1');
INSERT INTO `tp_admin_log` VALUES ('18', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868795', '1566868795', '1');
INSERT INTO `tp_admin_log` VALUES ('19', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868811', '1566868811', '1');
INSERT INTO `tp_admin_log` VALUES ('20', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/restore.html', null, '还原数据库', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868983', '1566868983', '1');
INSERT INTO `tp_admin_log` VALUES ('21', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/index.html', null, '数据库列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566868998', '1566868998', '1');
INSERT INTO `tp_admin_log` VALUES ('22', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adminlog/index.html', null, '日志管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869011', '1566869011', '1');
INSERT INTO `tp_admin_log` VALUES ('23', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869027', '1566869027', '1');
INSERT INTO `tp_admin_log` VALUES ('24', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/addons/index.html', null, '插件列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869031', '1566869031', '1');
INSERT INTO `tp_admin_log` VALUES ('25', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/index.html', null, '广告列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869035', '1566869035', '1');
INSERT INTO `tp_admin_log` VALUES ('26', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/pos.html', null, '广告位置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869043', '1566869043', '1');
INSERT INTO `tp_admin_log` VALUES ('27', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adminlog/index.html', null, '日志管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869188', '1566869188', '1');
INSERT INTO `tp_admin_log` VALUES ('28', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869191', '1566869191', '1');
INSERT INTO `tp_admin_log` VALUES ('29', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/restore.html', null, '还原数据库', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869197', '1566869197', '1');
INSERT INTO `tp_admin_log` VALUES ('30', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/index.html', null, '数据库列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869368', '1566869368', '1');
INSERT INTO `tp_admin_log` VALUES ('31', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/restore.html', null, '还原数据库', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869386', '1566869386', '1');
INSERT INTO `tp_admin_log` VALUES ('32', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869396', '1566869396', '1');
INSERT INTO `tp_admin_log` VALUES ('33', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869406', '1566869406', '1');
INSERT INTO `tp_admin_log` VALUES ('34', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869416', '1566869416', '1');
INSERT INTO `tp_admin_log` VALUES ('35', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869430', '1566869430', '1');
INSERT INTO `tp_admin_log` VALUES ('36', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/index.html', null, '广告列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869465', '1566869465', '1');
INSERT INTO `tp_admin_log` VALUES ('37', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/pos.html', null, '广告位置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869469', '1566869469', '1');
INSERT INTO `tp_admin_log` VALUES ('38', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/link/index.html', null, '链接列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869473', '1566869473', '1');
INSERT INTO `tp_admin_log` VALUES ('39', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869516', '1566869516', '1');
INSERT INTO `tp_admin_log` VALUES ('40', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/addons/index.html', null, '插件列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869532', '1566869532', '1');
INSERT INTO `tp_admin_log` VALUES ('41', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869546', '1566869546', '1');
INSERT INTO `tp_admin_log` VALUES ('42', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/uploads/uploads.html', null, '上传文件', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869565', '1566869565', '1');
INSERT INTO `tp_admin_log` VALUES ('43', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', '{\"site_name\":\"lemocm\",\"site_domain\":\"https:\\/\\/www.lemocms.com\",\"site_email\":\"858761000@qq.com\",\"site_logo\":\"\\/storage\\/uploads\\/20190827\\\\54b354585790d767124703c16d768d74.png\",\"file\":\"\",\"site_seo_title\":\"\\u65e0\\u6240\\u4e0d\\u80fd\\u7684thinkphp\\u6846\\u67b6', '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869660', '1566869660', '1');
INSERT INTO `tp_admin_log` VALUES ('44', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869661', '1566869661', '1');
INSERT INTO `tp_admin_log` VALUES ('45', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', '{\"site_name\":\"layui\\u7f51\\u7ad9demo\",\"site_domain\":\"#\",\"site_email\":\"584887013@qq.com\",\"site_logo\":\"\\/storage\\/uploads\\/20190827\\\\54b354585790d767124703c16d768d74.png\",\"file\":\"\",\"site_seo_title\":\"\\u65e0\\u6240\\u4e0d\\u80fd\\u7684thinkphp\\u6846\\u67b6,\\u4e5f\\u', '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869761', '1566869761', '1');
INSERT INTO `tp_admin_log` VALUES ('46', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566869763', '1566869763', '1');
INSERT INTO `tp_admin_log` VALUES ('47', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870170', '1566870170', '1');
INSERT INTO `tp_admin_log` VALUES ('48', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adminlog/index.html', null, '日志管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870314', '1566870314', '1');
INSERT INTO `tp_admin_log` VALUES ('49', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870317', '1566870317', '1');
INSERT INTO `tp_admin_log` VALUES ('50', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/uploads/uploads.html', null, '上传文件', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870368', '1566870368', '1');
INSERT INTO `tp_admin_log` VALUES ('51', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', '{\"site_name\":\"layui\\u7f51\\u7ad9demo\",\"site_domain\":\"#\",\"site_email\":\"584887013@qq.com\",\"site_logo\":\"\\/storage\\/uploads\\/20190827\\\\ce6c09b750dec6883425e71b7810b7b5.png\",\"file\":\"\",\"site_seo_title\":\"\\u65e0\\u6240\\u4e0d\\u80fd\\u7684thinkphp\\u6846\\u67b6,\\u4e5f\\u', '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870376', '1566870376', '1');
INSERT INTO `tp_admin_log` VALUES ('52', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870377', '1566870377', '1');
INSERT INTO `tp_admin_log` VALUES ('53', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870445', '1566870445', '1');
INSERT INTO `tp_admin_log` VALUES ('54', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870493', '1566870493', '1');
INSERT INTO `tp_admin_log` VALUES ('55', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870498', '1566870498', '1');
INSERT INTO `tp_admin_log` VALUES ('56', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adminlog/index.html', null, '日志管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870570', '1566870570', '1');
INSERT INTO `tp_admin_log` VALUES ('57', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adminlog/index.html', null, '日志管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566870810', '1566870810', '1');
INSERT INTO `tp_admin_log` VALUES ('58', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/restore.html', null, '还原数据库', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566871550', '1566871550', '1');
INSERT INTO `tp_admin_log` VALUES ('59', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/database/index.html', null, '数据库列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566871552', '1566871552', '1');
INSERT INTO `tp_admin_log` VALUES ('60', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566871560', '1566871560', '1');
INSERT INTO `tp_admin_log` VALUES ('61', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566871564', '1566871564', '1');
INSERT INTO `tp_admin_log` VALUES ('62', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566871566', '1566871566', '1');
INSERT INTO `tp_admin_log` VALUES ('63', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872017', '1566872017', '1');
INSERT INTO `tp_admin_log` VALUES ('64', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872019', '1566872019', '1');
INSERT INTO `tp_admin_log` VALUES ('65', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872020', '1566872020', '1');
INSERT INTO `tp_admin_log` VALUES ('66', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872021', '1566872021', '1');
INSERT INTO `tp_admin_log` VALUES ('67', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872135', '1566872135', '1');
INSERT INTO `tp_admin_log` VALUES ('68', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872137', '1566872137', '1');
INSERT INTO `tp_admin_log` VALUES ('69', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/addons/index.html', null, '插件列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872180', '1566872180', '1');
INSERT INTO `tp_admin_log` VALUES ('70', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/index.html', null, '广告列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872183', '1566872183', '1');
INSERT INTO `tp_admin_log` VALUES ('71', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/pos.html', null, '广告位置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872185', '1566872185', '1');
INSERT INTO `tp_admin_log` VALUES ('72', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/link/index.html', null, '链接列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872206', '1566872206', '1');
INSERT INTO `tp_admin_log` VALUES ('73', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/link/index.html', null, '链接列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872221', '1566872221', '1');
INSERT INTO `tp_admin_log` VALUES ('74', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/pos.html', null, '广告位置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872251', '1566872251', '1');
INSERT INTO `tp_admin_log` VALUES ('75', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/link/index.html', null, '链接列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872252', '1566872252', '1');
INSERT INTO `tp_admin_log` VALUES ('76', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/link/index.html', null, '链接列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872262', '1566872262', '1');
INSERT INTO `tp_admin_log` VALUES ('77', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/system/site.html', null, '站点设置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872631', '1566872631', '1');
INSERT INTO `tp_admin_log` VALUES ('78', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/addons/index.html', null, '插件列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872917', '1566872917', '1');
INSERT INTO `tp_admin_log` VALUES ('79', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/addons/index.html', null, '插件列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872925', '1566872925', '1');
INSERT INTO `tp_admin_log` VALUES ('80', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/index.html', null, '广告列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566872964', '1566872964', '1');
INSERT INTO `tp_admin_log` VALUES ('81', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875217', '1566875217', '1');
INSERT INTO `tp_admin_log` VALUES ('82', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875331', '1566875331', '1');
INSERT INTO `tp_admin_log` VALUES ('83', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/index/module.html', null, '模块管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875404', '1566875404', '1');
INSERT INTO `tp_admin_log` VALUES ('84', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875410', '1566875410', '1');
INSERT INTO `tp_admin_log` VALUES ('85', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/index/module.html', null, '模块管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875526', '1566875526', '1');
INSERT INTO `tp_admin_log` VALUES ('86', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/index/module.html', null, '模块管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875528', '1566875528', '1');
INSERT INTO `tp_admin_log` VALUES ('87', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/pos.html', null, '广告位置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875549', '1566875549', '1');
INSERT INTO `tp_admin_log` VALUES ('88', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/index/module.html', null, '模块管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875555', '1566875555', '1');
INSERT INTO `tp_admin_log` VALUES ('89', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/index/module.html', null, '模块管理', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875568', '1566875568', '1');
INSERT INTO `tp_admin_log` VALUES ('90', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875631', '1566875631', '1');
INSERT INTO `tp_admin_log` VALUES ('91', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875649', '1566875649', '1');
INSERT INTO `tp_admin_log` VALUES ('92', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875673', '1566875673', '1');
INSERT INTO `tp_admin_log` VALUES ('93', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875874', '1566875874', '1');
INSERT INTO `tp_admin_log` VALUES ('94', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875882', '1566875882', '1');
INSERT INTO `tp_admin_log` VALUES ('95', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_3 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) CriO', '127.0.0.1', '1566875920', '1566875920', '1');
INSERT INTO `tp_admin_log` VALUES ('96', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566875936', '1566875936', '1');
INSERT INTO `tp_admin_log` VALUES ('97', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/adv/pos.html', null, '广告位置', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566876377', '1566876377', '1');
INSERT INTO `tp_admin_log` VALUES ('98', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566876434', '1566876434', '1');
INSERT INTO `tp_admin_log` VALUES ('99', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566876675', '1566876675', '1');
INSERT INTO `tp_admin_log` VALUES ('100', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566876680', '1566876680', '1');
INSERT INTO `tp_admin_log` VALUES ('101', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566877084', '1566877084', '1');
INSERT INTO `tp_admin_log` VALUES ('102', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566877090', '1566877090', '1');
INSERT INTO `tp_admin_log` VALUES ('103', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566877147', '1566877147', '1');
INSERT INTO `tp_admin_log` VALUES ('104', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566877440', '1566877440', '1');
INSERT INTO `tp_admin_log` VALUES ('105', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566877776', '1566877776', '1');
INSERT INTO `tp_admin_log` VALUES ('106', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882414', '1566882414', '1');
INSERT INTO `tp_admin_log` VALUES ('107', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882417', '1566882417', '1');
INSERT INTO `tp_admin_log` VALUES ('108', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/group.html', null, '权限组', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882492', '1566882492', '1');
INSERT INTO `tp_admin_log` VALUES ('109', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882494', '1566882494', '1');
INSERT INTO `tp_admin_log` VALUES ('110', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminrule.html', null, '权限列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882506', '1566882506', '1');
INSERT INTO `tp_admin_log` VALUES ('111', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882507', '1566882507', '1');
INSERT INTO `tp_admin_log` VALUES ('112', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882543', '1566882543', '1');
INSERT INTO `tp_admin_log` VALUES ('113', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/auth/adminlist.html', null, '管理员列表', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566882549', '1566882549', '1');
INSERT INTO `tp_admin_log` VALUES ('114', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566883527', '1566883527', '1');
INSERT INTO `tp_admin_log` VALUES ('115', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566883722', '1566883722', '1');
INSERT INTO `tp_admin_log` VALUES ('116', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566883725', '1566883725', '1');
INSERT INTO `tp_admin_log` VALUES ('117', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566884232', '1566884232', '1');
INSERT INTO `tp_admin_log` VALUES ('118', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566887299', '1566887299', '1');
INSERT INTO `tp_admin_log` VALUES ('119', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566887357', '1566887357', '1');
INSERT INTO `tp_admin_log` VALUES ('120', '1', 'admin', '/demo/tp6/tp6/public/index.php/admin/entrance/index.html', null, '快捷入口', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safa', '127.0.0.1', '1566887363', '1566887363', '1');

-- ----------------------------
-- Table structure for tp_adv
-- ----------------------------
DROP TABLE IF EXISTS `tp_adv`;
CREATE TABLE `tp_adv` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告id',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '广告位置ID',
  `media_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '广告类型',
  `ad_name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告名称',
  `ad_link` varchar(255) DEFAULT '' COMMENT '链接地址',
  `ad_image` mediumtext NOT NULL COMMENT '图片地址',
  `start_time` int(11) NOT NULL DEFAULT '0' COMMENT '投放时间',
  `end_time` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
  `link_admin` varchar(60) NOT NULL DEFAULT '' COMMENT '添加人',
  `link_email` varchar(60) NOT NULL DEFAULT '' COMMENT '添加人邮箱',
  `link_phone` varchar(60) NOT NULL DEFAULT '' COMMENT '添加人联系电话',
  `click_count` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '点击量',
  `sort` int(20) DEFAULT NULL,
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
  `orderby` smallint(6) DEFAULT '50' COMMENT '排序',
  `target` tinyint(1) DEFAULT '0' COMMENT '是否开启浏览器新窗口',
  `bgcolor` varchar(20) DEFAULT NULL COMMENT '背景颜色',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `enabled` (`status`) USING BTREE,
  KEY `position_id` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tp_adv
-- ----------------------------
INSERT INTO `tp_adv` VALUES ('1', '2', '0', '首页', 'javascript:void(0);', '/public/upload/ad/2018/04-24/a7a54a5b527f0b1b069b8421378ad0fa.jpg', '1451577600', '1483286400', '', '', '', '0', null, '1', '0', '0', '#43d7f6', null, null);
INSERT INTO `tp_adv` VALUES ('2', '2', '0', '首页', 'javascript:void(0);', '/public/upload/ad/2018/04-25/93bf5c1ebdf4c4359253a107bcbdbe98.jpg', '1451577600', '1767283200', '', '', '', '0', null, '1', '0', '0', '#ff8000', null, '1566106884');
INSERT INTO `tp_adv` VALUES ('3', '2', '0', '轮播', 'javascript:void(0);', '/public/upload/ad/2018/04-13/6eeaa63e76c946927d0c1e67f6cf4f4f.jpg', '1451577600', '1767283200', '', '', '', '0', null, '1', '0', '0', '#fea8c1', null, null);
INSERT INTO `tp_adv` VALUES ('4', '2', '0', '轮播', 'javascript:void(0);', '/public/upload/ad/2018/04-13/8099744a886c2cfad7c837e28aee9d52.jpg', '1451577600', '1767283200', '', '', '', '0', null, '1', '0', '0', '#f1e6d2', null, null);
INSERT INTO `tp_adv` VALUES ('7', '2', '0', '其他', 'javascript:void(0);', '/public/upload/ad/2018/04-13/7009c820b93bcf31d3e42df31d78ed71.jpg', '1451577600', '1767283200', '', '', '', '0', null, '1', '0', '0', '#f1dcf7', null, null);
INSERT INTO `tp_adv` VALUES ('12', '2', '0', '其他', 'javascript:void(0);', '/public/upload/ad/2018/04-24/44aa330b056f5b090b6d6ac8a9a072dd.jpg', '1451577600', '1767283200', '', '', '', '0', null, '1', '0', '0', '#000000', null, null);
INSERT INTO `tp_adv` VALUES ('82', '1', '0', '', 'https://www.baidu.com', '/storage/uploads/20190818\\0c2a7f85348cd9ae508ca860388fa021.png', '0', '0', '', '994927909@qq.com', '', '0', null, '1', '50', '0', null, '1566107420', '1566107420');
INSERT INTO `tp_adv` VALUES ('83', '1', '0', '组合套餐', 'https://www.baidu.com', '/storage/uploads/20190818\\2db9e450c251d0d21dac3d3384134bb0.png', '1566130740', '0', '', '994927909@qq.com', '', '0', null, '1', '50', '0', null, '1566107921', '1566107921');
INSERT INTO `tp_adv` VALUES ('84', '4', '0', 'banner6 ', 'https://www.baidu.com', '/storage/uploads/20190818\\8ebd41bd38db53338af00026cb592bc3.png', '1566130740', '0', '', '994927909@qq.com', '', '0', null, '1', '50', '0', null, '1566107968', '1566107968');
INSERT INTO `tp_adv` VALUES ('85', '1', '0', '组合套餐', 'https://www.baidu.com', '/storage/uploads/20190818\\674ca52c87c4552352f35d820c3ce33e.png', '0', '0', '', '994927909@qq.com', '', '0', null, '1', '50', '0', null, '1566108105', '1566108105');
INSERT INTO `tp_adv` VALUES ('86', '2', '0', '组合套餐', 'https://www.baidu.com', '/storage/uploads/20190818\\cd986a75a1be03d8a7af558fda044ca4.png', '1566130740', '0', '', '994927909@qq.com', '', '0', null, '1', '50', '0', null, '1566108149', '1566108149');
INSERT INTO `tp_adv` VALUES ('87', '2', '0', 'banner6 ', 'https://www.baidu.com', '/storage/uploads/20190818\\7e2ca2635af1031871ab121938818a4d.png', '1564588800', '1568908800', '', '994927909@qq.com', '', '0', null, '1', '50', '0', null, '1566108542', '1566108542');

-- ----------------------------
-- Table structure for tp_adv_position
-- ----------------------------
DROP TABLE IF EXISTS `tp_adv_position`;
CREATE TABLE `tp_adv_position` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `position_name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告位置名称',
  `ad_width` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '广告位宽度',
  `ad_height` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '广告位高度',
  `position_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '广告描述',
  `position_style` mediumtext COMMENT '模板',
  `status` tinyint(1) DEFAULT '0' COMMENT '0关闭1开启',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `position_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=540 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tp_adv_position
-- ----------------------------
INSERT INTO `tp_adv_position` VALUES ('1', 'Cart页面自动增加广告位 1 ', '0', '0', 'Cart页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('2', 'Index页面自动增加广告位 2 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('4', 'Topic页面自动增加广告位 4 ', '0', '0', 'Topic页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('9', 'Index页面自动增加广告位 9 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('10', 'Index页面自动增加广告位 10 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('11', 'Index页面自动增加广告位 11 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('12', 'Index页面自动增加广告位 12 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('13', 'Index页面自动增加广告位 13 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('14', 'Index页面自动增加广告位 14 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('15', 'Index页面自动增加广告位 15 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('16', 'Index页面自动增加广告位 16 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('17', 'Index页面自动增加广告位 17 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('18', 'Index页面自动增加广告位 18 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('19', 'Index页面自动增加广告位 19 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('20', 'Index页面自动增加广告位 20 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('21', 'Index页面自动增加广告位 21 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('22', 'Index页面自动增加广告位 22 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('23', 'Index页面自动增加广告位 23 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('24', 'Index页面自动增加广告位 24 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('25', 'Index页面自动增加广告位 25 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('26', 'Index页面自动增加广告位 26 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('27', 'Index页面自动增加广告位 27 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('28', 'Index页面自动增加广告位 28 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('49', 'Index页面自动增加广告位 49 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('50', 'Index页面自动增加广告位 50 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('51', 'Index页面自动增加广告位 51 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('52', 'Index页面自动增加广告位 52 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('101', 'Index页面自动增加广告位 101 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('102', 'Index页面自动增加广告位 102 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('103', 'Index页面自动增加广告位 103 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('104', 'Index页面自动增加广告位 104 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('105', 'Index页面自动增加广告位 105 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('106', 'Index页面自动增加广告位 106 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('107', 'Index页面自动增加广告位 107 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('108', 'Index页面自动增加广告位 108 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('204', 'Activity页面自动增加广告位 204 ', '0', '0', 'Activity页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('205', 'Activity页面自动增加广告位 205 ', '0', '0', 'Activity页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('206', 'Activity页面自动增加广告位 206 ', '0', '0', 'Activity页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('207', 'Activity页面自动增加广告位 207 ', '0', '0', 'Activity页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('208', 'Activity页面自动增加广告位 208 ', '0', '0', 'Activity页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('300', 'Index页面自动增加广告位 300 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('301', 'Index页面自动增加广告位 301 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('302', 'Index页面自动增加广告位 302 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('303', 'Index页面自动增加广告位 303 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('304', 'Index页面自动增加广告位 304 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('305', 'Index页面自动增加广告位 305 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('306', 'Index页面自动增加广告位 306 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('307', 'Index页面自动增加广告位 307 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('400', 'Index页面自动增加广告位 400 ', '0', '0', 'Index页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('401', 'Goods页面自动增加广告位 401 ', '0', '0', 'Goods页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('500', 'Ad页面自动增加广告位 500 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('506', 'Ad页面自动增加广告位 506 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('507', 'Ad页面自动增加广告位 507 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('508', 'Ad页面自动增加广告位 508 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('509', 'Ad页面自动增加广告位 509 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('510', 'Ad页面自动增加广告位 510 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('511', 'Ad页面自动增加广告位 511 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('512', 'Ad页面自动增加广告位 512 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('513', 'Ad页面自动增加广告位 513 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('514', 'Ad页面自动增加广告位 514 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('515', 'Ad页面自动增加广告位 515 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('516', 'Ad页面自动增加广告位 516 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('517', 'Ad页面自动增加广告位 517 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('518', 'Ad页面自动增加广告位 518 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('531', 'Ad页面自动增加广告位 531 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('533', 'Ad页面自动增加广告位 533 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('534', 'Ad页面自动增加广告位 534 ', '0', '0', 'Ad页面', null, '1', null, null);
INSERT INTO `tp_adv_position` VALUES ('539', '首页', '1080', '300', '其他1', null, '1', '1566111321', '1566111456');

-- ----------------------------
-- Table structure for tp_article
-- ----------------------------
DROP TABLE IF EXISTS `tp_article`;
CREATE TABLE `tp_article` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `pid` smallint(5) NOT NULL DEFAULT '0' COMMENT '类别ID',
  `title` varchar(150) NOT NULL DEFAULT '' COMMENT '文章标题',
  `description` longtext COMMENT '文章摘要',
  `content` longtext NOT NULL,
  `author` varchar(30) NOT NULL DEFAULT '' COMMENT '文章作者',
  `author_email` varchar(60) NOT NULL DEFAULT '' COMMENT '作者邮箱',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字,用逗号隔开',
  `article_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示,1:显示;0:不显示',
  `file_url` varchar(255) NOT NULL DEFAULT '' COMMENT '附件地址',
  `open_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `link` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `click` int(11) DEFAULT '0' COMMENT '浏览量',
  `publish_time` int(11) DEFAULT NULL COMMENT '文章预告发布时间',
  `sort` tinyint(1) DEFAULT '0',
  `thumb` varchar(255) DEFAULT '' COMMENT '文章缩略图',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tp_article
-- ----------------------------
INSERT INTO `tp_article` VALUES ('1', '1', '基于TP6 layui开发的cms 后台管理系统', '基于TP6 layui开发的cms 后台管理系统', '<p>基于TP6 layui开发的cms 后台管理系统</p>', '', '994927909@qq.com', 'tp6 layui', '1', '1', '', '0', '', '1206', null, '0', '/storage/uploads/20190826\\b183bf1681077d0bafd37bc17caf2cdc.png', '1566799075', '1566801008');

-- ----------------------------
-- Table structure for tp_article_cate
-- ----------------------------
DROP TABLE IF EXISTS `tp_article_cate`;
CREATE TABLE `tp_article_cate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) DEFAULT NULL COMMENT '类别名称',
  `title_alias` varchar(20) DEFAULT NULL COMMENT '别名',
  `title_type` smallint(6) DEFAULT '0' COMMENT '默认分组',
  `pid` smallint(6) DEFAULT '0' COMMENT '上级ID',
  `show_in_nav` tinyint(1) DEFAULT '0' COMMENT '是否导航显示',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态',
  `sort` smallint(6) DEFAULT '50' COMMENT '排序',
  `cat_desc` varchar(255) DEFAULT NULL COMMENT '分类描述',
  `keywords` varchar(30) DEFAULT NULL COMMENT '搜索关键词',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tp_article_cate
-- ----------------------------
INSERT INTO `tp_article_cate` VALUES ('1', '新手上路', null, '1', '0', '0', '0', '0', '1233', '', '0', '1566801852');
INSERT INTO `tp_article_cate` VALUES ('2', '购物指南', null, '1', '0', '0', '1', '2', '', '', '0', '0');
INSERT INTO `tp_article_cate` VALUES ('3', '售后服务', null, '1', '0', '0', '1', '2', '', '', '0', '0');
INSERT INTO `tp_article_cate` VALUES ('4', '支付方式', null, '1', '0', '0', '1', '4', '', '', '0', '0');
INSERT INTO `tp_article_cate` VALUES ('5', '配送方式', null, '1', '0', '0', '1', '5', '', '', '0', '0');
INSERT INTO `tp_article_cate` VALUES ('6', '系统公告', null, '1', '0', '0', '1', '6', '', '', '0', '0');
INSERT INTO `tp_article_cate` VALUES ('7', '关于我们', null, '1', '0', '0', '1', '7', '', '', '0', '0');
INSERT INTO `tp_article_cate` VALUES ('8', '测试分类', '测试分类', '0', '7', '0', '1', '50', null, null, '1566801126', '1566801126');

-- ----------------------------
-- 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 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=3 DEFAULT CHARSET=utf8mb4 COMMENT='管理员分组';

-- ----------------------------
-- Records of tp_auth_group
-- ----------------------------
INSERT INTO `tp_auth_group` VALUES ('1', '超级管理员', '1', '1,2,20,21,40,34,39,3,4,5,9,10,11,12,22,13,6,7,8,14,15,16,17,18,19,26,27,28,29,30,31,32,33,35,36,37,38,23,24,25,41,47,48,51,49,50,52,54,57,58,55,56,42,46,53,43,45,44,', '1465114224', '1566098022');
INSERT INTO `tp_auth_group` VALUES ('2', '测试1', '1', '1,2,39,20,21,34,6,35,36,38,', '1565929191', '1566019644');

-- ----------------------------
-- 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 '1公开 0不公开',
  `menu_status` tinyint(1) DEFAULT '0' COMMENT '0 不显示，1 显示',
  `icon` varchar(30) 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=62 DEFAULT CHARSET=utf8 COMMENT='权限节点';

-- ----------------------------
-- Records of tp_auth_rule
-- ----------------------------
INSERT INTO `tp_auth_rule` VALUES ('1', 'System', '系统面板', '1', '1', '0', '1', 'fa fa-home', '', '0', '0', '1446535750', null);
INSERT INTO `tp_auth_rule` VALUES ('2', 'System', '系统设置', '1', '1', '0', '1', 'fa fa-gears', '', '1', '0', '1446535789', null);
INSERT INTO `tp_auth_rule` VALUES ('3', 'Database', '数据库管理', '1', '1', '0', '1', 'fa fa-database', '', '1', '0', '1446535805', null);
INSERT INTO `tp_auth_rule` VALUES ('4', 'Database/restore', '还原数据库', '2', '1', '0', '1', 'fa fa-database', '', '3', '0', '1446535750', null);
INSERT INTO `tp_auth_rule` VALUES ('5', 'Database/backup', '数据库备份', '2', '1', '0', '0', 'fa fa-database', '', '3', '0', '1446535834', null);
INSERT INTO `tp_auth_rule` VALUES ('6', 'Auth', '权限管理', '1', '1', '0', '1', 'fa fa-cog', '', '1', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('7', 'Auth/adminRule', '权限列表', '1', '1', '0', '1', 'fa fa-cog', '', '6', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('8', 'Auth/ruleEdit', '权限编辑', '2', '1', '0', '0', 'fa fa-cog', '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('9', 'Database/repair', '数据库修复', '2', '1', '0', '0', null, '', '3', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('10', 'Database/import', '数据还原', '2', '1', '0', '0', null, '', '3', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('11', 'Database/downFile', '数据下载', '2', '1', '0', '0', null, '', '3', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('12', 'Database/delSqlFiles', '删除数据库', '2', '1', '0', '0', null, '', '3', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('13', 'Database/index', '数据库列表', '1', '1', '0', '1', 'fa fa-database', '', '3', '1', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('14', 'Auth/ruleState', '菜单显示或者隐藏', '2', '1', '0', '0', null, '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('15', 'Auth/ruleOpen', '权限是否验证', '2', '1', '0', '0', null, '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('16', 'Auth/ruleSort', '权限排序', '2', '1', '0', '0', null, '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('17', 'Auth/ruleDel', '权限删除', '2', '1', '0', '0', null, '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('18', 'Auth/ruleSelectDel', '权限批量删除', '2', '1', '0', '0', null, '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('19', 'Auth/ruleAdd', '权限增加', '2', '1', '0', '0', null, '', '7', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('20', 'System/site', '站点设置', '1', '1', '0', '1', 'fa fa-gears', '', '2', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('21', 'Adminlog/index', '日志管理', '1', '1', '0', '1', 'fa fa-life-ring', '', '2', '0', '0', '1566007925');
INSERT INTO `tp_auth_rule` VALUES ('22', 'Database/optimize', '数据库优化', '1', '1', '0', '0', null, '', '3', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('23', 'Addons', '插件管理', '1', '1', '0', '1', 'fa fa-flickr', '', '0', '0', '0', '1566053592');
INSERT INTO `tp_auth_rule` VALUES ('24', 'Addons', '插件设置', '1', '1', '0', '1', 'fa fa-flickr', '', '23', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('25', 'Addons/index', '插件列表', '1', '1', '0', '1', 'fa fa-globe', '', '24', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('26', 'Auth/group', '权限组', '1', '1', '0', '1', 'fa fa-globe', '', '6', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('27', 'Auth/groupDel', '用户组删除', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('28', 'Auth/groupAdd', '用户组添加', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('29', 'Auth/groupEdit', '用户组修改', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('30', 'Auth/groupState', '用户组状态修改', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('31', 'Auth/groupSelectDel', '用户组批量删除', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('32', 'Auth/groupAccess', '用户组显示权限', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('33', 'Auth/groupSetaccess', '用户组保存权限', '1', '1', '0', '0', null, '', '26', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('34', 'Uploads/uploads', '上传文件', '1', '1', '0', '0', null, '', '2', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('35', 'Auth/adminList', '管理员列表', '1', '1', '0', '1', 'fa fa-user-circle', '', '6', '0', '1', null);
INSERT INTO `tp_auth_rule` VALUES ('36', 'Auth/adminAdd', '添加管理员', '1', '1', '0', '0', null, '', '35', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('37', 'Auth/adminDel', '删除管理员', '1', '1', '0', '0', null, '', '35', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('38', 'Auth/adminState', '管理员状态', '1', '1', '0', '0', null, '', '35', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('39', 'Index/password', '修改密码', '1', '1', '0', '0', null, '', '2', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('40', 'Adminlog/delete', '删除日志', '1', '1', '0', '0', null, '', '21', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('41', 'Content', '内容管理', '1', '1', '0', '1', 'fa fa-folder-open', '', '0', '50', '1566092187', '1566092574');
INSERT INTO `tp_auth_rule` VALUES ('42', 'Link', '链接管理', '1', '1', '0', '1', 'fa fa-link', '', '41', '50', '1566092432', '1566092684');
INSERT INTO `tp_auth_rule` VALUES ('43', 'Link/add', '链接添加', '1', '1', '0', '0', '', '', '46', '50', '1566092486', '1566092801');
INSERT INTO `tp_auth_rule` VALUES ('44', 'Link/delete', '链接删除', '1', '1', '0', '0', '', '', '46', '50', '1566092613', '1566092798');
INSERT INTO `tp_auth_rule` VALUES ('45', 'Link/state', '链接状态', '1', '1', '0', '0', '', '', '46', '50', '1566092677', '1566092795');
INSERT INTO `tp_auth_rule` VALUES ('46', 'Link/index', '链接列表', '1', '1', '0', '1', 'fa fa-link', '', '42', '50', '1566092770', '1566092770');
INSERT INTO `tp_auth_rule` VALUES ('47', 'Adv', '广告管理', '1', '1', '0', '1', 'fa fa-audio-description', '', '41', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('48', 'Adv/index', '广告列表', '1', '1', '0', '1', 'fa fa-audio-description', '', '47', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('49', 'Adv/add', '广告添加', '1', '1', '0', '0', '', '', '48', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('50', 'Adv/delete', '广告删除', '1', '1', '0', '0', null, '', '48', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('51', 'Adv/state', '广告状态', '1', '1', '0', '0', null, '', '48', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('52', 'Adv/order', '广告排序', '1', '1', '0', '0', null, '', '48', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('53', 'Link/order', '链接排序', '1', '1', '0', '0', null, '', '46', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('54', 'Adv/pos', '广告位置', '1', '1', '0', '1', 'fa fa-audio-description', '', '47', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('55', 'Adv/posAdd', '广告位添加/编辑', '1', '1', '0', '0', null, '', '54', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('56', 'Adv/posDel', '广告位删除', '1', '1', '0', '0', null, '', '54', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('57', 'Adv/posState', '广告位状态', '1', '1', '0', '0', null, '', '54', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('58', 'Adv/posOrder', '广告位排序', '1', '1', '0', '0', null, '', '54', '0', '0', null);
INSERT INTO `tp_auth_rule` VALUES ('59', 'Module', '模块管理', '1', '1', '0', '1', 'fa fa-archive', '', '1', '0', '1566875314', '1566875314');
INSERT INTO `tp_auth_rule` VALUES ('61', 'Entrance/index', '快捷入口', '1', '1', '0', '1', 'fa fa-credit-card-alt', '', '59', '0', '1566875518', '1566875518');

-- ----------------------------
-- Table structure for tp_config
-- ----------------------------
DROP TABLE IF EXISTS `tp_config`;
CREATE TABLE `tp_config` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `code` varchar(30) NOT NULL,
  `value` mediumtext,
  `remark` varchar(100) DEFAULT '解释,备注',
  `type` varchar(20) DEFAULT 'site',
  `status` tinyint(1) DEFAULT '1',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COMMENT='配置参数表';

-- ----------------------------
-- Records of tp_config
-- ----------------------------
INSERT INTO `tp_config` VALUES ('1', 'site_name', 'layui网站demo', '网站名称', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('2', 'site_phone', '3', '网站客服服务电话', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('3', 'site_state', '1', '状态', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('4', 'site_logo', '/storage/uploads/20190827\\ce6c09b750dec6883425e71b7810b7b5.png', '网站logo图', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('5', 'site_mobile_logo', 'site_mobile_logo.png', '默认网站手机端logo', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('6', 'site_logowx', 'site_logowx.jpg', '微信网站二维码', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('7', 'site_icp', '2', 'ICP备案号', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('8', 'site_tel400', '40002541852', '解释,备注', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('9', 'site_email', '584887013@qq.com', '电子邮件', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('10', 'site_copyright', 'THINKPHP版权所有@2019', '底部版权信息', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('11', 'captcha_status_login', '1', '会员登录是否需要验证码', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('12', 'captcha_status_register', '1', '会员注册是否验证码', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('14', 'sms_appid', 'LTAIesI7qxnHLgKE', '短信平台账号', 'sms', '1', null, null);
INSERT INTO `tp_config` VALUES ('15', 'sms_secret', 'sbA6wnefJLD7pv7WipcxL0M3IMb3l9', '短信平台密钥', 'sms', '1', null, null);
INSERT INTO `tp_config` VALUES ('16', 'email_host', 'smtp.qq.com', '邮箱地址', 'email', '1', null, null);
INSERT INTO `tp_config` VALUES ('17', 'email_port', '25', '邮箱端口', 'email', '1', null, null);
INSERT INTO `tp_config` VALUES ('18', 'email_addr', '994927909@qq.com', '邮箱发件人地址', 'email', '1', null, null);
INSERT INTO `tp_config` VALUES ('19', 'email_id', '994927909@qq.com', '身份验证用户名', 'email', '1', null, null);
INSERT INTO `tp_config` VALUES ('20', 'email_pass', '11211', '用户名密码', 'email', '1', null, null);
INSERT INTO `tp_config` VALUES ('21', 'email_secure', 'smtp', '邮箱发送协议', 'email', '1', null, null);
INSERT INTO `tp_config` VALUES ('22', 'upload_file_type', 'bmp|png|gif|jpg|jpeg|zip|rar|txt|ppt|xls|doc|mp3|mp4', '图片上传保存方式', 'upload', '1', null, null);
INSERT INTO `tp_config` VALUES ('23', 'cache_open', '0', '是否开启缓存', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('24', 'alioss_accessid', null, 'accessid', 'oss', '1', null, null);
INSERT INTO `tp_config` VALUES ('25', 'alioss_accesssecret', null, 'oss_accesssecret', 'oss', '1', null, null);
INSERT INTO `tp_config` VALUES ('26', 'alioss_bucket', null, 'oss_bucket', 'oss', '1', null, null);
INSERT INTO `tp_config` VALUES ('27', 'alioss_endpoint', null, 'oss_endpoint', 'oss', '1', null, null);
INSERT INTO `tp_config` VALUES ('28', 'aliendpoint_type', '0', 'aliendpoint_type', 'oss', '1', null, null);
INSERT INTO `tp_config` VALUES ('29', 'node_site_url', null, '站内IM服务器地址', 'im', '1', null, null);
INSERT INTO `tp_config` VALUES ('30', 'node_site_use', '0', '是否启用im', 'im', '1', null, null);
INSERT INTO `tp_config` VALUES ('31', 'qq_isuse', '1', '是否使用QQ互联', 'qq', '1', null, null);
INSERT INTO `tp_config` VALUES ('32', 'qq_appid', '', 'qq互联id', 'qq', '1', null, null);
INSERT INTO `tp_config` VALUES ('33', 'qq_appkey', '', 'qq秘钥', 'qq', '1', null, null);
INSERT INTO `tp_config` VALUES ('34', 'sina_isuse', '1', '是的使用微博登录', 'sina', '1', null, null);
INSERT INTO `tp_config` VALUES ('35', 'sina_wb_akey', '', '新浪id', 'sina', '1', null, null);
INSERT INTO `tp_config` VALUES ('36', 'sina_wb_skey', '', '新浪秘钥', 'sina', '1', null, null);
INSERT INTO `tp_config` VALUES ('37', 'sms_register', '0', '是否手机注册', 'mobile', '1', null, null);
INSERT INTO `tp_config` VALUES ('38', 'sms_login', '0', '是否手机登录', 'mobile', '1', null, null);
INSERT INTO `tp_config` VALUES ('39', 'sms_password', '0', '是否手机找回密码', 'mobile', '1', null, null);
INSERT INTO `tp_config` VALUES ('40', 'weixin_isuse', null, '是否微信登录', 'weixin', '1', null, null);
INSERT INTO `tp_config` VALUES ('41', 'weixin_appid', null, '微信appid', 'weixin', '1', null, null);
INSERT INTO `tp_config` VALUES ('42', 'weixin_secret', null, '微信appserite', 'weixin', '1', null, null);
INSERT INTO `tp_config` VALUES ('43', 'baidu_ak', '22bb7221fc279a484895afcc6a0bb33a', '百度地图AK密钥', 'baidu', '1', null, null);
INSERT INTO `tp_config` VALUES ('44', 'site_licence', '', '营业执照', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('45', 'site_domain', '#', '网站地址', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('46', 'upload_file_max', '200', '最大文件上传大小', 'upload', '1', null, null);
INSERT INTO `tp_config` VALUES ('47', 'site_seo_title', '无所不能的thinkphp框架,也是国内程序员的最爱', '首页标题', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('48', 'site_seo_keywords', 'php,thinkphp,workerman', '首页关键词', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('49', 'site_seo_desc', '你是我的眼,带我凌律万千花种', '首页描述', 'site', '1', null, null);
INSERT INTO `tp_config` VALUES ('50', 'upload_water', '1', '水印开始关闭', 'upload', '1', null, null);
INSERT INTO `tp_config` VALUES ('51', 'upload_water_position', null, '水印位置', 'upload', '1', null, null);
INSERT INTO `tp_config` VALUES ('52', 'sms_product', 'lemocms', '产品', 'sms', '1', null, null);
INSERT INTO `tp_config` VALUES ('53', 'sms_template', 'SMS_158941284', '模板id', 'sms', '1', null, null);

-- ----------------------------
-- Table structure for tp_link
-- ----------------------------
DROP TABLE IF EXISTS `tp_link`;
CREATE TABLE `tp_link` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '链接名称',
  `url` varchar(200) NOT NULL COMMENT '链接URL',
  `type_id` tinyint(4) DEFAULT NULL COMMENT '所属栏目ID',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `qq` varchar(20) DEFAULT NULL COMMENT '联系QQ',
  `sort` int(5) NOT NULL DEFAULT '50' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '0禁用1启用',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tp_link
-- ----------------------------
INSERT INTO `tp_link` VALUES ('23', 'lemocms2', 'https://www.lemocms.com', null, '994927909@qq.com', '994927909', '50', '1', '1566102829', '1566103652');
INSERT INTO `tp_link` VALUES ('25', '百度', 'https://www.baidu.com', null, '994927909@qq.com', '994927909', '50', '1', '1566103165', '1566103165');
INSERT INTO `tp_link` VALUES ('26', '新浪', 'https://www.sina.com', null, '994927909@qq.com', '994927909', '50', '1', '1566103233', '1566103233');
SET FOREIGN_KEY_CHECKS=1;