The `instance` table
This table holds static information on all current instances that have not yet been reset.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | INT | UNSIGNED | PRI | NO | 0 | ||
| map | SMALLINT | UNSIGNED | NO | 0 | |||
| resettime | INT | UNSIGNED | NO | 0 | |||
| difficulty | TINYINT | UNSIGNED | NO | 0 | |||
| completedEncounters | INT | UNSIGNED | NO | 0 | |||
| data | TINYTEXT | SIGNED | NO |
Description of the fields
The instance ID. This number is unique to every instance.
The map ID the instance is in. See Map.dbc.
The time when the instance will be reset, in Unix time. This field is zero for raid and heroic instances. The resettime of raid and heroic instances for every specific group is stored in table instance_reset.
The difficulty of the current instance.
| Value | Description |
|---|---|
| 0 | 10-man Normal |
| 1 | 25-man Normal |
| 2 | 10-man Heroic |
| 3 | 25-man Heroic |
field-no-description|5
Specific data belonging to the individual instance.