导入文件管理表结构-向日葵屋

导入文件管理表结构

导入文件管理
CREATE TABLE `archives_car_baseinfo_record` (
  `id` bigint(8) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `source_file_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '源文件',
  `error_file_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '本次错误文件',
 `state` tinyint(4) DEFAULT NULL COMMENT '状态 0 同步中 1 已同步 2 同步失败 3 不需要同步',
`task_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务id',
`type` tinyint(4) DEFAULT NULL COMMENT '类型 0 车辆信息 1 销售信息',
  `creater` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(4) DEFAULT NULL COMMENT '删除标示 0 无 1 删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `archives_car_baseinfo_record`
ADD COLUMN `source_file_object_name`  varchar(255) NULL COMMENT '源文件objectname' AFTER `error_file_url`,
ADD COLUMN `error_file_object_name`  varchar(255) NULL COMMENT '失败文件object name' AFTER `source_file_object_name`,
ADD COLUMN `file_name`  varchar(255) NULL COMMENT '文件名称' AFTER `error_file_object_name`,
ADD COLUMN `success_size`  int(4) NULL COMMENT '成功数量' AFTER `file_name`,
ADD COLUMN `fail_size`  int(4) NULL COMMENT '失败数量' AFTER `success_size`,
ADD COLUMN `file_size`  varchar(255) NULL COMMENT '文件大小' AFTER `fail_size`;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `archives_car_baseinfo_record`
-- ----------------------------
DROP TABLE IF EXISTS `archives_car_baseinfo_record`;
CREATE TABLE `archives_car_baseinfo_record` (
  `id` bigint(8) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `source_file_url` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '婧愭枃浠?',
  `error_file_url` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '鏈閿欒鏂囦欢',
  `source_file_object_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '源文件objectname',
  `error_file_object_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '失败文件object name',
  `file_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件名称',
  `success_size` int(4) DEFAULT NULL COMMENT '成功数量',
  `fail_size` int(4) DEFAULT NULL COMMENT '失败数量',
  `file_size` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件大小',
  `state` tinyint(4) DEFAULT NULL COMMENT '''状态 0 同步中 1 已同步 2 同步失败 3 不需要同步'',', `task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务id', `type` tinyint(4) DEFAULT NULL COMMENT '类型 0 车辆信息  1 销售信息', `creater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) DEFAULT '0' COMMENT '鍒犻櫎鏍囩ず 0 鏃? 1 鍒犻櫎', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- ---------------------------- -- Records of archives_car_baseinfo_record -- ---------------------------- INSERT INTO `archives_car_baseinfo_record` VALUES ('1', '1231213', '131313', '1313213', '1313', '1312312', '313123', '13123', '3123', '1', '13131', '1', '321', '2020-08-25 16:51:01', '1', '2020-08-25 16:51:04', '0');