|
|
rowid |
int(11)
|
|
|
|
|
|
ref |
varchar(128)
|
utf8_unicode_ci
|
|
|
|
|
label |
varchar(128)
|
utf8_unicode_ci
|
|
|
|
|
share |
varchar(128)
|
utf8_unicode_ci
|
|
|
|
|
share_pass |
varchar(32)
|
utf8_unicode_ci
|
|
|
|
|
entity |
int(11)
|
|
|
|
|
|
filepath |
varchar(255)
|
utf8_unicode_ci
|
|
|
|
|
filename |
varchar(255)
|
utf8_unicode_ci
|
|
|
|
|
src_object_type |
varchar(64)
|
utf8_unicode_ci
|
|
|
|
|
src_object_id |
int(11)
|
|
|
|
|
|
agenda_id |
int(11)
|
|
|
|
|
|
fullpath_orig |
varchar(750)
|
utf8_unicode_ci
|
|
|
|
|
description |
varchar(255)
|
utf8_unicode_ci
|
|
|
|
|
keywords |
varchar(750)
|
utf8_unicode_ci
|
|
|
|
|
content |
text
|
utf8_unicode_ci
|
|
|
|
|
cover |
varchar(32)
|
utf8_unicode_ci
|
|
|
|
|
position |
int(11)
|
|
|
|
|
|
gen_or_uploaded |
varchar(12)
|
utf8_unicode_ci
|
|
|
|
|
extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
|
|
date_c |
datetime
|
|
|
|
|
|
tms |
timestamp
|
|
|
|
|
|
fk_user_c |
int(11)
|
|
|
|
|
|
fk_user_m |
int(11)
|
|
|
|
|
|
note_private |
text
|
utf8_unicode_ci
|
|
|
|
|
note_public |
text
|
utf8_unicode_ci
|
|
|
|
|
acl |
text
|
utf8_unicode_ci
|
|
|
|
|
geolat |
double(24,8)
|
|
|
|
|
|
geolong |
double(24,8)
|
|
|
|
|
|
geopoint |
point
|
|
|
 Bearbeiten/Einfügen
|
|
|
georesultcode |
varchar(16)
|
utf8_unicode_ci
|
|
|
