Skip to content

mail Table

Mailbox messages: sender, receiver, subject, body, attachments state, expiry.

Schema Summary

Field Type Key Null Default Extra
id int(11) unsigned PRI NO auto_increment
message_type tinyint(3) unsigned NO 0
stationery tinyint(3) NO 41
mail_template_id mediumint(8) unsigned NO 0
sender_guid int(11) unsigned NO 0
receiver_guid int(11) unsigned MUL NO 0
subject longtext YES
item_text_id int(11) unsigned NO 0
has_items tinyint(3) unsigned NO 0
expire_time bigint(40) NO 0
deliver_time bigint(40) NO 0
money int(11) unsigned NO 0
cod int(11) unsigned NO 0
checked tinyint(3) unsigned NO 0

Field Breakdown

  • id - Primary Key. Mail id.
  • message_type - 0 normal player mail · 2 auction · 3 creature · 4 gameobject · 5 item (drives client icon/query behaviour).
  • stationery - Stationery template id (41 default, 61 GM, 62 auction…).
  • mail_template_id - Optional mail template id.
  • sender_guid - Player guid for normal mail; creature/gameobject/item entry or auction house id for non-player mail types (interpret together with message_type).
  • receiver_guid - Recipient character guid (from characters.guid).
  • subject - Subject line.
  • item_text_id - Reference for item-text style bodies.
  • has_items - 1 when mail_items rows are attached.
  • expire_time - When the mail is returned/deleted.
  • deliver_time - When it becomes visible to the receiver (AH delay/AH time).
  • money - Attached money (copper).
  • cod - Cash-on-demand amount required before taking attached items.
  • checked - Status bitmask: 0x01 read · 0x02 returned · 0x04 copied · 0x08 this mail is a COD payment (sent to the original sender) · 0x10 has body.