supportcat — Global. Stores Support system categories.
| 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
|
Controls if you can use internal comments/actions as Reply Types. | |
| allow_screened | enum('1','0') |
0
|
||
| hide_helpers | enum('1','0') |
0
|
||
| user_closeable | enum('1','0') |
1
|
||
| replyaddress | varchar(50) | YES |
|
|
| no_autoreply | enum('1','0') |
0
|
||
| scope | enum('general','local') |
general
|
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| catkey | UNIQUE |