| id |
mediumint(8)
|
|
|
|
| file |
varchar(255)
|
utf8_bin
|
|
|
| date_available |
datetime
|
|
|
|
| date_creation |
datetime
|
|
|
|
| name |
varchar(255)
|
utf8_general_ci
|
|
|
| comment |
text
|
utf8_general_ci
|
|
|
| author |
varchar(255)
|
utf8_general_ci
|
|
|
| hit |
int(10)
|
|
|
|
| filesize |
mediumint(9)
|
|
|
|
| width |
smallint(9)
|
|
|
|
| height |
smallint(9)
|
|
|
|
| coi |
char(4)
|
utf8_general_ci
|
|
|
| representative_ext |
varchar(4)
|
utf8_general_ci
|
|
|
| date_metadata_update |
date
|
|
|
|
| rating_score |
float(5,2)
|
|
|
|
| path |
varchar(255)
|
utf8_general_ci
|
|
|
| storage_category_id |
smallint(5)
|
|
|
|
| level |
tinyint(3)
|
|
|
|
| md5sum |
char(32)
|
utf8_general_ci
|
|
|
| added_by |
mediumint(8)
|
|
|
|
| rotation |
tinyint(3)
|
|
|
|
| latitude |
double(8,6)
|
|
|
|
| longitude |
double(9,6)
|
|
|
|
| lastmodified |
timestamp
|
|
|
|
