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'