Fud30 thread

From FUDforum Wiki
Revision as of 00:00, 15 January 2001 by Naudefj (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description of FUDforum table fud30_thread.

Fields

Column Name Datatype Can be Null? Key? Default Description
id int(11) NO PRI auto_increment
forum_id int(11) NO MUL 0
root_msg_id int(11) NO MUL 0
last_post_date bigint(20) NO 0
replies int(11) NO MUL 0
views int(11) NO 0
rating int(11) NO 0
n_rating int(11) NO 0
last_post_id int(11) NO 0
moved_to int(11) NO 0
orderexpiry bigint(20) NO 0
thread_opt int(11) NO MUL 0
tdescr varchar(200) YES

Keys

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
Languages
Personal tools