| Field |
Type |
Null |
Key |
Default |
Description
|
| fid |
smallint(5) |
No |
Primary
|
|
Forum ID
|
| name |
varchar(120) |
No |
|
|
Name of the forum
|
| description |
text |
No |
|
|
Forum description
|
| linkto |
varchar(180) |
No |
|
|
External link (redirect forum)
|
| type |
char(1) |
No |
|
|
'f' or 'c' indicating forum or category respectively
|
| pid |
smallint(5) |
No |
|
0
|
Parent forum ID
|
| parentlist |
text |
No |
|
|
Comma-delimited list of the forum's parent tree
|
| disporder |
smallint(5) |
No |
|
0
|
Display order
|
| active |
int(1) |
No |
|
0
|
'1'/'0' indicating whether the forum is active or not
|
| open |
int(1) |
No |
|
0
|
'1'/'0' indicating whether the forum is open or not
|
| threads |
int(10) |
No |
|
0
|
Number of threads
|
| posts |
int(10) |
No |
|
0
|
Number of posts
|
| lastpost |
int(10) |
No |
|
0
|
UNIX timestamp of the last post
|
| lastposter |
varchar(120) |
No |
|
|
Username of the last poster
|
| lastposteruid |
int(10) |
No |
|
0
|
User ID of the last poster
|
| lastposttid |
int(10) |
No |
|
0
|
Thread ID containing the last post
|
| lastpostsubject |
varchar(120) |
No |
|
|
Subject of the last post
|
| allowhtml |
int(1) |
No |
|
0
|
'1'/'0' permission allowing HTML to be parsed
|
| allowmycode |
int(1) |
No |
|
0
|
'1'/'0' permission allowing MyCode to be parsed
|
| allowsmilies |
int(1) |
No |
|
0
|
'1'/'0' permission allowing Smilies to be parsed
|
| allowimgcode |
int(1) |
No |
|
0
|
'1'/'0' permission allowing [img] codes to be parsed
|
| allowvideocode |
int(1) |
No |
|
0
|
'1'/'0' permission allowing [video] codes to be parsed
|
| allowpicons |
int(1) |
No |
|
0
|
'1'/'0' permission allowing post icons to be used
|
| allowtratings |
int(1) |
No |
|
0
|
'1'/'0' permission allowing thread ratings
|
| status |
int(4) |
No |
|
1
|
An integer
|
| usepostcounts |
int(1) |
No |
|
|
'1'/'0' indicating whether or not users' post counts are incremented
|
| password |
varchar(50) |
No |
|
|
Forum password
|
| showinjump |
int(1) |
No |
|
0
|
'1'/'0' to show this forum in the forum jump
|
| modposts |
int(1) |
No |
|
0
|
'1'/'0' to moderate posts
|
| modthreads |
int(1) |
No |
|
0
|
'1'/'0' to moderate threads
|
| mod_edit_posts |
int(1) |
No |
|
0
|
'1'/'0' to moderate posts after they are edited
|
| modattachments |
int(1) |
No |
|
0
|
'1'/'0' to moderate attachments
|
| style |
smallint(5) |
No |
|
0
|
Theme ID for this forum
|
| overridestyle |
int(1) |
No |
|
0
|
'1'/'0' to override user's chosen style
|
| rulestype |
smallint(1) |
No |
|
0
|
Type of rules
|
| rulestitle |
varchar(200) |
No |
|
|
Title of the forum rules
|
| rules |
text |
No |
|
|
Forum rules
|
| unapprovedthreads |
int(10) |
No |
|
0
|
The number of unapproved threads in the forum
|
| unapprovedposts |
int(10) |
No |
|
0
|
The number of unapproved posts in the forum
|
| defaultdatecut |
smallint(4) |
No |
|
0
|
The default date cut for threads to be displayed
|
| defaultsortby |
varchar(10) |
No |
|
|
The default sort column of the threads displayed in the forum
|
| defaultsortorder |
varchar(4) |
No |
|
|
The default sort order of the threads displayed in the forum
|