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.
Defines the emblem on the guild tabard.
file index to:
textures/GuildEmblems/Emblem_<Style>_<Color>_TU_U.blp / *_TL_U.blp
Defines the border on the guild tabard.
file index to:
textures/GuildEmblems/Border_<Style>_<Color>_TU_U.blp / *_TL_U.blp
Defines the background color of the guild tabard.
file index to:
textures/GuildEmblems/Background_<Color>_TU_U.blp / *_TL_U.blp
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'