Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

添加表tb_certification_contact

mysql变更格式

数据库：ucs

表名：tb_certification_contact

sql：

CREATE TABLE `tb_certification_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(128) DEFAULT NULL,
  `web_domain` varchar(128) DEFAULT NULL,
  `status` smallint(1) NOT NULL DEFAULT '1' COMMENT '1代表用户刚提交，2代表已经联系过',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lasterupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_certification_contact_phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8