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
The ID of the guild. This number is unique to each guild and is the main method to identify a guild.
The guild name.
The GUID of the character who created the guild. See characters.guid.
The emblem style of the guild tabard.
The emblem color of the guild tabard.
The border style of the guild tabard.
The border color of the guild tabard.
The background color of the guild tabard.
The text message that appears in the Guild Information box.
The text that appears in the Message Of The Day box.
The date when the guild was created.
The total money, in copper, that is currently in the guild's guild bank.