-- 
-- Daten für Tabelle `hlstats_Actions`
-- 
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Begin_Bomb_Defuse_Without_Kit', 0, 0, 'CT', 'Start Defusing the Bomb Without a Defuse Kit', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Begin_Bomb_Defuse_With_Kit', 0, 0, 'CT', 'Start Defusing the Bomb With a Defuse Kit', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Planted_The_Bomb', 10, 2, 'TERRORIST', 'Plant the Bomb', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Defused_The_Bomb', 10, 0, 'CT', 'Defuse the Bomb', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Touched_A_Hostage', 0, 0, 'CT', 'Touch a Hostage', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Rescued_A_Hostage', 5, 1, 'CT', 'Rescue a Hostage', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Killed_A_Hostage', -15, 1, 'CT', 'Kill a Hostage', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Spawned_With_The_Bomb', 2, 0, 'TERRORIST', 'Spawn with the Bomb', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Got_The_Bomb', 2, 0, 'TERRORIST', 'Pick up the Bomb', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Dropped_The_Bomb', -2, 0, 'TERRORIST', 'Drop the Bomb', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'CTs_Win', 0, 2, 'CT', 'All Terrorists eliminated', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Terrorists_Win', 0, 2, 'TERRORIST', 'All Counter-Terrorists eliminated', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'All_Hostages_Rescued', 0, 10, 'CT', 'Counter-Terrorists rescued all the hostages', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Target_Bombed', 0, 5, 'TERRORIST', 'Terrorists bombed the target', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Bomb_Defused', 0, 5, 'CT', 'Counter-Terrorists defused the bomb', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Escaped_As_VIP', 0, 10, 'CT', 'VIP escaped', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Assassinated_The_VIP', 0, 6, 'TERRORIST', 'Terrorists assassinated the VIP', '', '', '1', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'Became_VIP', 1, 0, 'CT', 'Become the VIP', '1', '', '', '', 0);
INSERT IGNORE INTO `hlstats_Actions` VALUES (NULL,'css2', 'headshot', 1, 0, '', 'Headshot', '1', '', '', '', 0);


-- 
-- Daten für Tabelle `hlstats_Awards`
-- 
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'O', 'css2', 'Defused_The_Bomb', 'Top Defuser', 'bomb defusions', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'O', 'css2', 'Planted_The_Bomb', 'Top Demolitionist', 'bomb plantings', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'O', 'css2', 'Rescued_A_Hostage','Top Hostage Rescuer','hostages rescued',NULL,NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'elite', 'Dual Berretta Elites', 'kills with elite', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'knife', 'Knife Maniac', 'knifings', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'p90', 'P90', 'kills with p90', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'deagle', 'Desert Eagle', 'kills with deagle', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'm3', 'Shotgun', 'kills with m3 shotgun', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'usp', 'USP Master', 'kills with usp', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'm4a1', 'Colt M4A1 Carbine', 'kills with m4a1', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'glock', 'Glock', 'kills with glock', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'ak47', 'AK47', 'kills with ak47', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'famas', 'Fusil Automatique', 'kills with famas', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'galil', 'Galil', 'kills with galil', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'latency', 'Best Latency', 'ms average connection', NULL, NULL);
INSERT IGNORE INTO `hlstats_Awards` VALUES (NULL, 'W', 'css2', 'awp', 'AWP', 'kills with awp', NULL, NULL);

-- 
-- Daten für Tabelle `hlstats_Games`
-- 
INSERT IGNORE INTO `hlstats_Games` VALUES ('css2', 'Counter-Strike: Source', '0');

-- 
-- Daten für Tabelle `hlstats_Teams`
-- 
INSERT IGNORE INTO `hlstats_Teams` VALUES (NULL, 'css2', 'TERRORIST', 'Terrorist', '0');
INSERT IGNORE INTO `hlstats_Teams` VALUES (NULL, 'css2', 'CT', 'Counter-Terrorist', '0');
INSERT IGNORE INTO `hlstats_Teams` VALUES (NULL, 'css2', 'SPECTATOR', 'Spectator', '0');



-- 
-- Daten für Tabelle `hlstats_Weapons`
-- 
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'knife', 'Bundeswehr Advanced Combat Knife', 2.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'usp', 'H&K USP .45 Tactical', 1.40, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'glock', 'Glock 18 Select Fire', 1.40, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'deagle', 'Desert Eagle .50AE', 1.20, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'p228', 'Sig Sauer P-228', 1.50, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'm3', 'Benelli M3 Super 90 Combat', 1.20, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'xm1014', 'Benelli/H&K M4 Super 90 XM1014', 1.10, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'mp5navy', 'H&K MP5-Navy', 1.20, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'tmp', 'Steyr Tactical Machine Pistol', 1.50, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'p90', 'FN P90', 1.20, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'm4a1', 'Colt M4A1 Carbine', 1.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'ak47', 'Kalashnikov AK-47', 1.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'sg552', 'Sig Sauer SG-552 Commando', 1.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'scout', 'Steyr Scout', 1.10, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'awp', 'Arctic Warfare Magnum (Police)', 1.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'g3sg1', 'H&K G3/SG1 Sniper Rifle', 0.80, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'm249', 'M249 PARA Light Machine Gun', 1.20, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'hegrenade', 'High Explosive Grenade', 1.80, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'flashbang', 'Flashbang', 5.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'elite', 'Dual Beretta 96G Elite', 1.40, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'aug', 'Steyr Aug', 1.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'mac10', 'Ingram MAC-10', 1.50, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'fiveseven', 'FN Five-Seven', 1.50, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'ump45', 'H&K UMP45', 1.20, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'sg550', 'Sig SG-550 Sniper', 0.80, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'famas', 'Fusil Automatique', 1.00, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'galil', 'Galil', 1.10, 0, 0);
INSERT IGNORE INTO `hlstats_Weapons` VALUES (NULL, 'css2', 'smokegrenade_projectile', 'Smoke Grenade', 5.00, 0, 0);
