====== guild 表 ======
----
[[数据库:characters数据库:首页|<-返回:Characters 数据库]]

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|guildid]]|INT|UNSIGNED|PRI|NO|0| | |
|[[#name|name]]|VARCHAR(24)|SIGNED| |NO|' '| | |
|[[#leaderguid|leaderguid]]|INT|UNSIGNED| |NO|0| | |
|[[#EmblemStyle|EmblemStyle]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#EmblemColor|EmblemColor]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#BorderStyle|BorderStyle]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#BorderColor|BorderColor]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#BackgroundColor|BackgroundColor]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#info|info]]|VARCHAR(500)|SIGNED| |NO|' '| | |
|[[#motd|motd]]|VARCHAR(128)|SIGNED| |NO|' '| | |
|[[#createdate|createdate]]|INT|UNSIGNED| |NO|0| | |
|[[#BankMoney|BankMoney]]|BIGINT|UNSIGNED| |NO|0| | |

===== 字段说明 =====
----

==== 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.