Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

数据库加表

mysql变更格式

数据库：ucs

表名：tb_company_export_log

sql：

CREATE TABLE `tb_company_export_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `params` varchar(225) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表未发送，2代表发送成功，3代表发送失败',
  `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