Просмотр

{| align="right"
| __TOC__
|}
[[Category: Mangos characters database tables]]
К описанию таблиц [[Charactersdb_struct|базы данных characters]].


<big>'''Tаблица `guild`'''</big>

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.


<big>'''Структура'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Null'''
|'''Key'''
|'''Default'''
|'''Comments'''
|-
|[[#guildid|guildid]]
|int(6)
|unsigned
|NO
|PRI
|0
|
|-
|[[#name|name]]
|varchar(255)
|
|NO
|
|
|
|-
|[[#leaderguid|leaderguid]]
|int(6)
|unsigned
|NO
|
|0
|
|-
|[[#EmblemStyle|EmblemStyle]]
|int(5)
|
|NO
|
|0
|
|-
|[[#EmblemColor|EmblemColor]]
|int(5)
|
|NO
|
|0
|
|-
|[[#BorderStyle|BorderStyle]]
|int(5)
|
|NO
|
|0
|
|-
|[[#BorderColor|BorderColor]]
|int(5)
|
|NO
|
|0
|
|-
|[[#BackgroundColor|BackgroundColor]]
|int(5)
|
|NO
|
|0
|
|-
|[[#info|info]]
|text
|
|NO
|
|
|
|-
|[[#motd|motd]]
|varchar(255)
|
|NO
|
|
|
|-
|[[#createdate|createdate]]
|bigint(20)
|unsigned
|NO
|
|0
|
|-
|[[#BankMoney|BankMoney]]
|bigint(20)
|unsigned
|NO
|
|0
|
|}

<big>'''Описание полей'''</big>
====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|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.