GitLab

数据库：wiki

表名：tb_company_comments

CREATE TABLE `tb_company_comments` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_name_digest` varchar(64) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '1',
  `star` int(11) NOT NULL,
  `good_count` int(11) unsigned NOT NULL DEFAULT '0',
  `content` varchar(2400) NOT NULL,
  `msg` varchar(2500) NOT NULL DEFAULT '' COMMENT '审核不通过信息',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `company_name_digest` (`company_name_digest`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

数据库：wiki

表名：tb_company_comments_good

CREATE TABLE `tb_company_comments_good` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cid` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

数据库：wiki

表名：tb_comments_reply

CREATE TABLE `tb_comments_reply` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cid` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `replied_id` bigint(20) NOT NULL DEFAULT '0',
  `content` varchar(2500) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

数据库：wiki

表名：tb_comments_repost

CREATE TABLE `tb_comments_repost` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cid` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `content` varchar(500) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(2) NOT NULL DEFAULT '1',
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;