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.
Fields
| 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 | | |
|
Keys
| Index Name | Uniqueness | Column Name | Seq in index | Comments
|
| PRIMARY | UNIQUE | id | 1 |
|
| fud30_mlist_i_f | NOT UNIQUE | forum_id | 1 |
|
mlist_opt
- 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)
mbox_type
- 0 = POP3 mailbox (default)
- 1 = IMAP mailbox
- 2 = POP3, TLS mode
- 4 = IMAP, TLS mode
- 8 = POP3, SSL mode
- 16 = IMAP, SSL mode