SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for comments_info
-- ----------------------------
DROP TABLE IF EXISTS `comments_info`;
CREATE TABLE `comments_info` (
  `in_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '評論主鍵id',
  `good_id` int(10) NOT NULL COMMENT '被評論物品gid',
  `from_openid` varchar(32) NOT NULL COMMENT '評論者id',
  `from_name` varchar(32) NOT NULL COMMENT '評論者名字',
  `from_avatar` varchar(512) DEFAULT '' COMMENT '評論者頭像',
  `like_num` int(11) DEFAULT '0' COMMENT '點贊的數(shù)量',
  `content` varchar(512) DEFAULT NULL COMMENT '評論內(nèi)容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
  `user_state` int(3) DEFAULT NULL COMMENT '用戶是否認證',
  PRIMARY KEY (`in_id`),
  KEY `owner_id` (`good_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COMMENT='評論主表';

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for comments_reply
-- ----------------------------
DROP TABLE IF EXISTS `comments_reply`;
CREATE TABLE `comments_reply` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(10) NOT NULL COMMENT '評論主表id',
  `from_openid` varchar(32) NOT NULL COMMENT '評論者id',
  `from_name` varchar(32) NOT NULL COMMENT '評論者名字',
  `from_avatar` varchar(512) DEFAULT '' COMMENT '評論者頭像',
  `to_openid` varchar(32) NOT NULL COMMENT '被評論者id',
  `to_name` varchar(32) NOT NULL COMMENT '被評論者名字',
  `to_avatar` varchar(512) DEFAULT '' COMMENT '被評論者頭像',
  `content` varchar(512) DEFAULT NULL COMMENT '評論內(nèi)容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
  `like_num` int(11) DEFAULT NULL COMMENT '點贊',
  `user_state` int(3) DEFAULT NULL COMMENT '用戶是否認證',
  PRIMARY KEY (`rid`),
  KEY `comment_id` (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COMMENT='評論回復(fù)表';