The `log_money` table
Table Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
sender_acc | INT | UNSIGNED | NO | ||||
sender_guid | INT | UNSIGNED | NO | ||||
sender_name | CHAR(32) | SIGNED | NO | ||||
sender_ip | CHAR(32) | SIGNED | NO | ||||
receiver_acc | INT | UNSIGNED | NO | ||||
receiver_name | CHAR(32) | SIGNED | NO | ||||
money | BIGINT | UNSIGNED | NO | ||||
topic | CHAR(255) | SIGNED | NO | ||||
date | DATETIME | SIGNED | NO | ||||
[type][10] | TINYINT | SIGNED | NO | 1=COD,2=AH,3=GB DEPOSIT,4=GB WITHDRAW,5=MAIL,6=TRADE |
Description of the fields
field-no-description|1
field-no-description|2
field-no-description|3
field-no-description|4
field-no-description|5
field-no-description|6
field-no-description|7
field-no-description|8
field-no-description|9
Name | Value |
---|---|
1 | COD |
2 | AH |
3 | GB DEPOSIT |
4 | GB WITHDRAW |
5 | |
6 | TRADE |