Mail

From OregonCore Wiki
Jump to: navigation, search

Back to characters database list of tables.


The `mail` table

Template:Table-no-description

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
id int(11) unsigned PRI NO 0 Identifier
messageType tinyint(3) unsigned NO 0
stationery tinyint(3) signed NO 41
mailTemplateId mediumint(8) unsigned NO 0
sender int(11) unsigned NO 0 Character Global Unique Identifier
receiver int(11) unsigned NO 0 Character Global Unique Identifier
subject longtext utf8_general_ci YES NULL
itemTextId int(11) unsigned NO 0
has_items tinyint(3) unsigned NO 0
expire_time bigint(40) signed NO 0
deliver_time bigint(40) signed NO 0
money int(11) unsigned NO 0
cod int(11) unsigned NO 0
checked tinyint(3) unsigned NO 0


Description of the fields

id

Unique identifier - generated by core.

messageType

Template:Field-no-description

stationery

Template:Field-no-description

mailTemplateId

Template:Field-no-description

sender

Sending character GUID.

receiver

Receiving character GUID

subject

Subject Text

itemTextId

Template:Field-no-description

has_items

Template:Field-no-description

expire_time

Template:Field-no-description

deliver_time

Template:Field-no-description

money

Money to be sent with message, in copper.

cod

Template:Field-no-description

checked

Template:Field-no-description