Skip to content

corpse Table

Corpses left in the world after deaths (position, bones/state).

Schema Summary

Field Type Key Null Default Extra
guid int(11) unsigned PRI NO 0
player_guid int(11) unsigned MUL NO 0
position_x float NO 0
position_y float NO 0
position_z float NO 0
orientation float NO 0
map int(11) unsigned NO 0
time bigint(20) unsigned MUL NO 0
corpse_type tinyint(3) unsigned MUL NO 0
instance int(11) unsigned MUL NO 0

Field Breakdown

  • guid - Primary Key. Global Unique Identifier
  • player_guid - Dead character (characters.guid).
  • position_x - Where the corpse lies.
  • position_y - Corpse Y coordinate.
  • position_z - Corpse Z coordinate.
  • orientation - Where the corpse lies.
  • map - Where the corpse lies.
  • time - Death time.
  • corpse_type - 0 = bones, 1 = resurrectable PvE corpse, 2 = resurrectable PvP corpse. Only values 1-2 are ever written; bones exist only as transient world objects (never persisted).
  • instance - Instance id (instance.id) when death happened inside an instance.

corpse_type Values

Value Meaning
0 Bones - enum value exists but bones are never saved to the DB
1 Resurrectable PvE corpse
2 Resurrectable PvP corpse

Resurrectable corpses expire after 3 days (time + 3 days).