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)