17 lines
953 B
SQL
17 lines
953 B
SQL
CREATE TABLE `health`.`ufutx_s2_depoly_version` (
|
|
`id` BIGINT NOT NULL AUTO_INCREMENT ,
|
|
`appname` VARCHAR(512) NOT NULL COMMENT '应用名' ,
|
|
`filepath` VARCHAR(512) NOT NULL COMMENT '文件路径' ,
|
|
`filesize` BIGINT NOT NULL DEFAULT '0' COMMENT '文件尺寸, 单位kb' ,
|
|
`desc` VARCHAR(1024) NOT NULL COMMENT '简要说明' ,
|
|
`duration_total` BIGINT NOT NULL DEFAULT '0' COMMENT '总运行时间' ,
|
|
`duration_curr` BIGINT NOT NULL DEFAULT '0' COMMENT '上线后运行时间' ,
|
|
`status` TINYINT NOT NULL DEFAULT '1' COMMENT '状态,1=闲置, 2=在线' ,
|
|
`user_create` INT NOT NULL COMMENT '创建用户id' ,
|
|
`user_update` INT NOT NULL COMMENT '最后操作用户id' ,
|
|
`created_at` TIMESTAMP NULL DEFAULT NULL ,
|
|
`updated_at` TIMESTAMP NULL DEFAULT NULL ,
|
|
`deleted_at` TIMESTAMP NULL DEFAULT NULL ,
|
|
`online_at` TIMESTAMP NULL DEFAULT NULL ,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB; |