text: /*
   Navicat MySQL Data Transfer
  
   Source Server         : mysql
   Source Server Type    : MySQL
   Source Server Version : 80020
   Source Host           : localhost:3306
   Source Schema         : phpmyblog
  
   Target Server Type    : MySQL
   Target Server Version : 80020
   File Encoding         : 65001
  
   Date: 26/05/2021 20:38:23
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for zh_user_comments
  -- ----------------------------
  DROP TABLE IF EXISTS `zh_user_comments`;
  CREATE TABLE `zh_user_comments`  (
    `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `user_id` int(0) NULL DEFAULT NULL COMMENT '用户主键',
    `art_id` int(0) NULL DEFAULT NULL COMMENT '文档主键',
    `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '评论内容',
    `reply_id` int(0) NULL DEFAULT NULL COMMENT '回复ID',
    `status` int(0) NULL DEFAULT 1 COMMENT '状态1启用0隐藏',
    `create_time` int(0) NULL DEFAULT NULL COMMENT '创建时间',
    `update_time` int(0) NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评论表' ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  