| ref |
int(11)
|
|
|
|
| title |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| resource_type |
int(11)
|
|
|
|
| has_image |
int(11)
|
|
|
|
| is_transcoding |
int(11)
|
|
|
|
| hit_count |
int(11)
|
|
|
|
| new_hit_count |
int(11)
|
|
|
|
| creation_date |
datetime
|
|
|
|
| rating |
int(11)
|
|
|
|
| user_rating |
int(11)
|
|
|
|
| user_rating_count |
int(11)
|
|
|
|
| user_rating_total |
int(11)
|
|
|
|
| country |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| file_extension |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| preview_extension |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| image_red |
int(11)
|
|
|
|
| image_green |
int(11)
|
|
|
|
| image_blue |
int(11)
|
|
|
|
| thumb_width |
int(11)
|
|
|
|
| thumb_height |
int(11)
|
|
|
|
| archive |
int(11)
|
|
|
|
| access |
int(11)
|
|
|
|
| colour_key |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| file_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| file_modified |
datetime
|
|
|
|
| file_checksum |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| request_count |
int(11)
|
|
|
|
| expiry_notification_sent |
int(11)
|
|
|
|
| preview_tweaks |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| geo_lat |
double
|
|
|
|
| geo_long |
double
|
|
|
|
| mapzoom |
int(11)
|
|
|
|
| disk_usage |
bigint(20)
|
|
|
|
| disk_usage_last_updated |
datetime
|
|
|
|
| file_size |
bigint(20)
|
|
|
|
| preview_attempts |
int(11)
|
|
|
|
| modified |
timestamp
|
|
|
|
| last_verified |
datetime
|
|
|
|
| integrity_fail |
tinyint(1)
|
|
|
|
| lock_user |
int(11)
|
|
|
|
| no_file |
tinyint(1)
|
|
|
|
| field12 |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| field8 |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| field3 |
varchar(200)
|
utf8mb4_general_ci
|
|
|
