Instance

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	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI	0
map	int(11) unsigned	NO	MUL	0
resettime	bigint(40)	NO	MUL	0
difficulty	tinyint(1)	NO		0
data	longtext	YES

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.

difficulty

The difficulty of the current instance. 1 = heroic, 0 = normal

data

Specific data belonging to the individual instance.