-- 
-- Daten für Tabelle `hlstats_Actions`
-- 
INSERT IGNORE INTO hlstats_Actions VALUES (NULL, 'dods2', 'capblock', 6, 1, '', 'Capture Blocked', '1', '', '1', '', 0);
INSERT IGNORE INTO hlstats_Actions VALUES (NULL, 'dods2', 'captured_loc', 6, 1, '', 'Area Captured', '1', '', '1', '', 0);
INSERT IGNORE INTO hlstats_Actions VALUES (NULL, 'dods2', 'kill_planter', 2, 0, '', 'Bomb Planter Killed', '1', '', '', '', 0);
INSERT IGNORE INTO hlstats_Actions VALUES (NULL, 'dods2', 'bomb_defuse', 6, 1, '', 'Bomb Defused', '1', '', '1', '', 0);
INSERT IGNORE INTO hlstats_Actions VALUES (NULL, 'dods2', 'bomb_plant', 6, 1, '', 'Bomb Planted', '1', '', '1', '', 0);
INSERT IGNORE INTO hlstats_Actions VALUES (NULL, 'dods2', 'round_win', 0, 5, '', 'Round Win', '', '', '1', '', 0);


-- 
-- Daten für Tabelle `hlstats_Awards`
-- 
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','dods2','bomb_defuse', 'Top Defuser', 'bomb defusions', NULL, NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','dods2','bomb_plant', 'Top Demolitionist', 'bomb plantings', NULL, NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','dods2','kill_planter','Bomb Planter Killer','kills',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','amerknife','Backstabbing Beotch','kills with the American Knife',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','mp40','MP40 Hor','kills with the MP40 Machine Pistol',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','spade','Shovel God','kills with the spade',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','mp44','MP44 Hor','kills with the MP44 Assault Rifle',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','colt','Colt Freak','kills with the Colt .45 model 1911',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','garand','GarandMeister','kills with the M1 Garand Rifle',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','thompson','Thompson Hor','kills with the Thompson Submachine Gun',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','spring','Spring Sniper','snipings with the Springfield 03 Rifle',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','bar','Bar Browning Hor','kills with the BAR Browning Automatic Rifle',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','frag_us','McVeigh Alert','bombings with the U.S. Grenade',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','frag_ger','Grenade Freak','bombings with the German Grenade',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','bazooka','Bazooka Joe','kills with the Bazooka',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','pschreck','Panzerschreck Hans','kills with the Panzerschreck',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','latency','Best Latency','ms average connection',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','punch','Puncher','knock-outs',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','dods2','mg42','German Machine Hor','kills with the MG42',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','dods2','captured_loc','Area Captured','flags captured',NULL,NULL);


-- 
-- Daten für Tabelle `hlstats_Teams`
-- 
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'dods2','Allies','Allies','0');
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'dods2','Axis','Axis','0');
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'dods2','Spectators','Spectators','0');


-- 
-- Daten für Tabelle `hlstats_Games`
-- 
INSERT IGNORE INTO hlstats_Games VALUES ('dods2','Day of Defeat: Source','0');

-- 
-- Daten für Tabelle `hlstats_Roles`
-- 
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','Random','Random','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_allied_garand','American Rifleman','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_allied_thompson','American Master Sergeant','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_allied_heavy','American Support Infantry','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_allied_sniper','American Sniper','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_allied_mg','American Machine Gunner','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_allied_bazooka','American Bazooka ','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_axis_kar98','Axis Grenadier','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_axis_mp40','Axis Unteroffizier','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_axis_mp44','Axis Sturmtruppe','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_axis_sniper','Axis Scharfschütze','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_axis_mg42','Axis MG42-Schütze','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'dods2','#class_axis_pschreck','Axis Panzerschreck','0');


-- 
-- Daten für Tabelle `hlstats_Weapons`
-- 

INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'k98', 'Mauser Kar 98k', '1.30', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'mp40', 'MP40 Machine Pistol', '1.25', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'k98_scoped', 'Mauser Karbiner k98 Sniper Rifle', '1.50', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'mp44', 'MP44 Assault Rifle', '1.35', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'colt', 'Colt .45 model 1911', '1.60', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'riflegren_us', 'M1 Garand Rifle', '1.30', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'thompson', 'Thompson Submachine Gun', '1.25', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'spring', 'Springfield Rifle with Scope', '1.50', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'bar', 'BAR Browning Automatic Rifle', '1.20', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'frag_us', 'U.S. Grenade', '1.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'm1carbine', 'M1 Carbine', '1.20', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', '30cal', '.30 Caliber Machine Gun', '1.25', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'frag_ger', 'German Grenade', '1.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'spade', 'Spade Entrenchment Tool', '3.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'amerknife', 'U.S. Issue Knife', '3.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'bazooka', 'Bazooka', '2.25', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'pschreck', 'Panzerschreck', '2.25', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'riflegren_ger', 'German Rifle Grenade', '1.30', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'garand', 'M1 Garand Rifle', '1.30', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'p38', 'Pistol 38', '1.50', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'c96', 'Pistol c96', '1.50', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'punch', 'Butt Stock Hit', '3.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'mg42', 'MG42 Machine Gun', '1.20', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'smoke_ger', 'German Smoke Grenade', '5.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'smoke_us', 'U.S. Smoke Grenade', '5.00', 0, 0);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL, 'dods2', 'dod_bomb_target', 'TNT Bomb', '1.00', 0, 0);




