fud30_custom_fields - fudforum/FUDforum GitHub Wiki
Description of FUDforum table fud30_custom_fields. For details, see Custom profile fields.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| name | varchar(255) | NO | - | - | Custom field name. |
| descr | varchar(255) | YES | - | - | Custom field description. |
| type_opt | int(11) | NO | - | - | Field type. See options below. |
| choice | text | YES | - | - | Default value / choices. |
| field_opt | int(11) | NO | - | - | Field options. See options below. |
| vieworder | int(11) | NO | - | 0 | Order. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 |
Binary values for field_opt:
- 0 = optional
- 1 = mandatory
- 2 = visible in profile (all users)
- 4 = only visible to logged in users
- 0 = single line
- 1 = text box
- 2 = select drop down
- 4 = radio buttons