fud30_cat - fudforum/FUDforum GitHub Wiki
Description of FUDforum table fud30_cat. This table contains information about the forum's categories. For more information, see Category Management.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| name | varchar(50) | NO | - | - | Category name. |
| description | varchar(255) | YES | - | - | Category description. |
| cat_opt | int(11) | NO | - | 0 | Category options. |
| view_order | int(11) | NO | - | 3 | View order. |
| parent | int(11) | NO | MUL | 0 | References 'id' (above). |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_cat_p | NOT UNIQUE | parent | 1 |
Binary values for cat_opt:
- 1 = allow_collapse (ON/OFF)
- 2 = default_view (OPEN/COLLAPSED)