Guild

Материал из YTDB DataBase

(Различия между версиями)
Перейти к: навигация, поиск
(leaderguid)
 
(4 промежуточные версии не показаны)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
-
Back to [[charactersdb_struct|characters database]] list of tables.
+
[[Category: Mangos characters database tables]]
 +
К описанию таблиц [[Charactersdb_struct|базы данных characters]].
-
<big>'''The `guild` table'''</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>'''Structure'''</big>
+
<big>'''Структура'''</big>
{| border="1"
{| border="1"
|'''Field'''
|'''Field'''
|'''Type'''
|'''Type'''
 +
|'''Attributes'''
|'''Null'''
|'''Null'''
|'''Key'''
|'''Key'''
|'''Default'''
|'''Default'''
-
|'''Extra'''
+
|'''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]]
-
|datetime
+
|bigint(20)
-
|YES
+
|unsigned
-
|
+
|NO
|
|
 +
|0
|
|
|-
|-
|[[#BankMoney|BankMoney]]
|[[#BankMoney|BankMoney]]
|bigint(20)
|bigint(20)
 +
|unsigned
|NO
|NO
|
|
Строка 104: Строка 118:
|}
|}
-
<big>'''Description of the fields'''</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.
Строка 130: Строка 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.
-
 
-
(c)udbwiki
 

Текущая версия на 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.

Источник — «http://wiki.ytdb.ru:89/index.php/Guild»
Личные инструменты