Instance SF

From Project Skyfire
Jump to navigation Jump to search

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.


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


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. 0 = 10-man Normal, 1 = 25-man Normal, 2 = 10-man Heroic, 3 = 25-man Heroic.


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


Specific data belonging to the individual instance.