| 123456789101112131415161718192021222324252627 |
- # /**
- # Source Server Version: 8.0.31
- # Source Database: backendsys
- # Date: 2023/05/23 17:09:22
- # */
- #
- # DROP TABLE IF EXISTS `sys_file`;
- # CREATE TABLE `sys_file` (
- # PRIMARY KEY (`id`),
- # `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
- # `category_id` BIGINT COMMENT '分类ID',
- # `user_id` BIGINT COMMENT '拥有者',
- # `name` VARCHAR(255) NOT NULL COMMENT '文件名称',
- # `file_local_path` VARCHAR(255) COMMENT '本地路径',
- # `file_remote_path` VARCHAR(255) COMMENT '远程路径',
- # `file_remote_path_thumb` VARCHAR(255) COMMENT '远程路径 (缩略图)',
- # `file_key` VARCHAR(255) COMMENT '腾讯云COS路径',
- # `size` INT COMMENT '文件大小',
- # `md5` VARCHAR(255) COMMENT '文件MD5',
- # `chunk_upload_id` VARCHAR(255) COMMENT '文件分片任务ID',
- # `chunk_count` INT COMMENT '文件分片数量',
- # `chunk_current_index` INT COMMENT '当前文件分片索引',
- # `notes` VARCHAR(255) COMMENT '备注',
- # `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- # `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
- # ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统文件表';
- #
|
