Fud30 pmsg

From FUDforum Wiki
Jump to: navigation, search

Description of FUDforum table fud30_pmsg. This table tracks users' private messages.

Contents

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

fud30_action log | fud30_ann forums | fud30_announce | fud30_attach | fud30_avatar | fud30_blocked_logins | fud30_bookmarks | fud30_buddy | fud30_calendar | fud30_cat | fud30_custom_fields | fud30_custom_tags | fud30_email_block | fud30_ext_block | fud30_fc_view | fud30_fl_1 | fud30_fl_pg | fud30_fl_pm | fud30_forum | fud30_forum_notify | fud30_forum_read | fud30_geoip | fud30_group_cache | fud30_group_members | fud30_group_resources | fud30_groups | fud30_index | fud30_ip_block | fud30_jobs | fud30_level | fud30_mime | fud30_mlist | fud30_mod | fud30_msg | fud30_msg_report | fud30_msg_store | fud30_nntp | fud30_pages | fud30_plugins | fud30_pmsg | fud30_poll | fud30_poll_opt | fud30_poll_opt_track | fud30_read | fud30_replace | fud30_search | fud30_search cache | fud30_ses | fud30_smiley | fud30_spiders | fud30_stats_cache | fud30_themes | fud30_thr_exchange | fud30_thread | fud30_thread_notify | fud30_thread_rate_track | fud30_title_index | fud30_tv_1 | fud30_user_ignore | fud30_users | fud30_xmlagg

Languages
Personal tools