Petition
Материал из YTDB DataBase
(Различия между версиями)
Neggod (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Back to the characters database list of tables. <big>'''The `petition` table'''</big> This table holds infor…») |
NeatElves (Обсуждение | вклад) |
||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| - | + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | |
| - | <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''' | ||
| - | |''' | + | |'''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 [[ | + | 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 | ||
|} | |} | ||
| - | |||
Версия 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 |
