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 MaNGOSThree
Holds ticket information from tickets written through the client help request -function.
Table Notes
This table uses the 'InnoDB' 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. |
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].
ticket_text text
The ticket description text; the text written by the player in describing the problem.
response_text text
The ticket description text; the text written by the GM in describing the solution.
ticket_lastchange timestamp
Stores the time when this ticket was last changed.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now