Actions

Instance SF

From Project Skyfire

Back to characters database list of tables.


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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

data

Specific data belonging to the individual instance.