fud30_mlist
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
