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