fud30_forum
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)
