instances

This table contains information about current dungeon status.

Structure

Field Type Default Comment
id int(30)    
mapid int(30)    
creation int(30)    
expiration int(30)    
killed_npc_guids text    
difficulty int(30)    
creator_group int(30)    
creator_guid int(30)    
persistent tinyint(4) 0  

id

The id of the created instance of the instance for the group.

mapid

The map ID of the instance.

creation

The Date/Time of creation.

expiration

Time till the expiration of the instance.

killed_npc_guids

The guids of the killed npcs from creature_spawns) table.

difficulty

0 = Normal
1 = Heroic

creator_group

The character guid from characters table.

creator_guid

Some int value…

persistent

0 = false (the instance is not in use)
1 = true (the instance is in use)