fud30_nntp
Description of FUDforum table fud30_nntp. This table is used to track USENET posts that are synced with the forum. For more information, see Newsgroup 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. |
| nntp_opt | int(11) | NO | - | 44 | Options (see below). |
| server | varchar(255) | NO | - | - | Name of the news server. |
| newsgroup | varchar(255) | NO | - | - | Newsgroup name. |
| port | int(11) | NO | - | 0 | Server port. |
| timeout | int(11) | NO | - | 0 | Time before timing out a connection. |
| login | varchar(255) | YES | - | - | Username to login. |
| pass | varchar(255) | YES | - | - | Password to login. |
| imp_limit | int(11) | NO | - | 0 | Number of posts to import in one go. |
| custom_sig | text | YES | - | - | |
| tracker | int(11) | NO | - | 0 | Track already loaded posts. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_nntp_i_f | NOT UNIQUE | forum_id | 1 |
- 1 = nntp_post_apr
- 2 = allow_frm_post
- 4 = frm_post_apr
- 8 = allow_nntp_attch
- 16 = complex_reply_match
- 32 = create_users
- 64 = auth NONE
- 128 = auth (ORIGINAL/SIMPLE)
- 256 = skip_non_forum_users (ON/OFF)
