Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

数据库脚本有吗? #1

Open
ocean-zhc opened this issue Jun 28, 2023 · 1 comment
Open

数据库脚本有吗? #1

ocean-zhc opened this issue Jun 28, 2023 · 1 comment

Comments

@ocean-zhc
Copy link

No description provided.

@robinsyn
Copy link
Owner

robinsyn commented Jul 1, 2023

你试试下面这个是否可以

DROP TABLE IF EXISTS sys_upload_task;
CREATE TABLE sys_upload_task (
id bigint NOT NULL,
upload_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分片上传的uploadId',
file_identifier varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件唯一标识(md5)',
file_name varchar(500) COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名',
bucket_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所属桶名',
object_key varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件的key',
total_size bigint NOT NULL COMMENT '文件大小(byte)',
chunk_size bigint NOT NULL COMMENT '每个分片大小(byte)',
chunk_num int NOT NULL COMMENT '分片数量',
PRIMARY KEY (id),
UNIQUE KEY uq_file_identifier (file_identifier) USING BTREE,
UNIQUE KEY uq_upload_id (upload_id) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='分片上传-分片任务记录';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants