Description of FUDforum table fud30_forum. This table contains information about the board's forums. For more information, see Forum Management.
|
Column Name
|
Datatype
|
Can be Null?
|
Key?
|
Default
|
Description
|
|
id
|
int(11)
|
NO
|
PRI
|
-
|
auto_increment
|
|
cat_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_cat.id.
|
|
name
|
varchar(255)
|
NO
|
-
|
-
|
Forum's name.
|
|
descr
|
text
|
YES
|
-
|
-
|
Forum description.
|
|
parent
|
int
|
NO
|
-
|
0
|
Parent forum id (used for nested forums)
|
|
url_redirect
|
varchar(255)
|
YES
|
-
|
-
|
URL for redirection.
|
|
post_passwd
|
varchar(32)
|
YES
|
-
|
-
|
Password (if Password Posting is enabled).
|
|
forum_icon
|
varchar(255)
|
YES
|
-
|
-
|
Icon to display next to forum.
|
|
date_created
|
bigint(20)
|
NO
|
-
|
0
|
Date forum was created.
|
|
thread_count
|
int(11)
|
NO
|
-
|
0
|
Number of topics in form.
|
|
post_count
|
int(11)
|
NO
|
-
|
0
|
Number of messages in forum.
|
|
last_post_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_msg.id.
|
|
view_order
|
int(11)
|
NO
|
-
|
0
|
Position in list.
|
|
max_attach_size
|
int(11)
|
NO
|
-
|
0
|
Maximum attachment size.
|
|
max_file_attachments
|
int(11)
|
NO
|
-
|
1
|
Maximum number of attachments allowed.
|
|
moderators
|
text
|
YES
|
-
|
-
|
Serialized list of Forum moderators.
|
|
message_threshold
|
int(11)
|
NO
|
-
|
0
|
Maximum size of the message DISPLAYED without a reveal link (0 == unlimited).
|
|
forum_opt
|
int(11)
|
NO
|
-
|
16
|
Options (see below).
|
|
Index Name
|
Uniqueness
|
Column Name
|
Seq in index
|
Comments
|
|
PRIMARY
|
UNIQUE
|
id
|
1
|
|
|
fud30_forum_i_c
|
NOT UNIQUE
|
cat_id
|
1
|
|
|
fud30_forum_i_lpi
|
NOT UNIQUE
|
last_post_id
|
1
|
|
- 1 = anon_forum (ON/OFF)
- 2 = moderated (ON/OFF)
- 4 = passwd_posting (ON/OFF)
- 8 = tag_style NONE
- 16 = tag_style (BBCode/HTML)
- 32 = mod_attach (ON/OFF)
- 64 = always_notify_mods (ON/OFF)