Description of FUDforum table fud30_attach. This table tracks files that are attached to messages. The Attachment Pruning ACP can be used to delete old attachments.
Fields
Column Name | Datatype | Can be Null? | Key? | Default | Description
|
id | int(11) | NO | PRI | | auto_increment
|
location | varchar(255) | NO | | | Path to attachment on disk.
|
original_name | varchar(255) | YES | | | Attachment's file name.
|
owner | int(11) | NO | | 0 | References fud30_users.id.
|
attach_opt | int(11) | NO | | 0 | Attachment options.
|
message_id | int(11) | NO | MUL | 0 | References fud30_msg.id.
|
dlcount | int(11) | NO | | 0 | Download counter.
|
mime_type | int(11) | NO | | 0 | References fud30_mime.id.
|
fsize | int(11) | NO | | 0 | Attached file size.
|
Keys
Index Name | Uniqueness | Column Name | Seq in index | Comments
|
PRIMARY | UNIQUE | id | 1 |
|
fud30_attach_i_mp | NOT UNIQUE | message_id | 1 |
|
fud30_attach_i_mp | NOT UNIQUE | attach_opt | 2 |
|