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

  • guild


    antz
     Share

     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 'guild' table for MaNGOSTwo

    This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table.

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    guildid int(6) unsigned NO PRI '0'   The ID of the guild.
    name varchar(255) NO {Blank String}   The guild name.
    leaderguid int(6) unsigned NO '0'   The GUID of the character who created the guild. [See characters.guid]
    EmblemStyle int(5) NO '0'   The emblem style of the guild tabard.
    EmblemColor int(5) NO '0'   The emblem color of the guild tabard.
    BorderStyle int(5) NO '0'   The border style of the guild tabard.
    BorderColor int(5) NO '0'   The border color of the guild tabard.
    BackgroundColor int(5) NO '0'   The background color of the guild tabard.
    info varchar(500) NO {Blank String}   The text message that appears in the Guild Information box.
    motd varchar(128) NO {Blank String}   The text that appears in the Message Of The Day box.
    createdate bigint(20) unsigned NO '0'   The date when the guild was created.
    BankMoney bigint(20) unsigned NO '0'    

    Description of the fields

    guildid int(6) unsigned

    The ID of the guild. This number is unique to each guild and is the main method to identify a guild.

    name varchar(255)

    The guild name.

    leaderguid int(6) unsigned

    The GUID of the character who created the guild. [See characters.guid]

    EmblemStyle int(5)

    The emblem style of the guild tabard.

    EmblemColor int(5)

    The emblem color of the guild tabard.

    BorderStyle int(5)

    The border style of the guild tabard.

    BorderColor int(5)

    The border color of the guild tabard.

    BackgroundColor int(5)

    The background color of the guild tabard.

    info varchar(500)

    The text message that appears in the Guild Information box.

    motd varchar(128)

    The text that appears in the Message Of The Day box.

    createdate bigint(20) unsigned

    The date when the guild was created.

    BankMoney bigint(20) unsigned


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

     Share


    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