Guild
Материал из YTDB DataBase
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
(2 промежуточные версии не показаны) | |||
Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
+ | [[Category: Mangos characters database tables]] | ||
К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | ||
Строка 54: | Строка 55: | ||
|[[#EmblemColor|EmblemColor]] | |[[#EmblemColor|EmblemColor]] | ||
|int(5) | |int(5) | ||
- | |||
| | | | ||
|NO | |NO | ||
Строка 103: | Строка 103: | ||
|[[#createdate|createdate]] | |[[#createdate|createdate]] | ||
|bigint(20) | |bigint(20) | ||
- | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
Строка 111: | Строка 111: | ||
|[[#BankMoney|BankMoney]] | |[[#BankMoney|BankMoney]] | ||
|bigint(20) | |bigint(20) | ||
- | | | + | |unsigned |
|NO | |NO | ||
| | | |
Текущая версия на 16:41, 16 июля 2011
|
К описанию таблиц базы данных characters.
Tаблица `guild`
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 | Null | Key | Default | Comments |
guildid | int(6) | unsigned | NO | PRI | 0 | |
name | varchar(255) | NO | ||||
leaderguid | int(6) | unsigned | NO | 0 | ||
EmblemStyle | int(5) | NO | 0 | |||
EmblemColor | int(5) | NO | 0 | |||
BorderStyle | int(5) | NO | 0 | |||
BorderColor | int(5) | NO | 0 | |||
BackgroundColor | int(5) | NO | 0 | |||
info | text | NO | ||||
motd | varchar(255) | NO | ||||
createdate | bigint(20) | unsigned | NO | 0 | ||
BankMoney | bigint(20) | 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.