Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| id | generated index | int(10) unsigned | NO | PRI | NULL | auto_increment |
| aid | account_id of owner | int(10) unsigned | NO | MUL | 0 | |
| uid | channel_id of owner | int(10) unsigned | NO | MUL | 0 | |
| hash | hash for cross-site identification | char(64) | NO | MUL | ||
| creator | xchan_hash of author/creator | char(128) | NO | MUL | ||
| filename | filename of original | char(255) | NO | MUL | ||
| filetype | mimetype | char(64) | NO | MUL | ||
| filesize | size in bytes | int(10) unsigned | NO | MUL | 0 | |
| revision | for version control (partially implemented) | int(10) unsigned | NO | MUL | 0 | |
| folder | attach.hash of parent folder | char(64) | NO | MUL | ||
| flags | no longer used | int(10) unsigned | NO | MUL | 0 | |
| is_dir | 0 (file) or 1 to indicate a directory | tinyint | NO | MUL | 0 | |
| is_photo | if 1, a photo is linked to this resource | tinyint | NO | MUL | 0 | |
| os_storage | if 0, data contains content; if 1 data contains path to content (always 1 in hubzilla) | tinyint | NO | MUL | 0 | |
| os_path | under construction, store the system path | mediumtext | NO | MUL | 0 | |
| display_path | under construction, store the human readable path | mediumtext | NO | MUL | 0 | |
| content | file data or pathname to stored data if ATTACH_FLAG_OS | longblob | NO | NULL | ||
| created | creation time | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| edited | last edit time | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| allow_cid | permissions | mediumtext | NO | NULL | ||
| allow_gid | permissions | mediumtext | NO | NULL | ||
| deny_cid | permissions | mediumtext | NO | NULL | ||
| deny_gid | permissions | mediumtext | NO | NULL |
permissions are xchan_hash or group_hash surrounded by angle chars. e.g. '<abc123><xyz789>'
Return to database documentation