| identifier |
varchar(60)
|
utf8_general_ci
|
|
|
| ssn |
varchar(11)
|
utf8_general_ci
|
|
|
| accounts |
longtext
|
utf8_general_ci
|
|
|
| group |
varchar(50)
|
utf8_general_ci
|
|
|
| inventory |
longtext
|
utf8_general_ci
|
|
|
| job |
varchar(20)
|
utf8_general_ci
|
|
|
| job_grade |
int(11)
|
|
|
|
| loadout |
longtext
|
utf8_general_ci
|
|
|
| metadata |
longtext
|
utf8_general_ci
|
|
|
| position |
longtext
|
utf8_general_ci
|
|
|
| firstname |
varchar(16)
|
utf8_general_ci
|
|
|
| lastname |
varchar(16)
|
utf8_general_ci
|
|
|
| dateofbirth |
varchar(10)
|
utf8_general_ci
|
|
|
| sex |
varchar(1)
|
utf8_general_ci
|
|
|
| height |
int(11)
|
|
|
|
| skin |
longtext
|
utf8_general_ci
|
|
|
| status |
longtext
|
utf8_general_ci
|
|
|
| is_dead |
tinyint(1)
|
|
|
|
| id |
int(11)
|
|
|
|
| disabled |
tinyint(1)
|
|
|
|
| last_property |
varchar(255)
|
utf8_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| last_seen |
timestamp
|
|
|
|
| phone_number |
varchar(20)
|
utf8_general_ci
|
|
|
| pincode |
int(11)
|
|
|
|
| jail_time |
int(11)
|
|
|
|
| aranma |
mediumtext
|
utf8_general_ci
|
|
|
| photo |
mediumtext
|
utf8_general_ci
|
|
|
| job2 |
varchar(32)
|
utf8_general_ci
|
|
|
| job2_grade |
varchar(32)
|
utf8_general_ci
|
|
|
| tattoos |
longtext
|
utf8_general_ci
|
|
|
| image |
varchar(250)
|
utf8mb4_unicode_ci
|
|
|
| dangerous |
tinyint(4)
|
|
|
|
| wanted |
tinyint(4)
|
|
|
|
| skills |
longtext
|
utf8_general_ci
|
|
|
| skillpoint |
varchar(50)
|
utf8_general_ci
|
|
|
