DROP TABLE IF EXISTS `rdf_data`.`games`;
CREATE TABLE  `rdf_data`.`games` (
				    `id` int(10) unsigned NOT NULL auto_increment,
				    `DateCreated` varchar(45) NOT NULL default '0',
				    `GameMode` varchar(45) NOT NULL default '0',
				    `GameName` varchar(45) NOT NULL default '0',
				    `MaxTimeFrame` varchar(45) NOT NULL default '0',
				    `MinTimeFrame` varchar(45) NOT NULL default '0',
				    `NumDivisions` varchar(45) NOT NULL default '0',
				    `SCERTGameID` varchar(45) NOT NULL default '0',
				    `SVOGameID` varchar(45) NOT NULL default '0',
				    `TimePerDivision` varchar(45) NOT NULL default '0',
				    PRIMARY KEY  (`id`)
				  ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;



DROP TABLE IF EXISTS `rdf_data`.`gamers`;
CREATE TABLE  `rdf_data`.`gamers` (
				     `id` int(10) unsigned NOT NULL auto_increment,
				     `userID` int(10) unsigned NOT NULL default '0',
				     `gid` int(10) unsigned NOT NULL default '0',
				     `username` varchar(45) NOT NULL default '0',
				     `wins` tinyint(3) unsigned NOT NULL default '0',
				     `losses` tinyint(3) unsigned NOT NULL default '0',
				     `kills` tinyint(3) unsigned NOT NULL default '0',
				     `deaths` tinyint(3) unsigned NOT NULL default '0',
				     `assists` tinyint(3) unsigned NOT NULL default '0',
				     `money` tinyint(3) unsigned NOT NULL default '0',
				     `level` tinyint(3) unsigned NOT NULL default '0',
				     `rating` tinyint(3) unsigned NOT NULL default '0',
				     `counter` tinyint(3) unsigned NOT NULL default '0',
				     `headshots` tinyint(3) unsigned NOT NULL default '0',
				     `stealthKills` tinyint(3) unsigned NOT NULL default '0',
				     `meleeKills` tinyint(3) unsigned NOT NULL default '0',
				     `mapID` tinyint(3) unsigned NOT NULL default '0',
				     `modelID` tinyint(3) unsigned NOT NULL default '0',
				     `shotsFired` tinyint(3) unsigned NOT NULL default '0',
				     `rifleKills` tinyint(3) unsigned NOT NULL default '0',
				     `bullseyeKills` tinyint(3) unsigned NOT NULL default '0',
				     `shotgunKills` tinyint(3) unsigned NOT NULL default '0',
				     `sniperKills` tinyint(3) unsigned NOT NULL default '0',
				     `augerKills` tinyint(3) unsigned NOT NULL default '0',
				     `flameKills` tinyint(3) unsigned NOT NULL default '0',
				     `rocketKills` tinyint(3) unsigned NOT NULL default '0',
				     `arcKills` tinyint(3) unsigned NOT NULL default '0',
				     `fragKills` tinyint(3) unsigned NOT NULL default '0',
				     `hedgehogKills` tinyint(3) unsigned NOT NULL default '0',
				     `airFuelKills` tinyint(3) unsigned NOT NULL default '0',
				     `rifleAsst` tinyint(3) unsigned NOT NULL default '0',
				     `bullseyeAsst` tinyint(3) unsigned NOT NULL default '0',
				     `shotgunAsst` tinyint(3) unsigned NOT NULL default '0',
				     `sniperAsst` tinyint(3) unsigned NOT NULL default '0',
				     `augerAsst` tinyint(3) unsigned NOT NULL default '0',
				     `flameAsst` tinyint(3) unsigned NOT NULL default '0',
				     `rocketAsst` tinyint(3) unsigned NOT NULL default '0',
				     `arcAsst` tinyint(3) unsigned NOT NULL default '0',
				     `fragAsst` tinyint(3) unsigned NOT NULL default '0',
				     `hedgehogAsst` tinyint(3) unsigned NOT NULL default '0',
				     `airFuelAsst` tinyint(3) unsigned NOT NULL default '0',
				     `rifleHits` tinyint(3) unsigned NOT NULL default '0',
				     `bullseyeHits` tinyint(3) unsigned NOT NULL default '0',
				     `shotgunHits` tinyint(3) unsigned NOT NULL default '0',
				     `sniperHits` tinyint(3) unsigned NOT NULL default '0',
				     `augerHits` tinyint(3) unsigned NOT NULL default '0',
				     `flameHits` tinyint(3) unsigned NOT NULL default '0',
				     `rocketHits` tinyint(3) unsigned NOT NULL default '0',
				     `arcHits` tinyint(3) unsigned NOT NULL default '0',
				     `fragHits` tinyint(3) unsigned NOT NULL default '0',
				     `hedgehogHits` tinyint(3) unsigned NOT NULL default '0',
				     `airfuelHits` tinyint(3) unsigned NOT NULL default '0',
				     `rifleMiss` tinyint(3) unsigned NOT NULL default '0',
				     `bullseyeMiss` tinyint(3) unsigned NOT NULL default '0',
				     `shotgunMiss` tinyint(3) unsigned NOT NULL default '0',
				     `sniperMiss` tinyint(3) unsigned NOT NULL default '0',
				     `augerMiss` tinyint(3) unsigned NOT NULL default '0',
				     `flameMiss` tinyint(3) unsigned NOT NULL default '0',
				     `rocketMiss` tinyint(3) unsigned NOT NULL default '0',
				     `arcMiss` tinyint(3) unsigned NOT NULL default '0',
				     `fragMiss` tinyint(3) unsigned NOT NULL default '0',
				     `hedgeHogMiss` tinyint(3) unsigned NOT NULL default '0',
				     `airfuelMiss` tinyint(3) unsigned NOT NULL default '0',
				     `rifleDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `bullseyeDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `shotgunDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `sniperDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `augerDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `flameDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `rocketDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `arcDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `fragDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `hedgehogDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `airfuelDeaths` tinyint(3) unsigned NOT NULL default '0',
				     `killSpree` tinyint(3) unsigned NOT NULL default '0',
				     `lifeSpan` tinyint(3) unsigned NOT NULL default '0',
				     `teamKills` tinyint(3) unsigned NOT NULL default '0',
				     `teamMateKills` tinyint(3) unsigned NOT NULL default '0',
				     `nodes` tinyint(3) unsigned NOT NULL default '0',
				     `recapNodes` tinyint(3) unsigned NOT NULL default '0',
				     `defKills` tinyint(3) unsigned NOT NULL default '0',
				     `reactor` tinyint(3) unsigned NOT NULL default '0',
				     `timeHuman` tinyint(3) unsigned NOT NULL default '0',
				     `timeHybrid` tinyint(3) unsigned NOT NULL default '0',
				     PRIMARY KEY  (`id`)
				   ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

