Back to 'groups' Return to characters Go to 'guild_bank_eventlog'
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.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | int | unsigned | PRI | NO | 0 | ||
| name | varchar(24) | 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) | NO | '' | ||||
| motd | varchar(128) | NO | '' | ||||
| createdate | int | unsigned | NO | 0 | |||
| BankMoney | bigint | unsigned | NO | 0 |
The ID of the guild. This number is unique to each guild and is the main method to identify a guild.
The guild's name.
The character guid of the guild leader.
The emblem on the guild tabard.
The color of the emblem on guild tabard.
The border style of the guild tabard.
The color of the border on 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.
Unix timestamp when the guild was created.
The total money, in copper, that is currently in the guild's guild bank.
Back to 'groups' Return to characters Go to 'guild_bank_eventlog'