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