All pastes #361886 Raw Edit

DarkRaverNL

public sql v1 · immutable
·published 2007-02-18 12:00 UTC
rendered paste body
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 ;