Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.
Comentarios: fix table

...

This table contains main data about all mails in the game.

Structure

 

 

Field

Type

Attributes

Key

Null

Default

Extra

Comment id

Mail tc2

int(10)

unsigned

PRI

NO

0

 

Identifier messageType

Mail tc2

tinyint(3)

unsigned

 

NO

0

 

  stationery

Mail tc2

tinyint(3)

signed

 

NO

41

 

 

mailTemplateId

mediumint(5)

unsigned

 

NO

0

 

  sender

Mail tc2

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

receiver Mail tc2

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

subject Mail tc2

longtext

signed

 

YES

NULL

 

  body

Mail tc2

longtext

signed

 

YES _

  _  _

_
_

-_
_

has_items_
_  

Mail tc2

tinyint(3)_
_

unsigned_ _ _
_

 

NO_
_

0_ _

  _  _

_
_

-_
_

expire_time_
_

Mail tc2

int(10)_
_

unsigned_ _ _
_

 

NO_
_

0_ _

 

_
_

_
_

-_
_

deliver_time_
_  

Mail tc2

int(10)_
_

unsigned_ _ _

 

_ NO_ _

0_ _

 

_
_

_
_

-_
_

money_
_

 

Mail tc2

int(10)_
_

unsigned_ _

 

_
_

NO_
_

0_ _

 

_
_

_
_

-_
_

cod_
_  

Mail tc2

int(10)_
_

unsigned_ _ _
_

 

NO_
_

0_ _

 

_
_

_
_

-_
_

checked_
_  

Mail tc2

tinyint(3)_
_

unsigned_ _ _
_

 

NO_
_

0_ _

_
_

_
_

_
__' 
 

Description of the fields

...

id

This field contains unique ID of any messages.

...