This table contains the mails for the characters.
The unique ID of the message/mail.
0 = Normal (sender is a character) 1 = COD (sender will recieve money before the mail will be delivered) 2 = Auction (sender is the auctionshouse) 3 = Creature (sender is a NPC) 4 = Gameobject 5 = Item (mail includes items)
The character guid of the reviever from characters table.
The character guid of the sender from characters table.
The subject of the mail.
The text of this mail.
The attached money in copper.
The item entry IDs from playeritems table. You can attach up to 12 items. Form stack itemguid, stack2 itemguid2, …
Amount of money (in copper) needed to recieve this message.
0 = Standard <strike>1 = Test 1 41 = Test 2</strike> 61 = Gamemaster 62 = Auction 64 = Valentines day 65 = Chrismas
The time in seconds when the mail would be expired (for example unix time now + seconds to expire = expiry time).
The time in seconds for the delivery (for example unix time now + seconds to delivery = deliver time).
0 = None 1 = Readed (this mail is already readed) 2 = Returned (this mail was already returned) 4 = Copied (this mail is just a copy of the text, not of the items!) 8 = COD Payment (this mail cost to revieve it) 16 = Has body (this mail has text)
1 = Mail is deleted 0 = Mail is not deleted (default)