/*
 Navicat Premium Data Transfer

 Source Server         : Mysql8.0.21
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : my_blog_dev3

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 02/11/2020 14:52:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_attach
-- ----------------------------
DROP TABLE IF EXISTS `t_attach`;
CREATE TABLE `t_attach`  (
  `id` int unsigned NOT NULL,
  `fname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `ftype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `fkey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `author_id` int(0) NULL DEFAULT NULL,
  `created` int(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_attach
-- ----------------------------
INSERT INTO `t_attach` VALUES (3, '1.png', 'image', '/upload/2020/09/601c3368vug26p20dgmcuv2052.png', 1, 1601043223);
INSERT INTO `t_attach` VALUES (4, '4.png', 'image', '/upload/2020/09/rneks1odtqi0ho9d8g3usj8aoh.png', 1, 1601043260);
INSERT INTO `t_attach` VALUES (5, '2.png', 'image', '/upload/2020/09/680sttv320i4ior0ld5si6a8sr.png', 1, 1601043294);
INSERT INTO `t_attach` VALUES (6, '5.png', 'image', '/upload/2020/09/pg6i8bb3lgilfq8at48r1tsfh8.png', 1, 1601043343);
INSERT INTO `t_attach` VALUES (7, '6.png', 'image', '/upload/2020/09/te2nm4vesmj0pphf4cgqe5rcsl.png', 1, 1601043382);
INSERT INTO `t_attach` VALUES (11, 'cg (2).jpg', 'image', '/upload/2020/10/p5qemnh30ugvoqfunhsrc193tp.jpg', 1, 1603448732);
INSERT INTO `t_attach` VALUES (12, '文本上传测试.txt', 'file', '/upload/2020/10/p212a7hlnghibpfp04f4m4bd6f.txt', 1, 1603850257);
INSERT INTO `t_attach` VALUES (13, '图片上传测试.jpg', 'image', '/upload/2020/10/2btjmdfv8cjkpq5kemc4rlc801.jpg', 1, 1603850292);
INSERT INTO `t_attach` VALUES (14, 'java文件上传测试.java', 'file', '/upload/2020/10/1p9v91i5i8gakq4r27jl1sh0nl.java', 1, 1603850332);
INSERT INTO `t_attach` VALUES (17, '图片上传测试002.jpg', 'image', '/upload/2020/10/55j0pasn2ihi6r8sg0ipdtunsm.jpg', 1, 1603850564);

-- ----------------------------
-- Table structure for t_comments
-- ----------------------------
DROP TABLE IF EXISTS `t_comments`;
CREATE TABLE `t_comments`  (
  `coid` int unsigned NOT NULL,
  `cid` int unsigned NULL,
  `created` int unsigned NULL,
  `author` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `author_id` int unsigned NULL,
  `owner_id` int unsigned NULL,
  `mail` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `agent` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'comment',
  `status` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'approved',
  `parent` int unsigned NULL,
  PRIMARY KEY (`coid`) USING BTREE,
  INDEX `cid`(`cid`) USING BTREE,
  INDEX `created`(`created`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_comments
-- ----------------------------
INSERT INTO `t_comments` VALUES (5, 13, 1604159656, '评论审核测试', 0, 1, '2156661550@qq.com', '', '0:0:0:0:0:0:0:1', NULL, '评论删除测试1', 'comment', 'approved', 0);
INSERT INTO `t_comments` VALUES (6, 14, 1604159671, '评论审核测试', 0, 1, '2156661550@qq.com', '', '0:0:0:0:0:0:0:1', NULL, '评论删除测试2', 'comment', 'approved', 0);
INSERT INTO `t_comments` VALUES (7, 10, 1604159680, '评论审核测试', 0, 1, '2156661550@qq.com', '', '0:0:0:0:0:0:0:1', NULL, '评论删除测试3', 'comment', 'approved', 0);
INSERT INTO `t_comments` VALUES (8, 12, 1604159692, '评论审核测试', 0, 1, '2156661550@qq.com', '', '0:0:0:0:0:0:0:1', NULL, '评论删除测试5', 'comment', 'approved', 0);
INSERT INTO `t_comments` VALUES (9, 13, 1604218081, '评论审核测试', 0, 1, '2156661550@qq.com', 'http://www.baidu.com', '0:0:0:0:0:0:0:1', NULL, '5364564', 'comment', 'approved', 0);

-- ----------------------------
-- Table structure for t_contents
-- ----------------------------
DROP TABLE IF EXISTS `t_contents`;
CREATE TABLE `t_contents`  (
  `cid` int unsigned NOT NULL,
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `slug` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `created` int unsigned NULL,
  `modified` int unsigned NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容文字',
  `author_id` int unsigned NULL,
  `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'post',
  `status` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'publish',
  `tags` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `categories` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `thumbImg` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `hits` int unsigned NULL,
  `comments_num` int unsigned NULL,
  `allow_comment` tinyint(1) NULL DEFAULT 1,
  `allow_ping` tinyint(1) NULL DEFAULT 1,
  `allow_feed` tinyint(1) NULL DEFAULT 1,
  PRIMARY KEY (`cid`) USING BTREE,
  UNIQUE INDEX `slug`(`slug`) USING BTREE,
  INDEX `created`(`created`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_contents
-- ----------------------------
INSERT INTO `t_contents` VALUES (7, '呵呵呵呵', NULL, 1601043383, 1601043383, 'IT跃迁谷', 1, 'post', 'publish', 'IT跃迁谷', 'java', '/upload/2020/09/te2nm4vesmj0pphf4cgqe5rcsl.png', 17, 0, 1, 1, 1);
INSERT INTO `t_contents` VALUES (8, '酒店管理系统，SSM主流框架还不学习吗？吃透框架知识，工资翻倍！', NULL, 1601043495, 1601043495, 'IT跃迁谷', 1, 'post', 'publish', 'IT跃迁谷', 'java', '/upload/2020/09/tk2d7jmg5qgg8raa4i26kbcd14.png', 16, 0, 1, 1, 1);
INSERT INTO `t_contents` VALUES (10, '测试博客系统', NULL, 1601045551, 1604293852, '是一个专注于软件行业的卓越团队，团队中有曾经完成过非常多国内一线大型IT项目的项目经理、架构师等等带队作为支撑\r\n团队技术过硬！项目质量保障！服务态度优质！性价比非常高！选择我们！值！', 3, 'post', 'publish', 'IT跃迁谷', 'java', '', 28, 2, 1, 1, 1);
INSERT INTO `t_contents` VALUES (12, '谷歌浏览器（Google Chrome）', NULL, 1603848787, 1603848787, '谷歌浏览器（Google Chrome）\r\n![alt](https://pjax.cn/content/uploadfile/201505/4a471432532395.png)\r\n \r\n\r\nGoogle Chrome是由Google开发的一款设计简单、高效的Web浏览工具。\r\n注：此下载包括开发版(Dev)、测试版(Beta)、正式版(Final)以及部分旧版。\r\nGoogle Chrome Canary版拥有新版 Chrome 的最新功能。\r\n预先警告：Canary版是专为开发者和早期用户设计的版本，有时可能会造成浏览器彻底当机。\r\n下载Chrome企业和教育版(.MSI封装)。\r\nGoogle Chrome的特点是简洁、快速。Google Chrome支持多标签浏览，每个标签页面都在独立的“沙箱”内运行，在提高安全性的同时，一个标签页面的崩溃也不会导致其他标签页面被关闭。此外，Google Chrome基于更强大的JavaScript V8引擎，这是当前Web浏览器所无法实现的。\r\nGoogle Chrome是一款开源软件，借鉴了苹果的WebKit(Safari使用的引擎)、Mozilla的Firefox及其他相关应用。\r\n主要特性：\r\n·Chrome浏览器基于开源的Webkit，其中包含谷歌Gears。\r\n·Chrome提供了浏览器扩展框架，可以制作与Adobe-AIR类似的混合应用。\r\n·包含V8 Javascript虚拟机，这个多线程的虚拟机可以加速Javascript的执行。\r\n·具备隐私模式，可以让用户无需在本地机器上登录即可使用，这个功能与微软IE8中的Incognito类似。\r\n·浏览器将内置防止“网络钓鱼”及恶意软件功能。\r\nGoogle Chrome也有Mac和Linux版本。', 1, 'post', 'publish', '标签测试', '编程学习', '', 95, 1, 1, 1, 1);
INSERT INTO `t_contents` VALUES (13, '文章测试1', NULL, 1603848846, 1603848846, '谷歌浏览器（Google Chrome）\r\n1.png\r\n\r\n \r\n\r\nGoogle Chrome是由Google开发的一款设计简单、高效的Web浏览工具。\r\n注：此下载包括开发版(Dev)、测试版(Beta)、正式版(Final)以及部分旧版。\r\nGoogle Chrome Canary版拥有新版 Chrome 的最新功能。\r\n预先警告：Canary版是专为开发者和早期用户设计的版本，有时可能会造成浏览器彻底当机。\r\n下载Chrome企业和教育版(.MSI封装)。\r\nGoogle Chrome的特点是简洁、快速。Google Chrome支持多标签浏览，每个标签页面都在独立的“沙箱”内运行，在提高安全性的同时，一个标签页面的崩溃也不会导致其他标签页面被关闭。此外，Google Chrome基于更强大的JavaScript V8引擎，这是当前Web浏览器所无法实现的。\r\nGoogle Chrome是一款开源软件，借鉴了苹果的WebKit(Safari使用的引擎)、Mozilla的Firefox及其他相关应用。\r\n主要特性：\r\n·Chrome浏览器基于开源的Webkit，其中包含谷歌Gears。\r\n·Chrome提供了浏览器扩展框架，可以制作与Adobe-AIR类似的混合应用。\r\n·包含V8 Javascript虚拟机，这个多线程的虚拟机可以加速Javascript的执行。\r\n·具备隐私模式，可以让用户无需在本地机器上登录即可使用，这个功能与微软IE8中的Incognito类似。\r\n·浏览器将内置防止“网络钓鱼”及恶意软件功能。\r\nGoogle Chrome也有Mac和Linux版本。', 1, 'post', 'publish', '标签添加测试1', '默认分类', '', 268, 2, 1, 1, 1);
INSERT INTO `t_contents` VALUES (14, '文章添加测试001', NULL, 1603848787, 1603932763, '**文章添加测试001文章添加测试001**\r\n*文章添加测试001文章添加测试001文章添加测试001文章添加测试001*\r\n<u>文章添加测试001文章添加测试001文章添加测试001</u>\r\n\r\n~~文章添加测试001文章添加测试001~~\r\n# 文章添加测试001文章添加测试001文章添加测试001\r\n```js\r\n文章添加测试001\r\n\r\n```  \r\n1. 文章添加测试001文章添加测试001\r\n\r\n文章添加测试001文章添加测试00column1 | column2 | column3  \r\n------- | ------- | -------  \r\ncolumn1 | column2 | column3  \r\ncolumn1 | column2 | column3  \r\ncolumn1 | column2 | column3  \r\n1\r\nvv文章添加测试001', 1, 'post', 'publish', '标签添加', 'java', '', 26, 1, 1, 1, 1);
INSERT INTO `t_contents` VALUES (16, '【新添加一个页面】', 'about', 1604151301, 1604151301, '【新添加一个页面】\r\n【新添加一个页面】【新添加一个页面】\r\n【新添加一个页面】', 1, 'page', 'publish', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL);
INSERT INTO `t_contents` VALUES (17, '【新添加一个页面】2', 'luoyawen1', 1604151314, 1604151314, '【新添加一个页面】', 1, 'page', 'publish', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for t_favorite
-- ----------------------------
DROP TABLE IF EXISTS `t_favorite`;
CREATE TABLE `t_favorite`  (
  `cid` int unsigned NOT NULL,
  `uid` int unsigned NOT NULL,
  `created` int unsigned NULL,
  PRIMARY KEY (`cid`, `uid`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE,
  INDEX `created`(`created`) USING BTREE,
  CONSTRAINT `cid` FOREIGN KEY (`cid`) REFERENCES `t_contents` (`cid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `t_users` (`uid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_favorite
-- ----------------------------
INSERT INTO `t_favorite` VALUES (12, 1, 1603848787);
INSERT INTO `t_favorite` VALUES (12, 3, 1603848787);
INSERT INTO `t_favorite` VALUES (13, 1, 1603848787);
INSERT INTO `t_favorite` VALUES (7, 2, 1604151314);
INSERT INTO `t_favorite` VALUES (10, 3, 1604294476);
INSERT INTO `t_favorite` VALUES (10, 1, 1604297019);

-- ----------------------------
-- Table structure for t_logs
-- ----------------------------
DROP TABLE IF EXISTS `t_logs`;
CREATE TABLE `t_logs`  (
  `id` int unsigned NOT NULL,
  `action` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `data` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `author_id` int(0) NULL DEFAULT NULL,
  `ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `created` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_logs
-- ----------------------------
INSERT INTO `t_logs` VALUES (1, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601042585);
INSERT INTO `t_logs` VALUES (2, '删除页面', '1', 1, '0:0:0:0:0:0:0:1', 1601042966);
INSERT INTO `t_logs` VALUES (3, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601043167);
INSERT INTO `t_logs` VALUES (4, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601043810);
INSERT INTO `t_logs` VALUES (5, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601044349);
INSERT INTO `t_logs` VALUES (6, '删除页面', '9', 1, '0:0:0:0:0:0:0:1', 1601044435);
INSERT INTO `t_logs` VALUES (7, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601045028);
INSERT INTO `t_logs` VALUES (8, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601045423);
INSERT INTO `t_logs` VALUES (9, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601046347);
INSERT INTO `t_logs` VALUES (10, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1601046359);
INSERT INTO `t_logs` VALUES (11, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603446569);
INSERT INTO `t_logs` VALUES (12, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603454366);
INSERT INTO `t_logs` VALUES (13, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603701272);
INSERT INTO `t_logs` VALUES (14, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603704735);
INSERT INTO `t_logs` VALUES (15, '删除附件', '/upload/2020/09/o8ek4cktb0gr1q1t94gh3hraf5.txt', 1, '0:0:0:0:0:0:0:1', 1603704779);
INSERT INTO `t_logs` VALUES (16, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603768661);
INSERT INTO `t_logs` VALUES (17, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603768730);
INSERT INTO `t_logs` VALUES (18, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603769431);
INSERT INTO `t_logs` VALUES (19, '删除页面', '3', 1, '0:0:0:0:0:0:0:1', 1603769471);
INSERT INTO `t_logs` VALUES (20, '删除页面', '4', 1, '0:0:0:0:0:0:0:1', 1603769503);
INSERT INTO `t_logs` VALUES (21, '删除页面', '4', 1, '0:0:0:0:0:0:0:1', 1603769512);
INSERT INTO `t_logs` VALUES (22, '删除页面', '2', 1, '0:0:0:0:0:0:0:1', 1603769516);
INSERT INTO `t_logs` VALUES (23, '删除页面', '1', 1, '0:0:0:0:0:0:0:1', 1603769520);
INSERT INTO `t_logs` VALUES (24, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603769841);
INSERT INTO `t_logs` VALUES (25, '删除文章', '11', 1, '0:0:0:0:0:0:0:1', 1603770017);
INSERT INTO `t_logs` VALUES (26, '删除页面', '4', 1, '0:0:0:0:0:0:0:1', 1603770467);
INSERT INTO `t_logs` VALUES (27, '删除页面', '4', 1, '0:0:0:0:0:0:0:1', 1603770633);
INSERT INTO `t_logs` VALUES (28, '删除页面', '5', 1, '0:0:0:0:0:0:0:1', 1603770638);
INSERT INTO `t_logs` VALUES (29, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603771553);
INSERT INTO `t_logs` VALUES (30, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603771553);
INSERT INTO `t_logs` VALUES (31, '删除页面', '4', 1, '0:0:0:0:0:0:0:1', 1603771857);
INSERT INTO `t_logs` VALUES (32, '删除文章', '6', 1, '0:0:0:0:0:0:0:1', 1603772028);
INSERT INTO `t_logs` VALUES (33, '删除页面', '5', 1, '0:0:0:0:0:0:0:1', 1603772035);
INSERT INTO `t_logs` VALUES (34, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603847605);
INSERT INTO `t_logs` VALUES (35, '删除附件', '/upload/2020/09/2kq8s30hfah3mom7o7epkrclg8.jpg', 1, '0:0:0:0:0:0:0:1', 1603850173);
INSERT INTO `t_logs` VALUES (36, '删除附件', '/upload/2020/09/tk2d7jmg5qgg8raa4i26kbcd14.png', 1, '0:0:0:0:0:0:0:1', 1603850178);
INSERT INTO `t_logs` VALUES (37, '删除附件', '/upload/2020/09/4bt3g3d6tmi3opapssb7muklam.jpg', 1, '0:0:0:0:0:0:0:1', 1603850204);
INSERT INTO `t_logs` VALUES (38, '删除附件', '/upload/2020/10/ov7n6vqfdijq9pq35tbsedlo4q.jpg', 1, '0:0:0:0:0:0:0:1', 1603850544);
INSERT INTO `t_logs` VALUES (39, '删除附件', '/upload/2020/10/sp0e4res3egrsr2qeva007lfc1.jpg', 1, '0:0:0:0:0:0:0:1', 1603850558);
INSERT INTO `t_logs` VALUES (40, '删除附件', '/upload/2020/10/6ftm12al44isposccb157m8iph.txt', 1, '0:0:0:0:0:0:0:1', 1603850867);
INSERT INTO `t_logs` VALUES (41, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603932699);
INSERT INTO `t_logs` VALUES (42, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603932888);
INSERT INTO `t_logs` VALUES (43, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603935131);
INSERT INTO `t_logs` VALUES (44, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603935386);
INSERT INTO `t_logs` VALUES (45, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603937603);
INSERT INTO `t_logs` VALUES (46, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603966830);
INSERT INTO `t_logs` VALUES (47, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1603975285);
INSERT INTO `t_logs` VALUES (48, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604115780);
INSERT INTO `t_logs` VALUES (49, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604118805);
INSERT INTO `t_logs` VALUES (50, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604120421);
INSERT INTO `t_logs` VALUES (51, '保存系统设置', '{\"site_record\":\"1888\",\"site_description\":\"学习交流\",\"site_title\":\"微博客\",\"site_theme\":\"jantent\",\"allow_install\":\"\"}', 1, '0:0:0:0:0:0:0:1', 1604121565);
INSERT INTO `t_logs` VALUES (52, '登录后台', NULL, 2, '0:0:0:0:0:0:0:1', 1604139825);
INSERT INTO `t_logs` VALUES (53, '登录后台', NULL, 2, '0:0:0:0:0:0:0:1', 1604139831);
INSERT INTO `t_logs` VALUES (54, '登录后台', NULL, 2, '0:0:0:0:0:0:0:1', 1604139903);
INSERT INTO `t_logs` VALUES (55, '登录后台', NULL, 2, '0:0:0:0:0:0:0:1', 1604139954);
INSERT INTO `t_logs` VALUES (56, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604140105);
INSERT INTO `t_logs` VALUES (57, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604141253);
INSERT INTO `t_logs` VALUES (58, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604142988);
INSERT INTO `t_logs` VALUES (59, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604146384);
INSERT INTO `t_logs` VALUES (60, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604147234);
INSERT INTO `t_logs` VALUES (61, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604147722);
INSERT INTO `t_logs` VALUES (62, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604149291);
INSERT INTO `t_logs` VALUES (63, '删除页面', '15', 1, '0:0:0:0:0:0:0:1', 1604151273);
INSERT INTO `t_logs` VALUES (64, '删除文章', '71', 1, '0:0:0:0:0:0:0:1', 1604152667);
INSERT INTO `t_logs` VALUES (65, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604154401);
INSERT INTO `t_logs` VALUES (66, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604154549);
INSERT INTO `t_logs` VALUES (67, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604154616);
INSERT INTO `t_logs` VALUES (68, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604154947);
INSERT INTO `t_logs` VALUES (69, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604155221);
INSERT INTO `t_logs` VALUES (70, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604155928);
INSERT INTO `t_logs` VALUES (71, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604157292);
INSERT INTO `t_logs` VALUES (72, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604158185);
INSERT INTO `t_logs` VALUES (73, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604158827);
INSERT INTO `t_logs` VALUES (74, '删除附件', '/upload/2020/09/2lqjb859mqgc2q143sgi9ausr8.txt', 1, '0:0:0:0:0:0:0:1', 1604159967);
INSERT INTO `t_logs` VALUES (75, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604201853);
INSERT INTO `t_logs` VALUES (76, '登录后台', NULL, 3, '0:0:0:0:0:0:0:1', 1604202558);
INSERT INTO `t_logs` VALUES (77, '登录后台', NULL, 2, '0:0:0:0:0:0:0:1', 1604202629);
INSERT INTO `t_logs` VALUES (78, '登录后台', NULL, 3, '0:0:0:0:0:0:0:1', 1604202697);
INSERT INTO `t_logs` VALUES (79, '登录后台', NULL, 2, '0:0:0:0:0:0:0:1', 1604212205);
INSERT INTO `t_logs` VALUES (80, '登录后台', NULL, 3, '0:0:0:0:0:0:0:1', 1604214463);
INSERT INTO `t_logs` VALUES (81, '登录后台', NULL, 3, '0:0:0:0:0:0:0:1', 1604214496);
INSERT INTO `t_logs` VALUES (82, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604215240);
INSERT INTO `t_logs` VALUES (83, '登录后台', NULL, 1, '127.0.0.1', 1604215544);
INSERT INTO `t_logs` VALUES (84, '删除页面', '14', 1, '0:0:0:0:0:0:0:1', 1604216895);
INSERT INTO `t_logs` VALUES (85, '删除页面', '8', 1, '0:0:0:0:0:0:0:1', 1604216925);
INSERT INTO `t_logs` VALUES (86, '删除页面', '8', 1, '0:0:0:0:0:0:0:1', 1604216930);
INSERT INTO `t_logs` VALUES (87, '删除页面', '8', 1, '0:0:0:0:0:0:0:1', 1604218838);
INSERT INTO `t_logs` VALUES (88, '删除页面', '10', 1, '0:0:0:0:0:0:0:1', 1604218851);
INSERT INTO `t_logs` VALUES (89, '删除页面', '12', 1, '0:0:0:0:0:0:0:1', 1604218911);
INSERT INTO `t_logs` VALUES (90, '删除页面', '7', 1, '0:0:0:0:0:0:0:1', 1604219120);
INSERT INTO `t_logs` VALUES (91, '登录后台', NULL, 3, '0:0:0:0:0:0:0:1', 1604219939);
INSERT INTO `t_logs` VALUES (92, '删除页面', '7', 3, '0:0:0:0:0:0:0:1', 1604221102);
INSERT INTO `t_logs` VALUES (93, '登录后台', NULL, 3, '0:0:0:0:0:0:0:1', 1604293823);
INSERT INTO `t_logs` VALUES (94, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604295123);
INSERT INTO `t_logs` VALUES (95, '登录后台', NULL, 1, '127.0.0.1', 1604297375);
INSERT INTO `t_logs` VALUES (96, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604297878);
INSERT INTO `t_logs` VALUES (97, '登录后台', NULL, 1, '0:0:0:0:0:0:0:1', 1604298801);
INSERT INTO `t_logs` VALUES (98, '删除页面', '14', 1, '0:0:0:0:0:0:0:1', 1604299365);
INSERT INTO `t_logs` VALUES (99, '删除页面', '6', 1, '0:0:0:0:0:0:0:1', 1604299500);

-- ----------------------------
-- Table structure for t_message
-- ----------------------------
DROP TABLE IF EXISTS `t_message`;
CREATE TABLE `t_message`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `text` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
  `author` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '热心网友' COMMENT '没有普通用户，默认热心网友',
  `createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mail` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ' ',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` tinyint(0) NULL DEFAULT 0 COMMENT '0,未通过，1通过',
  `father` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_message
-- ----------------------------
INSERT INTO `t_message` VALUES ('65a5ba7a18bd11eb8dde48ba4e8b0763', 'test3', '杨启迪', '2020-10-28 09:32:03', NULL, '39245699@qq.com', 'http://localhost:8081/message', 1, NULL);
INSERT INTO `t_message` VALUES ('ad9ba6bd18d111eb8dde48ba4e8b0763', '1234698', '12345698', '2020-10-28 11:57:13', NULL, '39245699@qq.com', 'http://localhost:8081/message', 0, NULL);
INSERT INTO `t_message` VALUES ('c338cb8d18b111eb8dde48ba4e8b0763', '测试test1', '杨启迪', '2020-10-28 08:08:46', NULL, ' 123@163.com', 'http://localhost:8081/message', 0, NULL);
INSERT INTO `t_message` VALUES ('cc9dada118b211eb8dde48ba4e8b0763', 'test2', '杨启迪', '2020-10-28 08:16:11', NULL, ' 123@163.com', 'http://localhost:8081/message', 0, NULL);

-- ----------------------------
-- Table structure for t_metas
-- ----------------------------
DROP TABLE IF EXISTS `t_metas`;
CREATE TABLE `t_metas`  (
  `mid` int unsigned NOT NULL,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `slug` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sort` int unsigned NULL,
  `parent` int unsigned NULL,
  PRIMARY KEY (`mid`) USING BTREE,
  INDEX `slug`(`slug`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_metas
-- ----------------------------
INSERT INTO `t_metas` VALUES (1, 'java', NULL, 'category', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (2, '百度', 'http://www5.baidu.com/', 'link', '', 0, 0);
INSERT INTO `t_metas` VALUES (6, '编程学习', NULL, 'category', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (7, '国际象棋', NULL, 'category', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (8, '标签1', '标签1', 'tag', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (10, '友链添加测试', 'https://gitee.com/training2020_1/weiblog/', 'link', 'https://gitee.com/static/images/logo-black.svg?t=158106664', 2, 0);
INSERT INTO `t_metas` VALUES (11, '标签添加测试', '标签添加测试', 'tag', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (12, '分类添加测试', NULL, 'category', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (13, '标签添加测试1', '标签添加测试1', 'tag', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (14, '默认分类', '默认分类', 'category', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (15, '友链添加测试001', 'https://gitee.com/training2020_1/weiblog/', 'link', 'https://gitee.com/static/images/logo-black.svg?t=158106664', 0, 0);
INSERT INTO `t_metas` VALUES (16, '友链删除测试', 'https://gitee.com/training2020_1/weiblog/', 'link', 'https://gitee.com/static/images/logo-black.svg?t=158106664', 0, 0);
INSERT INTO `t_metas` VALUES (19, '友链编辑测试', 'https://gitee.com/training2020_1/weiblog/', 'link', 'https://gitee.com/static/images/logo-black.svg?t=158106664', 0, 0);
INSERT INTO `t_metas` VALUES (20, '友链编辑测试00编辑成功', 'https://gitee.com/training2020_1/weiblog/', 'link', 'https://gitee.com/static/images/logo-black.svg?t=158106664', 0, 0);
INSERT INTO `t_metas` VALUES (21, '标签添加', '标签添加', 'tag', NULL, 0, 0);
INSERT INTO `t_metas` VALUES (22, 'IT跃迁谷', 'IT跃迁谷', 'tag', NULL, 0, 0);

-- ----------------------------
-- Table structure for t_options
-- ----------------------------
DROP TABLE IF EXISTS `t_options`;
CREATE TABLE `t_options`  (
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `value` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_options
-- ----------------------------
INSERT INTO `t_options` VALUES ('allow_install', '', NULL);
INSERT INTO `t_options` VALUES ('site_block_ips', '172.168.10', NULL);
INSERT INTO `t_options` VALUES ('site_description', '学习交流', NULL);
INSERT INTO `t_options` VALUES ('site_record', '1888', NULL);
INSERT INTO `t_options` VALUES ('site_theme', 'jantent', NULL);
INSERT INTO `t_options` VALUES ('site_title', '微博客', NULL);

-- ----------------------------
-- Table structure for t_poorusers
-- ----------------------------
DROP TABLE IF EXISTS `t_poorusers`;
CREATE TABLE `t_poorusers`  (
  `uid` int unsigned NOT NULL,
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mobile_phone` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `id_number` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'publish',
  `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'post',
  `created` int unsigned NULL,
  `poor_reason` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `enjoy_policy` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容文字',
  `info_image` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `outpoor_date` int unsigned NULL,
  PRIMARY KEY (`uid`) USING BTREE,
  UNIQUE INDEX `name`(`username`) USING BTREE,
  UNIQUE INDEX `mail`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_poorusers
-- ----------------------------
INSERT INTO `t_poorusers` VALUES (1, '张三', '2035725@qq.com', '18390007645', '431324198903240567', '38', 'publish', 'post', 1601042676, '农村户口', '很贫困', NULL, 1601042676);
INSERT INTO `t_poorusers` VALUES (2, '李四', '203515725@qq.com', '13000221133', '430322196302132556', '32', 'publish', 'post', 1601045481, '农村乡下的', '帮助他', NULL, 1601045481);
INSERT INTO `t_poorusers` VALUES (3, '用户2', '2156661550@qq.com', '', '', '18', 'publish', 'post', 1603449145, '', 'asdasdasdasd', NULL, 1603449145);
INSERT INTO `t_poorusers` VALUES (11, '用户001', '2156661550@qq,.com', '18889341995', '21111', '20', 'publish', 'post', 1603938367, '', '**个人简历\r\n个人简历**\r\n1. 个人简历个人简历\r\nv个人简历\r\n个人简历\r\n# \r\n个人简历\r\nv个人简历个人简历', NULL, 1603938367);

-- ----------------------------
-- Table structure for t_relationships
-- ----------------------------
DROP TABLE IF EXISTS `t_relationships`;
CREATE TABLE `t_relationships`  (
  `cid` int unsigned NOT NULL,
  `mid` int unsigned NOT NULL,
  PRIMARY KEY (`mid`, `cid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_relationships
-- ----------------------------
INSERT INTO `t_relationships` VALUES (7, 1);
INSERT INTO `t_relationships` VALUES (8, 1);
INSERT INTO `t_relationships` VALUES (10, 1);
INSERT INTO `t_relationships` VALUES (14, 1);
INSERT INTO `t_relationships` VALUES (7, 3);
INSERT INTO `t_relationships` VALUES (8, 3);
INSERT INTO `t_relationships` VALUES (12, 6);
INSERT INTO `t_relationships` VALUES (12, 11);
INSERT INTO `t_relationships` VALUES (13, 13);
INSERT INTO `t_relationships` VALUES (13, 14);
INSERT INTO `t_relationships` VALUES (14, 21);
INSERT INTO `t_relationships` VALUES (10, 22);

-- ----------------------------
-- Table structure for t_users
-- ----------------------------
DROP TABLE IF EXISTS `t_users`;
CREATE TABLE `t_users`  (
  `uid` int unsigned NOT NULL,
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `home_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `screen_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `created` int unsigned NULL,
  `activated` int unsigned NULL,
  `logged` int unsigned NULL,
  `group_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'visitor',
  PRIMARY KEY (`uid`) USING BTREE,
  UNIQUE INDEX `name`(`username`) USING BTREE,
  UNIQUE INDEX `mail`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_users
-- ----------------------------
INSERT INTO `t_users` VALUES (1, 'admin', 'a66abb5684c45962d887564f08346e8d', 'default@qq.com', NULL, 'admin', 1490756162, 0, 0, 'visitor');
INSERT INTO `t_users` VALUES (2, 'lyw', 'a587ac24b073c836371c55570b7b56bf', '2156661550@qq.com', '', NULL, 0, 0, 0, 'visitor');
INSERT INTO `t_users` VALUES (3, '罗雅文', 'a0ae5ca1c3a38c3b57940f0759abcc2d', '2156661552@qq.com', NULL, '', 1490756162, 0, 0, 'visitor');
INSERT INTO `t_users` VALUES (4, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 'visitor');

SET FOREIGN_KEY_CHECKS = 1;