|
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 MaNGOSThree
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 'InnoDB' 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
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