Mail external

From OregonCore Wiki
Jump to: navigation, search

Back to characters database list of tables.


The `mail_external` table

Entries to this table will be processed into the in-game mail system.

Schema Last Modified: Rev 552 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
id bigint(20) unsigned PRI NO 0 Identifier
receiver bigint(20) unsigned NO 0
subject varchar(200) utf8_general_ci YES Support Message
message varchar(200) utf8_general_ci YES Support Message
money bigint(20) unsigned NO 0
item bigint(20) unsigned NO 0
item_count bigint(20) unsigned NO 0


Description of the fields

id

Unique row identifier - Auto-generated.

receiver

character.guid of party to receive message. See characters.guid

subject

Subject Text

message

Message Text

money

Money to include with message (in copper).

item

item_template.entry of Item to attach to message. See item_template.entry

item_count

Number of items in stack to attach to message.