Description of FUDforum table fud30_mlist. This table is used to track mailing lists that are synced with the forum. For more information, see Mailing List Manager.
|
Column Name
|
Datatype
|
Can be Null?
|
Key?
|
Default
|
Description
|
|
id
|
int(11)
|
NO
|
PRI
|
-
|
auto_increment
|
|
forum_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_forum.id.
|
|
name
|
varchar(255)
|
NO
|
-
|
-
|
Mailing list name.
|
|
subject_regex_haystack
|
text
|
YES
|
-
|
-
|
|
|
subject_regex_needle
|
text
|
YES
|
-
|
-
|
|
|
body_regex_haystack
|
text
|
YES
|
-
|
-
|
|
|
body_regex_needle
|
text
|
YES
|
-
|
-
|
|
|
additional_headers
|
text
|
YES
|
-
|
-
|
|
|
mlist_opt
|
int(11)
|
NO
|
-
|
76
|
Options (see below).
|
|
custom_sig
|
text
|
YES
|
-
|
-
|
|
|
mbox_server
|
varchar(255)
|
YES
|
-
|
-
|
Password to access mailbox.
|
|
mbox_user
|
varchar(30)
|
YES
|
-
|
-
|
Username to access mailbox.
|
|
mbox_pass
|
varchar(30)
|
YES
|
-
|
-
|
Password to access mailbox.
|
|
mbox_type
|
int(11)
|
NO
|
-
|
0
|
Options (see below).
|
|
fixed_from_address
|
varchar(50)
|
YES
|
-
|
-
|
|
|
Index Name
|
Uniqueness
|
Column Name
|
Seq in index
|
Comments
|
|
PRIMARY
|
UNIQUE
|
id
|
1
|
|
|
fud30_mlist_i_f
|
NOT UNIQUE
|
forum_id
|
1
|
|
- 1 = mlist_post_apr (ON/OFF)
- 2 = allow_frm_post (ON/OFF)
- 4 = frm_post_apr (ON/OFF)
- 8 = allow_mlist_attch (ON/OFF)
- 16 = allow_mlist_html (ON/OFF)
- 32 = complex_reply_match (ON/OFF)
- 64 = create_users (ON/OFF)
- 128 = skip_non_forum_users (ON/OFF)
- 0 = POP3 mailbox (default)
- 1 = IMAP mailbox
- 2 = POP3, TLS mode
- 4 = IMAP, TLS mode
- 8 = POP3, SSL mode
- 16 = IMAP, SSL mode