logs_transactions Table¶
Money/mail transaction audit trail.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
time |
timestamp | NO | current_timestamp() | ||
type |
enum('Bid','Buyout','PlaceAuction','Trade','Mail','MailCOD') | YES | |||
guid1 |
int(11) unsigned | MUL | NO | 0 | |
money1 |
int(11) unsigned | NO | 0 | ||
spell1 |
int(11) unsigned | NO | 0 | ||
items1 |
varchar(255) | NO | '' | ||
guid2 |
int(11) unsigned | MUL | NO | 0 | |
money2 |
int(11) unsigned | NO | 0 | ||
spell2 |
int(11) unsigned | NO | 0 | ||
items2 |
varchar(255) | NO | '' |
Field Breakdown¶
time- Transaction timestamp.type- Transaction category.guid1- First side: character, money delta, spell, items payload.money1- First side: character, money delta, spell, items payload.spell1- First side: character, money delta, spell, items payload.items1- First side: character, money delta, spell, items payload.guid2- Second side mirrored fields.money2- Second side mirrored fields.spell2- Second side mirrored fields.items2- Second side mirrored fields.