NOTE: This page is auto-generated from the MAGNET DBDocs module,
Any changes made directly to this page will be lost when it is regenerated.
Description of the 'character_ticket' table for MaNGOSOne
Holds ticket information from tickets written through the client help request -function.
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
|Field Name||Field Type||Nullable||Key||Default Value||Attributes||Notes|
|ticket_id||int(11) unsigned||NO||PRI||NULL||'auto_increment'||A unique ticket ID.|
|guid||int(11) unsigned||NO||'0'||The GUID of the character sending the ticket. [See character.guid].|
|ticket_text||text||YES||NULL||The ticket description text; the text written by the player.|
|response_text||text||YES||NULL||The ticket solution text; the text written by the GM.|
|ticket_lastchange||timestamp||NO||'CURRENT_TIMESTAMP'||Stores the time when this ticket was last changed.|
|resolved||tinyint(1)||YES||'0'||Resolved Flag = set to 1 if the GM has sucessfully resolved the ticket|
Description of the fields
ticket_id int(11) unsigned
A unique ticket ID.
guid int(11) unsigned
The GUID of the character sending the ticket. [See character.guid].
The ticket description text; the text written by the player in describing the problem.
The ticket description text; the text written by the GM in describing the solution.
Stores the time when this ticket was last changed.
Resolved Flag = set to 1 if the GM has sucessfully resolved the ticket
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz