|
id
|
int(11)
|
|
|
|
|
player_id
|
int(11)
|
|
|
|
|
player_name
|
varchar(50)
|
|
|
|
|
player_db_id
|
int(11)
|
|
|
|
|
social_id
|
varchar(50)
|
|
|
|
|
first_name
|
varchar(50)
|
|
|
|
|
last_name
|
varchar(50)
|
|
|
|
|
birth_date
|
date
|
|
|
|
|
height
|
int(11)
|
|
|
170
|
|
origin
|
varchar(100)
|
|
|
|
|
gender
|
tinyint(4)
|
|
|
0
|
|
model
|
varchar(100)
|
|
|
mp_m_freemode_01
|
|
face_mother
|
tinyint(4)
|
|
|
0
|
|
face_father
|
tinyint(4)
|
|
|
0
|
|
face_mix
|
float
|
|
|
0.5
|
|
skin_mother
|
tinyint(4)
|
|
|
0
|
|
skin_father
|
tinyint(4)
|
|
|
0
|
|
skin_mix
|
float
|
|
|
0.5
|
|
hair_style
|
tinyint(4)
|
|
|
0
|
|
hair_color
|
tinyint(4)
|
|
|
0
|
|
hair_highlight
|
tinyint(4)
|
|
|
0
|
|
eyebrow_style
|
tinyint(4)
|
|
|
0
|
|
eyebrow_color
|
tinyint(4)
|
|
|
0
|
|
eyebrow_opacity
|
float
|
|
|
1
|
|
beard_style
|
tinyint(4)
|
|
|
0
|
|
beard_color
|
tinyint(4)
|
|
|
0
|
|
beard_opacity
|
float
|
|
|
1
|
|
eye_color
|
tinyint(4)
|
|
|
0
|
|
makeup_style
|
tinyint(4)
|
|
|
0
|
|
makeup_color
|
tinyint(4)
|
|
|
0
|
|
makeup_opacity
|
float
|
|
|
1
|
|
lipstick_style
|
tinyint(4)
|
|
|
0
|
|
lipstick_color
|
tinyint(4)
|
|
|
0
|
|
lipstick_opacity
|
float
|
|
|
1
|
|
torso
|
tinyint(4)
|
|
|
0
|
|
torso_texture
|
tinyint(4)
|
|
|
0
|
|
legs
|
tinyint(4)
|
|
|
0
|
|
legs_texture
|
tinyint(4)
|
|
|
0
|
|
feet
|
tinyint(4)
|
|
|
0
|
|
feet_texture
|
tinyint(4)
|
|
|
0
|
|
accessories
|
tinyint(4)
|
|
|
0
|
|
accessories_texture
|
tinyint(4)
|
|
|
0
|
|
undershirt
|
tinyint(4)
|
|
|
0
|
|
undershirt_texture
|
tinyint(4)
|
|
|
0
|
|
hats
|
tinyint(4)
|
|
|
-1
|
|
hats_texture
|
tinyint(4)
|
|
|
0
|
|
glasses
|
tinyint(4)
|
|
|
-1
|
|
glasses_texture
|
tinyint(4)
|
|
|
0
|
|
last_pos_x
|
float
|
|
|
|
|
last_pos_y
|
float
|
|
|
|
|
last_pos_z
|
float
|
|
|
|
|
last_heading
|
float
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|