...
This table contains main data about all mails in the game.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment id | ||||
int(10) | unsigned | PRI | NO | 0 |
| Identifier messageType | |||||
tinyint(3) | unsigned |
| NO | 0 |
| ||||||
tinyint(3) | signed |
| NO | 41 |
|
| |||||
mediumint(5) | unsigned |
| NO | 0 |
| ||||||
int(10) | unsigned |
| NO | 0 |
| Character Global Unique Identifier | |||||
int(10) | unsigned |
| NO | 0 |
| Character Global Unique Identifier | |||||
longtext | signed |
| YES | NULL |
| ||||||
longtext | signed |
| YES _ | _ _ | _ | -_ | has_items_ _ | ||||
tinyint(3)_ | unsigned_ _ _ | NO_ | 0_ _ | _ _ | _ | -_ | expire_time_ | ||||
int(10)_ | unsigned_ _ _ | NO_ | 0_ _ | _ | _ | -_ | deliver_time_ _ | ||||
int(10)_ | unsigned_ _ _ | _ NO_ _ | 0_ _ | _ | _ | -_ | money_ | ||||
int(10)_ | unsigned_ _ | _ | NO_ | 0_ _ | _ | _ | -_ | cod_ _ | |||
int(10)_ | unsigned_ _ _ | NO_ | 0_ _ | _ | _ | -_ | checked_ _ | ||||
tinyint(3)_ | unsigned_ _ _ | NO_ | 0_ _ | _ | _ | _ __' |
Description of the fields
...
id
This field contains unique ID of any messages.
...