GitLab

CREATE TABLE `wiki`.`tb_company_comments` ( `id` BIGINT(20) NOT NULL , `company_name_digest` VARCHAR(64) NOT NULL , `user_id` BIGINT(20) NOT NULL , `star` INT(11) NOT NULL , `content` VARCHAR(2400) NOT NULL , `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `lastupdatetime` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `status` TINYINT(2) NOT NULL DEFAULT '0' , PRIMARY KEY (`id`), INDEX (`company_name_digest`), INDEX (`user_id`)) ENGINE = InnoDB;


ALTER TABLE `tb_company_comments` CHANGE `status` `status` TINYINT(2) NOT NULL DEFAULT '0' AFTER `user_id`;


CREATE TABLE `wiki`.`tb_company_comments_good` ( `id` BIGINT(20) NOT NULL , `cid` BIGINT(20) NOT NULL , `user_id` BIGINT(20) NOT NULL , `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `lastupdatetime` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`), INDEX (`cid`), INDEX (`user_id`)) ENGINE = InnoDB;

ALTER TABLE `tb_company_comments` ADD `good_count` INT(11) NOT NULL DEFAULT '0' AFTER `star`;



CREATE TABLE `wiki`.`tb_user_info_verify` ( `user_id` BIGINT(20) NOT NULL , `nick_name` VARCHAR(255) NOT NULL , `nick_name_tmp` VARCHAR(255) NOT NULL , `avatar` VARCHAR(500) NOT NULL , `avatar_tmp` VARCHAR(500) NOT NULL , `nick_name_status` INT(11) NOT NULL , `avatar_status` INT(11) NOT NULL , `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `lastupdatetime` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`user_id`)) ENGINE = InnoDB;


ALTER TABLE `tb_company_comments` CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `tb_company_comments_good` CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `tb_user_info_verify` ADD `nick_name_msg` VARCHAR(2500) NOT NULL DEFAULT '' AFTER `nick_name_tmp`;
ALTER TABLE `tb_user_info_verify` ADD `avatar_msg` VARCHAR(2500) NOT NULL DEFAULT '' AFTER `avatar_tmp`;
ALTER TABLE `tb_company_comments` ADD `msg` VARCHAR(2500) NOT NULL DEFAULT '' AFTER `content`;
CREATE TABLE `wiki`.`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 , `lastupdatetime` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`)) ENGINE = InnoDB;

CREATE TABLE `wiki`.`tb_comments_reply` ( `cid` BIGINT(20) NOT NULL , `content` VARCHAR(2500) NOT NULL , `status` INT(2) NOT NULL DEFAULT '1' , `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `lastupdatetime` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`cid`)) ENGINE = InnoDB;

ALTER TABLE `tb_comments_reply` ADD `user_id` BIGINT(20) NOT NULL AFTER `cid`;


ALTER TABLE `tb_user_info_verify` CHANGE `avatar_msg` `avatar_msg` VARCHAR(2500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE `tb_company_comments` CHANGE `status` `status` TINYINT(2) NOT NULL DEFAULT '1';