Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • character_ticket


    antz
     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.

    Table Notes

    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].

    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.

    resolved tinyint(1)

    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


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use