support —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| spid | int unsigned auto_increment | |||
| reqtype | enum('user','email') | YES | ||
| requserid | int unsigned | 0 | ||
| reqname | varchar(50) | YES | ||
| reqemail | varchar(70) | YES | ||
| state | enum('open','closed') | YES | ||
| authcode | varchar(15) | |||
| spcatid | int unsigned | 0 | ||
| subject | varchar(80) | YES | ||
| timecreate | int unsigned | YES | ||
| timetouched | int unsigned | YES | ||
| timeclosed | int unsigned | YES | ||
| timelasthelp | int unsigned | YES |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| reqemail | INDEX | |
| requserid | INDEX | |
| state | INDEX |