Description of FUDforum table fud30_forum. This table contains information about the board's forums. For more information, see Forum Manager.
Fields
| 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).
|
Keys
| 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 |
|
Options
- 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)