Petition

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

(Различия между версиями)
Перейти к: навигация, поиск
(Новая страница: «{| align="right" | __TOC__ |} Back to the characters database list of tables. <big>'''The `petition` table'''</big> This table holds infor…»)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
-
Back to the [[charactersdb_struct|characters database]] list of tables.
+
К описанию таблиц [[Charactersdb_struct|базы данных characters]].
-
<big>'''The `petition` table'''</big>
+
<big>'''Таблица `petition`'''</big>
 +
 
This table holds information on all ongoing petitions for a guild or for an arena team.
This table holds information on all ongoing petitions for a guild or for an arena team.
Строка 14: Строка 15:
|'''Field'''
|'''Field'''
|'''Type'''
|'''Type'''
 +
|'''Attributes'''
|'''Null'''
|'''Null'''
|'''Key'''
|'''Key'''
|'''Default'''
|'''Default'''
-
|'''Extra'''
+
|'''Comments'''
|-
|-
|[[#ownerguid|ownerguid]]
|[[#ownerguid|ownerguid]]
-
|int(10) unsigned
+
|int(10)
 +
|unsigned
|NO
|NO
|PRI
|PRI
Строка 27: Строка 30:
|-
|-
|[[#petitionguid|petitionguid]]
|[[#petitionguid|petitionguid]]
-
|int(10) unsigned
+
|int(10)
 +
|unsigned
|YES
|YES
|
|
Строка 35: Строка 39:
|[[#name|name]]
|[[#name|name]]
|varchar(255)
|varchar(255)
 +
|
|NO
|NO
|
|
Строка 41: Строка 46:
|-
|-
|[[#type|type]]
|[[#type|type]]
-
|int(10) unsigned
+
|int(10)
 +
|unsigned
|NO
|NO
-
|
+
|PRI
|0
|0
|
|
Строка 51: Строка 57:
<big>'''Description of the fields'''</big>
<big>'''Description of the fields'''</big>
====ownerguid====
====ownerguid====
-
The petition's owner's GUID. See [[character#guid|character.guid]]
+
The petition's owner's GUID. See [[characters#guid|characters.guid]]
====petitionguid====
====petitionguid====
The GUID of the petition item. See [[item_instance#guid|item_instance.guid]]
The GUID of the petition item. See [[item_instance#guid|item_instance.guid]]
Строка 69: Строка 75:
| 9 || Guild charter
| 9 || Guild charter
|}
|}
-
(c)udbwiki
 

Версия 10:23, 31 августа 2010

Содержание

К описанию таблиц базы данных characters.


Таблица `petition`


This table holds information on all ongoing petitions for a guild or for an arena team.


Structure

Field Type Attributes Null Key Default Comments
ownerguid int(10) unsigned NO PRI
petitionguid int(10) unsigned YES 0
name varchar(255) NO
type int(10) unsigned NO PRI 0


Description of the fields

ownerguid

The petition's owner's GUID. See characters.guid

petitionguid

The GUID of the petition item. See item_instance.guid

name

The name of the guild or arena team that the player is trying to ask for petitions for.

type

The type of the petition.

ID Type
2 2vs2 Arena charter
3 3vs3 Arena charter
5 5vs5 Arena charter
9 Guild charter
Личные инструменты