Guild
Материал из YTDB DataBase
(Различия между версиями)
Neggod (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Back to characters database list of tables. <big>'''The `guild` table'''</big> This table holds the main gui…») |
NeatElves (Обсуждение | вклад) |
||
| (5 промежуточных версий не показаны.) | |||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| - | + | [[Category: Mangos characters database tables]] | |
| + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | ||
| - | <big>''' | + | <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. | 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>'''Структура'''</big> |
{| border="1" | {| border="1" | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
| + | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
|'''Key''' | |'''Key''' | ||
|'''Default''' | |'''Default''' | ||
| - | |''' | + | |'''Comments''' |
|- | |- | ||
|[[#guildid|guildid]] | |[[#guildid|guildid]] | ||
| - | |int(6) unsigned | + | |int(6) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 28: | Строка 31: | ||
|[[#name|name]] | |[[#name|name]] | ||
|varchar(255) | |varchar(255) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 34: | Строка 38: | ||
|- | |- | ||
|[[#leaderguid|leaderguid]] | |[[#leaderguid|leaderguid]] | ||
| - | |int(6) unsigned | + | |int(6) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 42: | Строка 47: | ||
|[[#EmblemStyle|EmblemStyle]] | |[[#EmblemStyle|EmblemStyle]] | ||
|int(5) | |int(5) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 49: | Строка 55: | ||
|[[#EmblemColor|EmblemColor]] | |[[#EmblemColor|EmblemColor]] | ||
|int(5) | |int(5) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 56: | Строка 63: | ||
|[[#BorderStyle|BorderStyle]] | |[[#BorderStyle|BorderStyle]] | ||
|int(5) | |int(5) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 63: | Строка 71: | ||
|[[#BorderColor|BorderColor]] | |[[#BorderColor|BorderColor]] | ||
|int(5) | |int(5) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 70: | Строка 79: | ||
|[[#BackgroundColor|BackgroundColor]] | |[[#BackgroundColor|BackgroundColor]] | ||
|int(5) | |int(5) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 77: | Строка 87: | ||
|[[#info|info]] | |[[#info|info]] | ||
|text | |text | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 84: | Строка 95: | ||
|[[#motd|motd]] | |[[#motd|motd]] | ||
|varchar(255) | |varchar(255) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 90: | Строка 102: | ||
|- | |- | ||
|[[#createdate|createdate]] | |[[#createdate|createdate]] | ||
| - | | | + | |bigint(20) |
| - | | | + | |unsigned |
| - | | | + | |NO |
| | | | ||
| + | |0 | ||
| | | | ||
|- | |- | ||
|[[#BankMoney|BankMoney]] | |[[#BankMoney|BankMoney]] | ||
|bigint(20) | |bigint(20) | ||
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 104: | Строка 118: | ||
|} | |} | ||
| - | <big>''' | + | <big>'''Описание полей'''</big> |
====guildid==== | ====guildid==== | ||
The ID of the guild. This number is unique to each guild and is the main method to identify a guild. | The ID of the guild. This number is unique to each guild and is the main method to identify a guild. | ||
| Строка 110: | Строка 124: | ||
The guild name. | The guild name. | ||
====leaderguid==== | ====leaderguid==== | ||
| - | The GUID of the character who created the guild. See [[ | + | The GUID of the character who created the guild. See [[characters#guid|characters.guid]] |
| + | |||
====EmblemStyle==== | ====EmblemStyle==== | ||
The emblem style of the guild tabard. | The emblem style of the guild tabard. | ||
| Строка 129: | Строка 144: | ||
====BankMoney==== | ====BankMoney==== | ||
The total money, in copper, that is currently in the guild's guild bank. | The total money, in copper, that is currently in the guild's guild bank. | ||
| - | |||
| - | |||
Текущая версия на 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.
