Instance
Материал из YTDB DataBase
(Различия между версиями)
Neggod (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Back to characters database list of tables. <big>'''The `instance` table'''</big> This table holds static in…») |
NeatElves (Обсуждение | вклад) |
||
Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
- | + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | |
- | <big>''' | + | <big>'''Таблица `instance`'''</big> |
This table holds static information on all current instances that have not yet been reset. | This table holds static information on all current instances that have not yet been reset. | ||
- | <big>''' | + | <big>'''Структура'''</big> |
{| border="1" | {| border="1" | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
+ | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
|'''Key''' | |'''Key''' | ||
|'''Default''' | |'''Default''' | ||
- | |''' | + | |'''Comments''' |
|- | |- | ||
|[[#id|id]] | |[[#id|id]] | ||
- | |int(11) unsigned | + | |int(11) |
+ | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
Строка 27: | Строка 29: | ||
|- | |- | ||
|[[#map|map]] | |[[#map|map]] | ||
- | |int(11) unsigned | + | |int(11) |
+ | |unsigned | ||
|NO | |NO | ||
|MUL | |MUL | ||
Строка 35: | Строка 38: | ||
|[[#resettime|resettime]] | |[[#resettime|resettime]] | ||
|bigint(40) | |bigint(40) | ||
+ | | | ||
|NO | |NO | ||
|MUL | |MUL | ||
Строка 42: | Строка 46: | ||
|[[#difficulty|difficulty]] | |[[#difficulty|difficulty]] | ||
|tinyint(1) | |tinyint(1) | ||
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 49: | Строка 54: | ||
|[[#data|data]] | |[[#data|data]] | ||
|longtext | |longtext | ||
- | | | + | | |
+ | | | ||
| | | | ||
| | | | ||
Строка 56: | Строка 62: | ||
- | <big>''' | + | <big>'''Описание полей'''</big> |
====id==== | ====id==== | ||
The instance ID. This number is unique to every instance. | The instance ID. This number is unique to every instance. |
Версия 16:04, 5 декабря 2010
|
К описанию таблиц базы данных characters.
Таблица `instance`
This table holds static information on all current instances that have not yet been reset.
Структура
Field | Type | Attributes | Null | Key | Default | Comments |
id | int(11) | unsigned | NO | PRI | 0 | |
map | int(11) | unsigned | NO | MUL | 0 | |
resettime | bigint(40) | NO | MUL | 0 | ||
difficulty | tinyint(1) | unsigned | NO | 0 | ||
data | longtext |
Описание полей
id
The instance ID. This number is unique to every instance.
map
The map ID the instance is in. See Map.dbc
resettime
The time when the instance will be reset, in Unix time. This field is zero for raid and heroic instances.
difficulty
The difficulty of the current instance. 1 = heroic, 0 = normal
data
Specific data belonging to the individual instance.
(c)udbwiki