GitLab

mysql变更格式

数据库：ucs

表名：tb_credit_circle_operations

sql：

CREATE TABLE `tb_credit_circle_operations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(32) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `company_name_digest` varchar(32) NOT NULL,
  `message_id` int(11) NOT NULL,
  `add_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