CREATE TABLE `aat_totaltracker` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `online_offline` int(5) NOT NULL default '0',
  `honor` int(11) NOT NULL default '0',
  `score` int(20) NOT NULL default '0',
  `goals` int(20) NOT NULL default '0',
  `leader` int(20) NOT NULL default '0',
  `enemy` int(20) NOT NULL default '0',
  `kia` int(20) NOT NULL default '0',
  `roe` int(20) NOT NULL default '0',
  `fragrate` float NOT NULL default '0',
  `score_last` int(5) NOT NULL default '0',
  `goals_last` int(5) NOT NULL default '0',
  `leader_last` int(5) NOT NULL default '0',
  `enemy_last` int(5) NOT NULL default '0',
  `kia_last` int(5) NOT NULL default '0',
  `roe_last` int(5) NOT NULL default '0',
  `date` varchar(200) NOT NULL default '-',
  `tracker_start` varchar(200) NOT NULL default '-',
  `total_time_played` int(15) NOT NULL default '0',
  `hostname` varchar(200) NOT NULL default '',
  `hostid` int(11) NOT NULL default '0',
  `border` int(20) NOT NULL default '0',
  `bridge_crossing` int(20) NOT NULL default '0',
  `bridge_se` int(20) NOT NULL default '0',
  `collapsed_tunnel` int(20) NOT NULL default '0',
  `dusk` int(20) NOT NULL default '0',
  `fls_assault` int(20) NOT NULL default '0',
  `headquarters_raid` int(20) NOT NULL default '0',
  `insurgent_camp` int(20) NOT NULL default '0',
  `jrtc_farm_raid` int(20) NOT NULL default '0',
  `mountain_ambush` int(20) NOT NULL default '0',
  `mountain_pass_se` int(20) NOT NULL default '0',
  `mountain_pass` int(20) NOT NULL default '0',
  `mout_mckenna` int(20) NOT NULL default '0',
  `pipeline` int(20) NOT NULL default '0',
  `radio_tower` int(20) NOT NULL default '0',
  `river_basin` int(20) NOT NULL default '0',
  `sf_arctic` int(20) NOT NULL default '0',
  `sf_blizzard` int(20) NOT NULL default '0',
  `sf_courtyard` int(20) NOT NULL default '0',
  `sf_csar` int(20) NOT NULL default '0',
  `sf_dockside` int(20) NOT NULL default '0',
  `sf_extraction` int(20) NOT NULL default '0',
  `sf_hospital` int(20) NOT NULL default '0',
  `sf_oasis` int(20) NOT NULL default '0',
  `sf_pcr` int(20) NOT NULL default '0',
  `sf_pipeline` int(20) NOT NULL default '0',
  `sf_recon` int(20) NOT NULL default '0',
  `sf_sandstorm` int(20) NOT NULL default '0',
  `sf_taiga` int(20) NOT NULL default '0',
  `sf_village` int(20) NOT NULL default '0',
  `sf_water_treatment` int(20) NOT NULL default '0',
  `swamp_raid` int(20) NOT NULL default '0',
  `urban_assault` int(20) NOT NULL default '0',
  `weapons_cache_se` int(20) NOT NULL default '0',
  `weapons_cache` int(20) NOT NULL default '0',
  `woodland_outpost` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Americas Army 2.5 Tracker General' AUTO_INCREMENT=15900 ;