目录

log_money

<-Back-to:Characters

The `log_money` 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

sender_acc

field-no-description|1

sender_guid

field-no-description|2

sender_name

field-no-description|3

sender_ip

field-no-description|4

receiver_acc

field-no-description|5

receiver_name

field-no-description|6

money

field-no-description|7

topic

field-no-description|8

date

field-no-description|9

type

Name Value
1 COD
2 AH
3 GB DEPOSIT
4 GB WITHDRAW
5 MAIL
6 TRADE