Friendica Communications Platform (please note that this is a clone of the repository at github, issues are handled there) https://friendi.ca
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

2.2 KiB

Table attach

Field Description Type Null Key Default Extra
id generated index int(11) NO PRI NULL auto_increment
uid user_id of owner int(11) NO 0
hash hash varchar(64) NO
filename filename of original varchar(255) NO
filetype mimetype varchar(64) NO
filesize size in bytes int(11) NO 0
data file data longblob NO NULL
created creation time datetime NO 0001-01-01 00:00:00
edited last edit time datetime NO 0001-01-01 00:00:00
allow_cid Access Control - list of allowed contact.id '<19><78> mediumtext NO NULL
allow_gid Access Control - list of allowed groups mediumtext NO NULL
deny_cid Access Control - list of denied contact.id mediumtext NO NULL
deny_gid Access Control - list of denied groups mediumtext NO NULL

Notes: Permissions are surrounded by angle chars. e.g. <4>

Return to database documentation