Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

数据库加表

mysql变更格式

数据库：suqian

表名：disclose_reply

sql：

CREATE TABLE `disclose_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `disclose_id` int(11) NOT NULL COMMENT '爆料记录的id',
  `contents` varchar(510) NOT NULL COMMENT '回复的内容',
  `path` varchar(1000) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表有效',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_disclose_id` (`disclose_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8