导入文件管理表结构

左手的ㄟ右手 2022-12-01 03:46 101阅读 0赞

导入文件管理
    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');