Skip to content

creature Table

Contains creature spawn data (placement, respawn, movement, and overrides).

Schema Summary

Field Type Key Null Default Extra
guid int(10) unsigned PRI NO auto_increment
id mediumint(8) unsigned MUL NO 0
id2 mediumint(8) unsigned NO 0
id3 mediumint(8) unsigned NO 0
id4 mediumint(8) unsigned NO 0
id5 mediumint(8) unsigned NO 0
map smallint(5) unsigned MUL NO 0
position_x float NO 0
position_y float NO 0
position_z float NO 0
orientation float NO 0
spawntimesecsmin int(10) unsigned NO 120
spawntimesecsmax int(10) unsigned NO 120
wander_distance float NO 5
health_percent float NO 100
mana_percent float unsigned NO 100
movement_type tinyint(3) unsigned NO 0
spawn_flags int(10) unsigned NO 0
visibility_mod float YES 0
patch_min tinyint(3) unsigned NO 0
patch_max tinyint(3) unsigned NO 10

Field Breakdown

  • guid - Primary Key, auto-increment. Unique spawn ID.
  • id - id5 - Creature template IDs (creature_template.entry; random selection among them). If multiple, one is chosen at spawn.
  • map - Map ID (from map_template.entry).
  • position_x/y/z - Spawn coordinates.
  • orientation - Facing direction (radians).
  • spawntimesecsmin / spawntimesecsmax - Min/max respawn time (seconds). A random value between them is used.
  • wander_distance - Maximum wandering radius if movement_type = 1.
  • health_percent / mana_percent - Starting health/mana as percentage of template max.
  • movement_type - Movement generator:
  • 0 - Idle (stationary)
  • 1 - Random movement within wander_distance
  • 2 - Waypoint movement (using path IDs)
  • spawn_flags - Bitmask:
  • 1 - Active Object (AI updates even without players)
  • 2 - Disabled
  • 4 - Random respawn time (±10%)
  • 8 - Dynamic respawn time (if population >2500)
  • 16 - Force dynamic respawn for elite
  • 32 - Evade out of home area (ScriptedAI only)
  • 64 - Not visible (can be revealed by spell effect 46)
  • 128 - Dead (used for quests requiring revive)
  • visibility_mod - Overrides default visibility distance (requires spawn_flags to include active).
  • patch_min / patch_max - Content patch range (0 = 1.2, 10 = 1.12.1).