Below is I'm in the design of table
The create table tb_file
(
File_id bigint not null PRIMARY KEY AUTO_INCREMENT,
File_name text (255) not null,
File_size bigint not null,
File_type bigint not null,
File_status int the not null,
File_upload_time text not null,
File_hash_md5 text (128),
File_hash_sha256 text (256),
The index index_file_name (file_name (250)),
The index index_file_status (file_status),
The index index_file_hash_md5 (file_hash_md5 (128)),
The index index_file_hash_sha256 (file_hash_sha256 (250)),
The unique index_file_hash_md5_sha256 (file_hash_md5 (128), file_hash_sha256 (122))
) AUTO_INCREMENT=10000 ENGINE=InnoDB CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=Dynamic;