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 |
|