Directory Help Language Random Channel Report Bug Search Support Hubzilla

Hubzilla Documentation:

Contents



FieldDescriptionTypeNullKeyDefaultExtra
idgenerated indexint(10) unsignedNOPRINULLauto_increment
aidaccount_id of ownerint(10) unsignedNOMUL0
uidchannel_id of ownerint(10) unsignedNOMUL0
hashhash for cross-site identificationchar(64)NOMUL
creatorxchan_hash of author/creatorchar(128)NOMUL
filenamefilename of originalchar(255)NOMUL
filetypemimetypechar(64)NOMUL
filesizesize in bytesint(10) unsignedNOMUL0
revisionfor version control (partially implemented)int(10) unsignedNOMUL0
folderattach.hash of parent folderchar(64)NOMUL
flagsno longer usedint(10) unsignedNOMUL0
is_dir0 (file) or 1 to indicate a directorytinyintNOMUL0
is_photoif 1, a photo is linked to this resourcetinyintNOMUL0
os_storageif 0, data contains content; if 1 data contains path to content (always 1 in hubzilla)tinyintNOMUL0
os_pathunder construction, store the system pathmediumtextNOMUL0
display_pathunder construction, store the human readable pathmediumtextNOMUL0
contentfile data or pathname to stored data if ATTACH_FLAG_OSlongblobNONULL
createdcreation timedatetimeNOMUL0000-00-00 00:00:00
editedlast edit timedatetimeNOMUL0000-00-00 00:00:00
allow_cidpermissionsmediumtextNONULL
allow_gidpermissionsmediumtextNONULL
deny_cidpermissionsmediumtextNONULL
deny_gidpermissionsmediumtextNONULL


permissions are xchan_hash or group_hash surrounded by angle chars. e.g. '<abc123><xyz789>'

Return to database documentation