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 | see notes | int(10) unsigned | NO | MUL | 0 | |
data | 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 |
Bitmasks
define ( 'ATTACH_FLAG_DIR', 0x0001); This is a directory
define ( 'ATTACH_FLAG_OS', 0x0002); Data content is link to OS file containing data, if unset the data filed contains the file data
permissions are xchan_hash or group_hash surrounded by angle chars. e.g. '<abc123><xyz789>'
Return to database documentation