Description of FUDforum table fud30_pmsg. This table tracks users' private messages.
Fields
| Column Name | Datatype | Can be Null? | Key? | Default | Description
|
| id | int(11) | NO | PRI | | auto_increment
|
| to_list | text | YES | | |
|
| ouser_id | int(11) | NO | | 0 | References fud30_users.id.
|
| duser_id | int(11) | NO | MUL | 0 | References fud30_users.id.
|
| pdest | int(11) | NO | | 0 |
|
| ip_addr | varchar(15) | NO | | 0.0.0.0 |
|
| host_name | varchar(255) | YES | | |
|
| post_stamp | bigint(20) | NO | | 0 | Date/time posted.
|
| read_stamp | bigint(20) | NO | | 0 | Date/time read.
|
| icon | varchar(100) | YES | | | Icon to display next to PM.
|
| subject | varchar(100) | NO | | | PM's subject.
|
| attach_cnt | int(11) | NO | | 0 | Number of attachments.
|
| foff | bigint(20) | NO | | 0 | File where PM's body is stored.
|
| length | int(11) | NO | | 0 | Message length.
|
| ref_msg_id | varchar(11) | YES | | |
|
| fldr | int(11) | NO | | 0 | Folder (see below).
|
| pmsg_opt | int(11) | NO | | 49 | Options (see below).
|
Keys
| Index Name | Uniqueness | Column Name | Seq in index | Comments
|
| PRIMARY | UNIQUE | id | 1 |
|
| fud30_pmsg_i_dfr | NOT UNIQUE | duser_id | 1 |
|
| fud30_pmsg_i_dfr | NOT UNIQUE | fldr | 2 |
|
| fud30_pmsg_i_dfr | NOT UNIQUE | read_stamp | 3 |
|
| fud30_pmsg_i_dfi | NOT UNIQUE | duser_id | 1 |
|
| fud30_pmsg_i_dfi | NOT UNIQUE | fldr | 2 |
|
| fud30_pmsg_i_dfi | NOT UNIQUE | id | 3 |
|
Options
- 1 = show_sig
- 2 = smiley_disabled
- 4 = track
- 8 = track SENT
- 16 = mailed
- 32 = nrf_status N (new message - top level)
- 64 = nrf_status R/F (a reply/ forwarded message)
Folders
- 0 PROC
- 1 INBOX
- 2 SAVED
- 3 SENT
- 4 DRAFT
- 5 TRASH