#
# HLstats Game Support file for Natural Selection 2.0 
# ----------------------------------------------------
#
# To install, type:
# 
# 	mysql hlstats < gamesupport_ns.sql
#


#
# Game Definition
#
INSERT IGNORE INTO hlstats_Games VALUES ('ns','Natural Selection','0');


#
# Awards
#
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','slash','Vicious Kitty','killings by le Swipe',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','shotgun','Buckshot Masta','killings with the shotty',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','pistol','Harold Handgun Alert','asskickings by pistola',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','knife','Iron Chef Alert','vicious stabbings',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','grenade','absolute n00b','pathetic killings by n00b grenades',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','bitegun','Teething Tommy','killings with le jaw',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','bite2gun','Mouth Full','killings with le big jaw',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','leap','Tigger Alert','crushings by leap',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','divinewind','Silent but Violent','slayings by recal relief',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','sporegunprojectile','Left Feet Larry','killings with Lerk',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','devour','Hungry Hungry Hippo','killings by Ingestion',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','ns','spitgunspit','Masta Fatty','Marines too dumb to kill a gorge',NULL,NULL); 


#
# Actions
#
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'ns','structure_built',1,0,'','Structures Built','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'ns','structure_destroyed',2,0,'','Structures Destroyed','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'ns','research_start',3,0,'','Researches Performed','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'ns','recycle',-3,0,'','Structures Recycled','1','0','0','0');


#
# Teams
#
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'ns','alien1team','Aliens','0');
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'ns','marine1team','Marines','0');


#
# Roles
#
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','soldier','Soldier','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','commander','Commander','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','skulk','Skulk','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','gorge','Gorge','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','lerk','Lerk','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','fade','Fade','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','onos','Onos','0');
INSERT IGNORE INTO hlstats_Roles VALUES (NULL,'ns','gestate','Gestate','1');


#
# Weapons
#
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','welder','Marine Welder','3.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','knife','Marine Knife','4.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','pistol','Marine Pistol','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','machinegun','Marine Light Machine Gun','1.25');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','shotgun','Marine Shotgun','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','heavymachinegun','Marine Heavy Machine Gun','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','grenade','Marine Grenade Launcher','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','turret','Marine Turret','.75');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','siegeturret','Marine Siege Turret','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','resourcetower','Electrified Marine Resource Tower','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','team_turretfactor','Electric Turret Factory','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','team_advturretfactor','Electrified Marine Advance Turret Factory','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','acidrocket','Fade Acid Rocket','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','bitegun','Skulk Bite','1.25');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','charge','Onos Charge','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','claws','Onos Gore','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','divinewind','Skulk Xenocide','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','leap','Skulk Leap','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','spikegun','Lerk Spikes','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','spitgunspit','Gorge Spit','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','sporegunprojectile','Lerk Spores','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','swipe','Fade Slash','1.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','healingspray','Gorge Health Spray','3.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','parasite','Skulk Parasite','3.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','devour','Onos Devour','2.00');
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'ns','offensechamber','Offense Chamber','1.00');