Description of FUDforum table fud30_thread. This table contains the forum's topics.
|
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.
|
|
root_msg_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_msg.id.
|
|
last_post_date
|
bigint(20)
|
NO
|
-
|
0
|
Date/time of last message posted.
|
|
replies
|
int(11)
|
NO
|
MUL
|
0
|
Number of replies.
|
|
views
|
int(11)
|
NO
|
-
|
0
|
Number of views.
|
|
rating
|
int(11)
|
NO
|
-
|
0
|
Topic's rating (average).
|
|
n_rating
|
int(11)
|
NO
|
-
|
0
|
Number of users who rated this topic.
|
|
last_post_id
|
int(11)
|
NO
|
-
|
0
|
References fud30_msg.id.
|
|
moved_to
|
int(11)
|
NO
|
-
|
0
|
References fud30_forum.id.
|
|
orderexpiry
|
bigint(20)
|
NO
|
-
|
0
|
Topic expiration (if sticky or announcement)
|
|
thread_opt
|
int(11)
|
NO
|
MUL
|
0
|
Thread options (see below).
|
|
tdescr
|
varchar(200)
|
YES
|
-
|
-
|
Topic description.
|
|
Index Name
|
Uniqueness
|
Column Name
|
Seq in index
|
Comments
|
|
PRIMARY
|
UNIQUE
|
id
|
1
|
|
|
fud30_thread_i_flm
|
NOT UNIQUE
|
forum_id
|
1
|
|
|
fud30_thread_i_flm
|
NOT UNIQUE
|
moved_to
|
2
|
|
|
fud30_thread_i_t
|
NOT UNIQUE
|
thread_opt
|
1
|
|
|
fud30_thread_i_rmi
|
NOT UNIQUE
|
root_msg_id
|
1
|
|
|
fud30_thread_i_r
|
NOT UNIQUE
|
replies
|
1
|
|
- 1 = locked
- 2 = is_sticky ANNOUNCE
- 4 = is_sticky STICKY
- 8 = important (always on top)
- ordertype (removed)