| identifier |
varchar(50)
|
utf8mb4_bin
|
|
|
| steamname |
varchar(50)
|
utf8mb4_bin
|
|
|
| charidentifier |
int(11)
|
|
|
|
| group |
varchar(10)
|
utf8mb4_bin
|
|
|
| money |
double(11,2)
|
|
|
|
| gold |
double(11,2)
|
|
|
|
| rol |
double(11,2)
|
|
|
|
| xp |
int(11)
|
|
|
|
| healthouter |
int(4)
|
|
|
|
| healthinner |
int(4)
|
|
|
|
| staminaouter |
int(4)
|
|
|
|
| staminainner |
int(4)
|
|
|
|
| hours |
float
|
|
|
|
| LastLogin |
date
|
|
|
|
| inventory |
longtext
|
utf8mb4_bin
|
|
|
| slots |
decimal(20,1)
|
|
|
|
| job |
varchar(50)
|
utf8mb4_bin
|
|
|
| joblabel |
varchar(255)
|
utf8mb4_bin
|
|
|
| multijobs |
longtext
|
utf8mb4_bin
|
|
|
| meta |
varchar(255)
|
utf8mb4_bin
|
|
|
| firstname |
varchar(50)
|
utf8mb4_bin
|
|
|
| lastname |
varchar(50)
|
utf8mb4_bin
|
|
|
| character_desc |
mediumtext
|
utf8mb4_bin
|
|
|
| gender |
varchar(50)
|
utf8mb4_bin
|
|
|
| age |
int(11)
|
|
|
|
| nickname |
varchar(50)
|
utf8mb4_bin
|
|
|
| skinPlayer |
longtext
|
utf8mb4_bin
|
|
|
| compPlayer |
longtext
|
utf8mb4_bin
|
|
|
| compTints |
longtext
|
utf8mb4_bin
|
|
|
| jobgrade |
int(11)
|
|
|
|
| coords |
longtext
|
utf8mb4_bin
|
|
|
| status |
varchar(140)
|
utf8mb4_bin
|
|
|
| isdead |
tinyint(1)
|
|
|
|
| skills |
longtext
|
utf8mb4_bin
|
|
|
| walk |
varchar(50)
|
utf8mb4_bin
|
|
|
| gunsmith |
double(11,2)
|
|
|
|
| ammo |
longtext
|
utf8mb4_bin
|
|
|
| discordid |
varchar(255)
|
utf8mb4_bin
|
|
|
| lastjoined |
longtext
|
utf8mb4_bin
|
|
|
