CREATE TABLE `livemap_data` (
  `CSteamID` varchar(32) NOT NULL,
  `character_name` varchar(100) DEFAULT NULL,
  `display_name` varchar(100) DEFAULT NULL,
  `steam_group_id` varchar(32) DEFAULT NULL,
  `steam_avatar_medium` varchar(255) DEFAULT NULL,
  `server_id` varchar(32) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `ping` decimal(8,6) DEFAULT NULL,
  `is_pro` tinyint(1) DEFAULT NULL,
  `is_admin` tinyint(1) DEFAULT NULL,
  `is_god` tinyint(1) DEFAULT NULL,
  `is_vanished` tinyint(1) DEFAULT NULL,
  `in_vehicle` tinyint(1) DEFAULT NULL,
  `vehicle_is_driver` tinyint(1) DEFAULT NULL,
  `vehicle_instance_id` int(8) DEFAULT NULL,
  `vehicle_id` int(8) DEFAULT NULL,
  `vehicle_fuel` int(8) DEFAULT NULL,
  `vehicle_health` int(8) DEFAULT NULL,
  `vehicle_headlights_on` tinyint(1) DEFAULT NULL,
  `vehicle_taillights_on` tinyint(1) DEFAULT NULL,
  `vehicle_sirens_on` tinyint(1) DEFAULT NULL,
  `vehicle_speed` int(8) DEFAULT NULL,
  `vehicle_has_battery` tinyint(1) DEFAULT NULL,
  `vehicle_battery_charge` int(8) DEFAULT NULL,
  `vehicle_exploded` tinyint(1) DEFAULT NULL,
  `vehicle_locked` tinyint(1) DEFAULT NULL,
  `position` varchar(32) DEFAULT NULL,
  `rotation` float(7,4) DEFAULT NULL,
  `is_dead` tinyint(1) DEFAULT NULL,
  `last_dead_position` varchar(32) DEFAULT NULL,
  `skin_color` varchar(32) DEFAULT NULL,
  `hair` int(8) DEFAULT NULL,
  `face` int(8) DEFAULT NULL,
  `beard` int(8) DEFAULT NULL,
  `hat` int(8) DEFAULT NULL,
  `glasses` int(8) DEFAULT NULL,
  `mask` int(8) DEFAULT NULL,
  `is_bleeding` tinyint(1) DEFAULT NULL,
  `is_broken` tinyint(1) DEFAULT NULL,
  `health` int(8) DEFAULT NULL,
  `stamina` int(8) DEFAULT NULL,
  `hunger` int(8) DEFAULT NULL,
  `thirst` int(8) DEFAULT NULL,
  `infection` int(8) DEFAULT NULL,
  `experience` int(8) DEFAULT NULL,
  `reputation` int(8) DEFAULT NULL,
  `skill_agriculture` int(8) DEFAULT NULL,
  `skill_cardio` int(8) DEFAULT NULL,
  `skill_cooking` int(8) DEFAULT NULL,
  `skill_crafting` int(8) DEFAULT NULL,
  `skill_dexerity` int(8) DEFAULT NULL,
  `skill_diving` int(8) DEFAULT NULL,
  `skill_engineer` int(8) DEFAULT NULL,
  `skill_exercise` int(8) DEFAULT NULL,
  `skill_fishing` int(8) DEFAULT NULL,
  `skill_healing` int(8) DEFAULT NULL,
  `skill_immunity` int(8) DEFAULT NULL,
  `skill_mechanic` int(8) DEFAULT NULL,
  `skill_outdoors` int(8) DEFAULT NULL,
  `skill_overkill` int(8) DEFAULT NULL,
  `skill_parkour` int(8) DEFAULT NULL,
  `skill_sharpshooter` int(8) DEFAULT NULL,
  `skill_sneakybeaky` int(8) DEFAULT NULL,
  `skill_strength` int(8) DEFAULT NULL,
  `skill_survival` int(8) DEFAULT NULL,
  `skill_toughness` int(8) DEFAULT NULL,
  `skill_vitality` int(8) DEFAULT NULL,
  `skill_warmblooded` int(8) DEFAULT NULL,
  `is_hidden` tinyint(1) DEFAULT '0',
  `last_refresh` timestamp DEFAULT '0',
  `last_connect` timestamp DEFAULT '0',
  `last_disconnect` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;