HkZQweHF

1CREATE TABLE IF NOT EXISTS Publication (
2    `file_id` INT,
3    `file_name_hashcode` VARCHAR(32) CHARACTER SET utf8,
4    `file_title` VARCHAR(37) CHARACTER SET utf8,
5    `user_id` VARCHAR(12) CHARACTER SET utf8,
6    `file_name` VARCHAR(37) CHARACTER SET utf8,
7    `file_description` VARCHAR(22) CHARACTER SET utf8,
8    `file_type` VARCHAR(73) CHARACTER SET utf8,
9    `tag` VARCHAR(10) CHARACTER SET utf8,
10    `file_size` VARCHAR(12) CHARACTER SET utf8,
11    `file_path` VARCHAR(50) CHARACTER SET utf8,
12    `file_extension` VARCHAR(4) CHARACTER SET utf8,
13    `category` VARCHAR(3) CHARACTER SET utf8,
14    `accessibility` VARCHAR(3) CHARACTER SET utf8,
15    `uploader_id` VARCHAR(5) CHARACTER SET utf8,
16    `file_status` VARCHAR(2) CHARACTER SET utf8,
17    `encrypted` VARCHAR(2) CHARACTER SET utf8,
18    `file_details` VARCHAR(1) CHARACTER SET utf8,
19    `created_at` DATETIME,
20    `updated_at` DATETIME
21);