fud30_pmsg
Description of FUDforum table fud30_pmsg. This table tracks users' private messages.
| 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). |
| 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 |
- 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)
- 0 PROC
- 1 INBOX
- 2 SAVED
- 3 SENT
- 4 DRAFT
- 5 TRASH
