/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50648
 Source Host           : localhost:3306
 Source Schema         : comment_sys

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

 Date: 26/08/2021 19:18:26
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_comment
-- ----------------------------
DROP TABLE IF EXISTS `tb_comment`;
CREATE TABLE `tb_comment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `reply_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `parent_id` int(11) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_comment
-- ----------------------------
INSERT INTO `tb_comment` VALUES (1, '老罗', NULL, '文章写得真好，收藏了', NULL, '2021-08-10 09:04:35');
INSERT INTO `tb_comment` VALUES (2, '新手小王', '老罗', '确实写的不错', 1, '2021-08-21 09:04:40');
INSERT INTO `tb_comment` VALUES (3, '巴菲特', NULL, '好好学习，天天向上', NULL, '2021-08-24 09:04:46');
INSERT INTO `tb_comment` VALUES (4, '光头披风侠', '新手小王', '我觉得还有进步空间', 1, '2021-08-25 09:04:29');
INSERT INTO `tb_comment` VALUES (5, '小李子', '巴菲特', '海阔凭鱼跃嘛：）', 3, '2021-08-26 09:05:26');
INSERT INTO `tb_comment` VALUES (8, '冲冲冲', NULL, '校学术规范委员会依据2017年《复旦大学学术规范实施条例（试行）》的有关程序开展调查核实工作，根据原上海医科大学1999年1月修订的《科研型博士研究生培养工作细则》，认定张文宏博士学位论文符合当年博士', NULL, '2021-08-25 19:42:17');
INSERT INTO `tb_comment` VALUES (9, 'aaa', NULL, 'bbb', NULL, '2021-08-26 14:54:54');
INSERT INTO `tb_comment` VALUES (11, '驱动骑士', NULL, '一拳超人还要强', NULL, '2021-08-26 15:02:33');
INSERT INTO `tb_comment` VALUES (12, '披风侠a', NULL, '味道好极了', NULL, '2021-08-26 15:32:49');
INSERT INTO `tb_comment` VALUES (13, 'bbb', NULL, '回复你了', NULL, '2021-08-26 15:37:55');
INSERT INTO `tb_comment` VALUES (14, 'www', NULL, 'www', NULL, '2021-08-26 15:40:09');
INSERT INTO `tb_comment` VALUES (15, '光头强', NULL, '小李子加油！！！', NULL, '2021-08-26 15:46:19');
INSERT INTO `tb_comment` VALUES (16, '666', '小李子', '小李子加油', 3, '2021-08-26 15:46:49');
INSERT INTO `tb_comment` VALUES (18, '熊大', '巴菲特', '他来了', 3, '2021-08-26 15:47:56');

SET FOREIGN_KEY_CHECKS = 1;