Back to 'gm_survey' Return to characters Go to 'group_instance'
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | PRI | NO | auto_increment | ||
| type | tinyint | unsigned | NO | 0 | 0 open, 1 closed, 2 character deleted | ||
| playerGuid | int | unsigned | NO | 0 | Global Unique Identifier of ticket creator | ||
| name | varchar(12) | NO | Name of ticket creator | ||||
| description | text | NO | |||||
| createTime | int | unsigned | NO | 0 | |||
| mapId | smallint | unsigned | NO | 0 | |||
| posX | float | NO | 0 | ||||
| posY | float | NO | 0 | ||||
| posZ | float | NO | 0 | ||||
| lastModifiedTime | int | unsigned | NO | 0 | |||
| closedBy | int | signed | NO | 0 | |||
| assignedTo | int | unsigned | NO | 0 | GUID of admin to whom ticket is assigned | ||
| comment | text | NO | |||||
| response | text | NO | |||||
| completed | tinyint | unsigned | NO | 0 | |||
| escalated | tinyint | unsigned | NO | 0 | |||
| viewed | tinyint | unsigned | NO | 0 | |||
| needMoreHelp | tinyint | unsigned | NO | 0 | |||
| resolvedBy | int | signed | NO | 0 | GUID of GM who resolved the ticket |
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
Back to 'gm_survey' Return to characters Go to 'group_instance'