supportcat — Categories for support system
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| spcatid | int unsigned auto_increment | |||
| catkey | varchar(25) | |||
| catname | varchar(80) | YES | ||
| sortorder | mediumint unsigned | 0 | ||
| basepoints | tinyint unsigned | 1 | ||
| is_selectable | enum('1','0') | 1 | ||
| public_read | enum('1','0') | 1 | ||
| public_help | enum('1','0') | 1 | ||
| allow_screened | enum('1','0') | 0 | ||
| hide_helpers | enum('1','0') | 0 | ||
| replyaddress | varchar(50) | YES | ||
| no_autoreply | enum('1','0') | 0 | ||
| scope | enum('general','local') | general |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| catkey | UNIQUE |