Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

instance

<-Back-to:Characters

The `instance` table

This table holds static information on all current instances that have not yet been reset.

Table Structure

Field	Type	Attributes	Key	Null	Default
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

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.

Value	Description
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.