guild
The `guild` table
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.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | INT | UNSIGNED | PRI | NO | 0 | ||
| name | VARCHAR(24) | SIGNED | NO | | | |
| leaderguid | INT | UNSIGNED | | NO | 0 | | |
| EmblemStyle | TINYINT | UNSIGNED | | NO | 0 | | |
| EmblemColor | TINYINT | UNSIGNED | | NO | 0 | | |
| BorderStyle | TINYINT | UNSIGNED | | NO | 0 | | |
| BorderColor | TINYINT | UNSIGNED | | NO | 0 | | |
| BackgroundColor | TINYINT | UNSIGNED | | NO | 0 | | |
| info | VARCHAR(500) | SIGNED | | NO | | |||
| motd | VARCHAR(128) | SIGNED | NO | '' | |||
| createdate | INT | UNSIGNED | NO | 0 | |||
| BankMoney | BIGINT | UNSIGNED | NO | 0 |
Description of the fields
guildid
The ID of the guild. This number is unique to each guild and is the main method to identify a guild.
name
The guild name.
leaderguid
The GUID of the character who created the guild. See characters.guid.
EmblemStyle
The emblem style of the guild tabard.
EmblemColor
The emblem color of the guild tabard.
BorderStyle
The border style of the guild tabard.
BorderColor
The border color of the guild tabard.
BackgroundColor
The background color of the guild tabard.
info
The text message that appears in the Guild Information box.
motd
The text that appears in the Message Of The Day box.
createdate
The date when the guild was created.
BankMoney
The total money, in copper, that is currently in the guild's guild bank.