instance

Back-to:Characters

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(10)

unsigned

PRI

NO

0

 

 

map

smallint(5)

unsigned

 

NO

0

 

 

resettime

int(10)

unsigned

 

NO

0

 

 

difficulty

tinyint(3)

unsigned

 

NO

0

 

 

completedEncounters

int(10)

unsigned

 

NO

0

 

 

data

tinytext

signed

 

NO

 

 

 

Description of the fields

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.
The resettime of raid and heroic instances for every specific group is stored in table instance_reset.

difficulty

The difficulty of the current instance. 0 = 10-man Normal, 1 = 25-man Normal, 2 = 10-man Heroic, 3 = 25-man Heroic.

completedEncounters

field-no-description|5

data

Specific data belonging to the individual instance.