GitLab

mysql变更格式

数据库：ucs

表名：tb_keyword_ad 表名：tb_keyword_ad_map

sql：

CREATE TABLE `tb_keyword_ad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name_digest` varchar(32) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1有效2无效',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_company_name_digest` (`company_name_digest`),
  KEY `ix_keyword` (`keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `tb_keyword_ad_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name_digest` varchar(32) NOT NULL,
  `path` varchar(1000) DEFAULT NULL,
  `recommend_word` varchar(1000) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表有效2代表无效',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8