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