| identifier |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| ssn |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| accounts |
longtext
|
utf8mb4_general_ci
|
|
|
| group |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| inventory |
longtext
|
utf8mb4_general_ci
|
|
|
| job |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| job_grade |
int(11)
|
|
|
|
| loadout |
longtext
|
utf8mb4_general_ci
|
|
|
| metadata |
longtext
|
utf8mb4_general_ci
|
|
|
| position |
longtext
|
utf8mb4_general_ci
|
|
|
| firstname |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| lastname |
varchar(16)
|
utf8mb4_general_ci
|
|
|
| dateofbirth |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| sex |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| height |
int(11)
|
|
|
|
| skin |
longtext
|
utf8mb4_general_ci
|
|
|
| status |
longtext
|
utf8mb4_general_ci
|
|
|
| is_dead |
tinyint(1)
|
|
|
|
| id |
int(11)
|
|
|
|
| disabled |
tinyint(1)
|
|
|
|
| last_property |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| last_seen |
timestamp
|
|
|
|
| phone_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| pincode |
int(11)
|
|
|
|
| isDead |
tinyint(1)
|
|
|
|
| backpack |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| bagmodel |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| bagcolor |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| bagitemname |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| inside |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| crafting_skill |
longtext
|
utf8mb4_general_ci
|
|
|
| tattoos |
longtext
|
utf8mb4_general_ci
|
|
|
