#
# Table structure for table `pstats_clans`
#
# Creation: Apr 26, 2004 at 10:52 PM
# Last update: May 02, 2004 at 09:04 PM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_clans` (
  `clanid` int(10) unsigned NOT NULL auto_increment,
  `clantag` varchar(32) NOT NULL default '',
  `clanupdatetime` int(10) unsigned NOT NULL default '0',
  `claninactive` tinyint(1) unsigned NOT NULL default '0',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`clanid`),
  UNIQUE KEY `clantag` (`clantag`),
  KEY `gametype` (`gametype`,`modtype`),
  KEY `claninactive` (`claninactive`)
) TYPE=MyISAM COMMENT='Registered clans' ;
# --------------------------------------------------------

CREATE TABLE `pstats_clans_profile` (
  `clanprofileid` int(10) unsigned NOT NULL auto_increment,
  `clantag` varchar(32) NOT NULL default '',
  `clanname` varchar(128) NOT NULL default '',
  `clanlogo` text NOT NULL,
  `clanemail` varchar(128) NOT NULL default '',
  `clanicon` varchar(64) NOT NULL default '',
  `clanwebsite` varchar(255) NOT NULL default '',
  `clanlocked` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`clanprofileid`),
  UNIQUE KEY `clantag` (`clantag`)
) TYPE=MyISAM COMMENT='Registered clan profiles';
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_awards`
#
# Creation: May 06, 2004 at 11:35 AM
# Last update: May 06, 2004 at 11:35 AM
# Last check: May 06, 2004 at 11:35 AM
#

CREATE TABLE `pstats_defs_awards` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM PACK_KEYS=0 COMMENT='Award name definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_events`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:14 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_defs_events` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `type` enum('unknown','player','team','world','server') NOT NULL default 'unknown',
  `name` varchar(64) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM COMMENT='Event definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_gametypes`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 29, 2004 at 11:54 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_defs_gametypes` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Gametype definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_maps`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:47 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_defs_maps` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM COMMENT='Map definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_modtypes`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 29, 2004 at 11:54 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_defs_modtypes` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`)
) TYPE=MyISAM COMMENT='MODtype definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_roles`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_defs_roles` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(128) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM COMMENT='Role definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_teams`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_defs_teams` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(128) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM COMMENT='Team definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_defs_weapons`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_defs_weapons` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `desc` varchar(128) NOT NULL default '',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM COMMENT='Weapon definitions' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_event_props`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_event_props` (
  `id` int(10) unsigned NOT NULL default '0',
  `var` varchar(32) NOT NULL default '',
  `val` varchar(255) NOT NULL default '',
  KEY `prop_id` (`id`)
) TYPE=MyISAM COMMENT='Extra event properties';
# --------------------------------------------------------

#
# Table structure for table `pstats_events`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_events` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `timestamp` int(10) unsigned NOT NULL default '0',
  `eventid` smallint(5) unsigned NOT NULL default '0',
  `plrid1` mediumint(8) unsigned NOT NULL default '0',
  `plrid2` mediumint(8) unsigned NOT NULL default '0',
  `weapon` smallint(5) unsigned NOT NULL default '0',
  `map` smallint(5) unsigned NOT NULL default '0',
  `team` smallint(5) unsigned NOT NULL default '0',
  `propid` int(10) unsigned NOT NULL default '0',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `plrid1` (`plrid1`),
  KEY `plrid2` (`plrid2`)
) TYPE=MyISAM COMMENT='Player event history (optional)' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_gameawards`
#
# Creation: May 06, 2004 at 11:46 AM
# Last update: May 06, 2004 at 11:46 AM
# Last check: May 06, 2004 at 11:46 AM
#

CREATE TABLE `pstats_gameawards` (
  `gameawardid` int(10) unsigned NOT NULL auto_increment,
  `awardid` int(10) unsigned NOT NULL default '0',
  `awardtype` enum('weekly','monthly') NOT NULL default 'weekly',
  `year` smallint(4) unsigned NOT NULL default '0',
  `month` tinyint(2) unsigned NOT NULL default '0',
  `day` tinyint(2) unsigned NOT NULL default '0',
  `week` tinyint(2) unsigned NOT NULL default '0',
  `format` varchar(128) NOT NULL default '%d',
  PRIMARY KEY  (`gameawardid`),
  KEY `YMDW` (`year`,`month`,`day`,`week`),
  KEY `awardtype` (`awardtype`)
) TYPE=MyISAM PACK_KEYS=0 COMMENT='Global awards for players' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_gameawards_plrs`
#
# Creation: May 06, 2004 at 11:44 AM
# Last update: May 06, 2004 at 11:44 AM
# Last check: May 06, 2004 at 11:44 AM
#

CREATE TABLE `pstats_gameawards_plrs` (
  `gameawardid` int(10) unsigned NOT NULL default '0',
  `plrid` int(10) unsigned NOT NULL default '0',
  `awardrank` tinyint(3) unsigned NOT NULL default '0',
  `awardvalue` float NOT NULL default '0',
  KEY `gameawardid` (`gameawardid`),
  KEY `plrid` (`plrid`,`awardrank`)
) TYPE=MyISAM COMMENT='Game award player list';
# --------------------------------------------------------

#
# Table structure for table `pstats_gamemaps`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
#

CREATE TABLE `pstats_gamemaps` (
  `gamemapid` int(10) unsigned NOT NULL auto_increment,
  `mapid` smallint(5) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `games` smallint(5) unsigned NOT NULL default '0',
  `rounds` smallint(5) unsigned NOT NULL default '0',
  `kills` smallint(5) unsigned NOT NULL default '0',
  `suicides` smallint(5) unsigned NOT NULL default '0',
  `ffkills` smallint(5) unsigned NOT NULL default '0',
  `plrconnects` smallint(5) unsigned NOT NULL default '0',
  `onlinetime` int(10) unsigned NOT NULL default '0',
  `lasttime` int(10) unsigned NOT NULL default '0',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gamemapid`),
  KEY `mapdays` (`statdate`,`mapid`),
  KEY `mapid` (`mapid`),
  KEY `gametype` (`gametype`,`modtype`)
) TYPE=MyISAM COMMENT='Global map data' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_gamemaps_cstrike`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
#

CREATE TABLE `pstats_gamemaps_cstrike` (
  `gamemapid` int(10) unsigned NOT NULL default '0',
  `ctkills` smallint(5) unsigned NOT NULL default '0',
  `terroristkills` smallint(5) unsigned NOT NULL default '0',
  `ctdeaths` smallint(5) unsigned NOT NULL default '0',
  `terroristdeaths` smallint(5) unsigned NOT NULL default '0',
  `joinedct` smallint(5) unsigned NOT NULL default '0',
  `joinedterrorist` smallint(5) unsigned NOT NULL default '0',
  `bombdefuseattempts` smallint(5) unsigned NOT NULL default '0',
  `bombdefused` smallint(5) unsigned NOT NULL default '0',
  `bombexploded` smallint(5) unsigned NOT NULL default '0',
  `bombplanted` smallint(5) unsigned NOT NULL default '0',
  `bombrunner` smallint(5) unsigned NOT NULL default '0',
  `killedhostages` smallint(5) unsigned NOT NULL default '0',
  `rescuedhostages` smallint(5) unsigned NOT NULL default '0',
  `touchedhostages` smallint(5) unsigned NOT NULL default '0',
  `vipescaped` smallint(5) unsigned NOT NULL default '0',
  `vipkilled` smallint(5) unsigned NOT NULL default '0',
  `ctwon` smallint(5) unsigned NOT NULL default '0',
  `ctlost` smallint(5) unsigned NOT NULL default '0',
  `terroristwon` smallint(5) unsigned NOT NULL default '0',
  `terroristlost` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gamemapid`)
) TYPE=MyISAM COMMENT='Global map data (cstrike)';
# --------------------------------------------------------

#
# Table structure for table `pstats_gamemaps_dod`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_gamemaps_dod` (
  `gamemapid` int(10) unsigned NOT NULL default '0',
  `allieskills` smallint(5) unsigned NOT NULL default '0',
  `axiskills` smallint(5) unsigned NOT NULL default '0',
  `alliesdeaths` smallint(5) unsigned NOT NULL default '0',
  `axisdeaths` smallint(5) unsigned NOT NULL default '0',
  `joinedallies` smallint(5) unsigned NOT NULL default '0',
  `joinedaxis` smallint(5) unsigned NOT NULL default '0',
  `allieswon` smallint(5) unsigned NOT NULL default '0',
  `axiswon` smallint(5) unsigned NOT NULL default '0',
  `allieslost` smallint(5) unsigned NOT NULL default '0',
  `axislost` smallint(5) unsigned NOT NULL default '0',
  `tnt` smallint(5) unsigned NOT NULL default '0',
  `tntused` smallint(5) unsigned NOT NULL default '0',
  `alliesflagscaptured` smallint(5) unsigned NOT NULL default '0',
  `alliesareascaptured` smallint(5) unsigned NOT NULL default '0',
  `axisflagscaptured` smallint(5) unsigned NOT NULL default '0',
  `axisareascaptured` smallint(5) unsigned NOT NULL default '0',
  `flagscaptured` smallint(5) unsigned NOT NULL default '0',
  `areascaptured` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gamemapid`)
) TYPE=MyISAM COMMENT='Global map data (dod)';
# --------------------------------------------------------

#
# Table structure for table `pstats_gamemaps_ns`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_gamemaps_ns` (
  `gamemapid` int(10) unsigned NOT NULL default '0',
  `marinewon` smallint(6) NOT NULL default '0',
  `marinelost` smallint(6) NOT NULL default '0',
  `alienwon` smallint(6) NOT NULL default '0',
  `alienlost` smallint(6) NOT NULL default '0',
  `marinekills` smallint(6) NOT NULL default '0',
  `alienkills` smallint(6) NOT NULL default '0',
  `marinedeaths` smallint(6) NOT NULL default '0',
  `aliendeaths` smallint(6) NOT NULL default '0',
  `joinedmarine` smallint(6) NOT NULL default '0',
  `joinedalien` smallint(6) NOT NULL default '0',
  `structuresbuilt` smallint(6) NOT NULL default '0',
  `structuresdestroyed` smallint(6) NOT NULL default '0',
  `structuresrecycled` smallint(6) NOT NULL default '0',
  `struct_alienresourcetower` smallint(6) NOT NULL default '0',
  `struct_defensechamber` smallint(6) NOT NULL default '0',
  `struct_genericammo` smallint(6) NOT NULL default '0',
  `struct_health` smallint(6) NOT NULL default '0',
  `struct_heavyarmor` smallint(6) NOT NULL default '0',
  `struct_jetpack` smallint(6) NOT NULL default '0',
  `struct_movementchamber` smallint(6) NOT NULL default '0',
  `struct_offensechamber` smallint(6) NOT NULL default '0',
  `struct_phasegate` smallint(6) NOT NULL default '0',
  `struct_resourcetower` smallint(6) NOT NULL default '0',
  `struct_scan` smallint(6) NOT NULL default '0',
  `struct_sensorychamber` smallint(6) NOT NULL default '0',
  `struct_siegeturret` smallint(6) NOT NULL default '0',
  `struct_armory` smallint(6) NOT NULL default '0',
  `struct_armslab` smallint(6) NOT NULL default '0',
  `struct_command` smallint(6) NOT NULL default '0',
  `struct_hive` smallint(6) NOT NULL default '0',
  `struct_infportal` smallint(6) NOT NULL default '0',
  `struct_observatory` smallint(6) NOT NULL default '0',
  `struct_prototypelab` smallint(6) NOT NULL default '0',
  `struct_turretfactory` smallint(6) NOT NULL default '0',
  `struct_turret` smallint(6) NOT NULL default '0',
  `struct_grenadegun` smallint(6) NOT NULL default '0',
  `struct_heavymachinegun` smallint(6) NOT NULL default '0',
  `struct_mine` smallint(6) NOT NULL default '0',
  `struct_shotgun` smallint(6) NOT NULL default '0',
  `struct_welder` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`gamemapid`)
) TYPE=MyISAM COMMENT='Global map data (ns)';
# --------------------------------------------------------

#
# Table structure for table `pstats_gameweapons`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
#

CREATE TABLE `pstats_gameweapons` (
  `gameweaponid` int(10) unsigned NOT NULL auto_increment,
  `weaponid` smallint(5) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `kills` smallint(5) unsigned NOT NULL default '0',
  `headshots` smallint(5) unsigned NOT NULL default '0',
  `shots` mediumint(8) unsigned NOT NULL default '0',
  `hits` smallint(5) unsigned NOT NULL default '0',
  `damage` int(10) unsigned NOT NULL default '0',
  `ffkills` smallint(5) unsigned NOT NULL default '0',
  `shot_head` smallint(5) unsigned NOT NULL default '0',
  `shot_chest` smallint(5) unsigned NOT NULL default '0',
  `shot_stomach` smallint(5) unsigned NOT NULL default '0',
  `shot_leftarm` smallint(5) unsigned NOT NULL default '0',
  `shot_rightarm` smallint(5) unsigned NOT NULL default '0',
  `shot_leftleg` smallint(5) unsigned NOT NULL default '0',
  `shot_rightleg` smallint(5) unsigned NOT NULL default '0',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gameweaponid`)
) TYPE=MyISAM COMMENT='Global weapon data' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_info`
#
# Creation: Apr 23, 2004 at 11:15 AM
# Last update: May 06, 2004 at 11:35 AM
#

CREATE TABLE `pstats_info` (
  `name` varchar(32) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM COMMENT='Misc. server stats information';
# --------------------------------------------------------

#
# Table structure for table `pstats_plr`
#
# Creation: Apr 29, 2004 at 10:40 AM
# Last update: May 06, 2004 at 11:16 AM
# Last check: May 06, 2004 at 11:16 AM
#

CREATE TABLE `pstats_plr` (
  `plrid` int(10) unsigned NOT NULL default '0',
  `srvid` smallint(5) unsigned NOT NULL default '0',
  `clanid` int(10) unsigned NOT NULL default '0',
  `plrlastdate` date NOT NULL default '0000-00-00',
  `rank` mediumint(8) unsigned NOT NULL default '0',
  `oldrank` mediumint(8) unsigned NOT NULL default '0',
  `skill` float(8,2) NOT NULL default '0.00',
  `prevskill` float(8,2) NOT NULL default '0.00',
  `name` varchar(64) NOT NULL default '',
  `worldid` varchar(32) NOT NULL default '',
  `ipaddr` int(10) unsigned NOT NULL default '0',
  `allowrank` tinyint(1) unsigned NOT NULL default '1',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrid`),
  KEY `gametype` (`gametype`,`modtype`),
  KEY `clanid` (`clanid`),
  KEY `skill` (`skill`),
  KEY `worldid` (`worldid`),
  KEY `name` (`name`)
) TYPE=MyISAM COMMENT='Registered players';
# --------------------------------------------------------

# 
# Table structure for table `pstats_plr_profile`
# 

CREATE TABLE `pstats_plr_profile` (
  `plrprofileid` int(10) unsigned NOT NULL auto_increment,
  `worldid` varchar(32) NOT NULL default '',
  `name` varchar(64) NOT NULL default '',
  `ipaddr` int(10) unsigned NOT NULL default '0',
  `plremail` varchar(128) NOT NULL default '',
  `plraim` varchar(64) NOT NULL default '',
  `plricq` varchar(16) NOT NULL default '',
  `plrmsn` varchar(128) NOT NULL default '',
  `plrwebsite` varchar(128) NOT NULL default '',
  `plricon` varchar(64) NOT NULL default '',
  `plrlogo` text NOT NULL,
  `username` varchar(64) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `accesslevel` tinyint(2) unsigned NOT NULL default '1',
  `plrnamelocked` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrprofileid`),
  KEY `username` (`username`),
  KEY `worldid` (`worldid`),
  KEY `name` (`name`),
  KEY `ipaddr` (`ipaddr`)
) TYPE=MyISAM;
# --------------------------------------------------------


#
# Table structure for table `pstats_plrdata`
#
# Creation: Apr 29, 2004 at 10:35 AM
# Last update: Apr 29, 2004 at 10:35 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_plrdata` (
  `plrdataid` int(10) unsigned NOT NULL auto_increment,
  `plrid` int(10) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `oldskill` float(8,2) NOT NULL default '0.00',
  `kills` smallint(5) unsigned NOT NULL default '0',
  `deaths` smallint(5) unsigned NOT NULL default '0',
  `headshots` smallint(5) unsigned NOT NULL default '0',
  `ffkills` smallint(5) unsigned NOT NULL default '0',
  `ffdeaths` smallint(5) unsigned NOT NULL default '0',
  `killstreak` smallint(5) unsigned NOT NULL default '0',
  `deathstreak` smallint(5) unsigned NOT NULL default '0',
  `damage` int(10) unsigned NOT NULL default '0',
  `damagetaken` int(10) unsigned NOT NULL default '0',
  `shots` smallint(5) unsigned NOT NULL default '0',
  `hits` smallint(5) unsigned NOT NULL default '0',
  `suicides` smallint(5) unsigned NOT NULL default '0',
  `games` smallint(5) unsigned NOT NULL default '0',
  `rounds` smallint(5) unsigned NOT NULL default '0',
  `kicked` smallint(5) unsigned NOT NULL default '0',
  `banned` smallint(5) unsigned NOT NULL default '0',
  `cheated` smallint(5) unsigned NOT NULL default '0',
  `killskillsum` mediumint(9) NOT NULL default '0',
  `deathskillsum` mediumint(9) NOT NULL default '0',
  `killbonussum` smallint(6) NOT NULL default '0',
  `deathbonussum` smallint(6) NOT NULL default '0',
  `awardbonus` smallint(6) NOT NULL default '0',
  `plrconnects` smallint(5) unsigned NOT NULL default '0',
  `onlinetime` int(10) unsigned NOT NULL default '0',
  `lasttime` int(10) unsigned NOT NULL default '0',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrdataid`),
  KEY `gametype` (`gametype`,`modtype`),
  KEY `plrid` (`plrid`)
) TYPE=MyISAM COMMENT='Player data (basic)' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_plrdata_cstrike`
#
# Creation: Apr 29, 2004 at 10:26 AM
# Last update: Apr 29, 2004 at 10:26 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_plrdata_cstrike` (
  `plrdataid` int(10) unsigned NOT NULL default '0',
  `ctkills` smallint(6) NOT NULL default '0',
  `terroristkills` smallint(6) NOT NULL default '0',
  `ctdeaths` smallint(6) NOT NULL default '0',
  `terroristdeaths` smallint(6) NOT NULL default '0',
  `joinedct` smallint(6) NOT NULL default '0',
  `joinedterrorist` smallint(6) NOT NULL default '0',
  `solo` smallint(6) NOT NULL default '0',
  `solokills` smallint(6) NOT NULL default '0',
  `maxsolokills` smallint(6) NOT NULL default '0',
  `maxroundkills` smallint(6) NOT NULL default '0',
  `bombdefuseattempts` smallint(6) NOT NULL default '0',
  `bombdefused` smallint(6) NOT NULL default '0',
  `bombexploded` smallint(6) NOT NULL default '0',
  `bombplanted` smallint(6) NOT NULL default '0',
  `bombspawned` smallint(6) NOT NULL default '0',
  `bombrunner` smallint(6) NOT NULL default '0',
  `killedhostages` smallint(6) NOT NULL default '0',
  `rescuedhostages` smallint(6) NOT NULL default '0',
  `touchedhostages` smallint(6) NOT NULL default '0',
  `vip` smallint(6) NOT NULL default '0',
  `vipescaped` smallint(6) NOT NULL default '0',
  `vipkilled` smallint(6) NOT NULL default '0',
  `ctwon` smallint(6) NOT NULL default '0',
  `ctlost` smallint(6) NOT NULL default '0',
  `terroristwon` smallint(6) NOT NULL default '0',
  `terroristlost` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`plrdataid`)
) TYPE=MyISAM COMMENT='Player data (cstrike)';
# --------------------------------------------------------

#
# Table structure for table `pstats_plrdata_dod`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_plrdata_dod` (
  `plrdataid` int(10) unsigned NOT NULL default '0',
  `allieskills` smallint(5) unsigned NOT NULL default '0',
  `axiskills` smallint(5) unsigned NOT NULL default '0',
  `alliesdeaths` smallint(5) unsigned NOT NULL default '0',
  `axisdeaths` smallint(5) unsigned NOT NULL default '0',
  `joinedallies` smallint(5) unsigned NOT NULL default '0',
  `joinedaxis` smallint(5) unsigned NOT NULL default '0',
  `allieswon` smallint(5) unsigned NOT NULL default '0',
  `axiswon` smallint(5) unsigned NOT NULL default '0',
  `allieslost` smallint(5) unsigned NOT NULL default '0',
  `axislost` smallint(5) unsigned NOT NULL default '0',
  `tnt` smallint(5) unsigned NOT NULL default '0',
  `tntused` smallint(5) unsigned NOT NULL default '0',
  `alliesflagscaptured` smallint(5) unsigned NOT NULL default '0',
  `alliesareascaptured` smallint(5) unsigned NOT NULL default '0',
  `axisflagscaptured` smallint(5) unsigned NOT NULL default '0',
  `axisareascaptured` smallint(5) unsigned NOT NULL default '0',
  `flagscaptured` smallint(5) unsigned NOT NULL default '0',
  `areascaptured` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrdataid`)
) TYPE=MyISAM COMMENT='Player data (dod)';
# --------------------------------------------------------

#
# Table structure for table `pstats_plrdata_ns`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_plrdata_ns` (
  `plrdataid` int(10) unsigned NOT NULL default '0',
  `marinewon` smallint(6) NOT NULL default '0',
  `marinelost` smallint(6) NOT NULL default '0',
  `alienwon` smallint(6) NOT NULL default '0',
  `alienlost` smallint(6) NOT NULL default '0',
  `marinekills` smallint(6) NOT NULL default '0',
  `alienkills` smallint(6) NOT NULL default '0',
  `marinedeaths` smallint(6) NOT NULL default '0',
  `aliendeaths` smallint(6) NOT NULL default '0',
  `joinedmarine` smallint(6) NOT NULL default '0',
  `joinedalien` smallint(6) NOT NULL default '0',
  `marinevotedown` smallint(6) NOT NULL default '0',
  `commanderwon` smallint(6) NOT NULL default '0',
  `structuresbuilt` smallint(6) NOT NULL default '0',
  `structuresdestroyed` smallint(6) NOT NULL default '0',
  `structuresrecycled` smallint(6) NOT NULL default '0',
  `struct_alienresourcetower` smallint(6) NOT NULL default '0',
  `struct_defensechamber` smallint(6) NOT NULL default '0',
  `struct_genericammo` smallint(6) NOT NULL default '0',
  `struct_health` smallint(6) NOT NULL default '0',
  `struct_heavyarmor` smallint(6) NOT NULL default '0',
  `struct_jetpack` smallint(6) NOT NULL default '0',
  `struct_movementchamber` smallint(6) NOT NULL default '0',
  `struct_offensechamber` smallint(6) NOT NULL default '0',
  `struct_phasegate` smallint(6) NOT NULL default '0',
  `struct_resourcetower` smallint(6) NOT NULL default '0',
  `struct_scan` smallint(6) NOT NULL default '0',
  `struct_sensorychamber` smallint(6) NOT NULL default '0',
  `struct_siegeturret` smallint(6) NOT NULL default '0',
  `struct_armory` smallint(6) NOT NULL default '0',
  `struct_armslab` smallint(6) NOT NULL default '0',
  `struct_command` smallint(6) NOT NULL default '0',
  `struct_hive` smallint(6) NOT NULL default '0',
  `struct_infportal` smallint(6) NOT NULL default '0',
  `struct_observatory` smallint(6) NOT NULL default '0',
  `struct_prototypelab` smallint(6) NOT NULL default '0',
  `struct_turretfactory` smallint(6) NOT NULL default '0',
  `struct_turret` smallint(6) NOT NULL default '0',
  `struct_grenadegun` smallint(6) NOT NULL default '0',
  `struct_heavymachinegun` smallint(6) NOT NULL default '0',
  `struct_mine` smallint(6) NOT NULL default '0',
  `struct_shotgun` smallint(6) NOT NULL default '0',
  `struct_welder` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`plrdataid`)
) TYPE=MyISAM COMMENT='Player data (ns)';
# --------------------------------------------------------

#
# Table structure for table `pstats_plrids`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 12:13 PM
#

CREATE TABLE `pstats_plrids` (
  `plrid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `worldid` varchar(32) NOT NULL default '',
  `ipaddr` int(10) unsigned NOT NULL default '0',
  `totaluses` mediumint(8) unsigned NOT NULL default '1',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrid`),
  KEY `name` (`name`),
  KEY `worldid` (`worldid`),
  KEY `ipaddr` (`ipaddr`)
) TYPE=MyISAM COMMENT='Unique player ID''s' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_plrmaps`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_plrmaps` (
  `plrmapid` int(10) unsigned NOT NULL auto_increment,
  `plrid` int(10) unsigned NOT NULL default '0',
  `mapid` int(10) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `games` smallint(5) unsigned NOT NULL default '0',
  `rounds` smallint(5) unsigned NOT NULL default '0',
  `kills` smallint(6) NOT NULL default '0',
  `deaths` smallint(6) NOT NULL default '0',
  `ffkills` smallint(6) NOT NULL default '0',
  `ffdeaths` smallint(6) NOT NULL default '0',
  `plrconnects` smallint(5) unsigned NOT NULL default '0',
  `onlinetime` int(10) unsigned NOT NULL default '0',
  `lasttime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrmapid`),
  KEY `plrdays` (`plrid`,`statdate`),
  KEY `mapid` (`mapid`)
) TYPE=MyISAM COMMENT='Player data (maps)' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_plrmaps_cstrike`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_plrmaps_cstrike` (
  `plrmapid` int(10) unsigned NOT NULL default '0',
  `ctkills` smallint(6) NOT NULL default '0',
  `terroristkills` smallint(6) NOT NULL default '0',
  `ctdeaths` smallint(6) NOT NULL default '0',
  `terroristdeaths` smallint(6) NOT NULL default '0',
  `joinedct` smallint(6) NOT NULL default '0',
  `joinedterrorist` smallint(6) NOT NULL default '0',
  `solo` smallint(6) NOT NULL default '0',
  `solokills` smallint(6) NOT NULL default '0',
  `maxsolokills` smallint(6) NOT NULL default '0',
  `maxroundkills` smallint(6) NOT NULL default '0',
  `bombdefuseattempts` smallint(6) NOT NULL default '0',
  `bombdefused` smallint(6) NOT NULL default '0',
  `bombexploded` smallint(6) NOT NULL default '0',
  `bombplanted` smallint(6) NOT NULL default '0',
  `bombspawned` smallint(6) NOT NULL default '0',
  `bombrunner` smallint(6) NOT NULL default '0',
  `killedhostages` smallint(6) NOT NULL default '0',
  `rescuedhostages` smallint(6) NOT NULL default '0',
  `touchedhostages` smallint(6) NOT NULL default '0',
  `vip` smallint(6) NOT NULL default '0',
  `vipescaped` smallint(6) NOT NULL default '0',
  `vipkilled` smallint(6) NOT NULL default '0',
  `ctwon` smallint(6) NOT NULL default '0',
  `ctlost` smallint(6) NOT NULL default '0',
  `terroristwon` smallint(6) NOT NULL default '0',
  `terroristlost` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`plrmapid`)
) TYPE=MyISAM COMMENT='Player map data (cstrike)';
# --------------------------------------------------------

#
# Table structure for table `pstats_plrmaps_dod`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_plrmaps_dod` (
  `plrmapid` int(10) unsigned NOT NULL default '0',
  `allieskills` smallint(5) unsigned NOT NULL default '0',
  `axiskills` smallint(5) unsigned NOT NULL default '0',
  `alliesdeaths` smallint(5) unsigned NOT NULL default '0',
  `axisdeaths` smallint(5) unsigned NOT NULL default '0',
  `joinedallies` smallint(5) unsigned NOT NULL default '0',
  `joinedaxis` smallint(5) unsigned NOT NULL default '0',
  `allieswon` smallint(5) unsigned NOT NULL default '0',
  `axiswon` smallint(5) unsigned NOT NULL default '0',
  `allieslost` smallint(5) unsigned NOT NULL default '0',
  `axislost` smallint(5) unsigned NOT NULL default '0',
  `tnt` smallint(5) unsigned NOT NULL default '0',
  `tntused` smallint(5) unsigned NOT NULL default '0',
  `alliesflagscaptured` smallint(5) unsigned NOT NULL default '0',
  `alliesareascaptured` smallint(5) unsigned NOT NULL default '0',
  `axisflagscaptured` smallint(5) unsigned NOT NULL default '0',
  `axisareascaptured` smallint(5) unsigned NOT NULL default '0',
  `flagscaptured` smallint(5) unsigned NOT NULL default '0',
  `areascaptured` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrmapid`)
) TYPE=MyISAM COMMENT='Player map data (dod)';
# --------------------------------------------------------

#
# Table structure for table `pstats_plrmaps_ns`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_plrmaps_ns` (
  `plrmapid` int(10) unsigned NOT NULL default '0',
  `marinewon` smallint(6) NOT NULL default '0',
  `marinelost` smallint(6) NOT NULL default '0',
  `alienwon` smallint(6) NOT NULL default '0',
  `alienlost` smallint(6) NOT NULL default '0',
  `marinekills` smallint(6) NOT NULL default '0',
  `alienkills` smallint(6) NOT NULL default '0',
  `marinedeaths` smallint(6) NOT NULL default '0',
  `aliendeaths` smallint(6) NOT NULL default '0',
  `joinedmarine` smallint(6) NOT NULL default '0',
  `joinedalien` smallint(6) NOT NULL default '0',
  `marinevotedown` smallint(6) NOT NULL default '0',
  `commanderwon` smallint(6) NOT NULL default '0',
  `structuresbuilt` smallint(6) NOT NULL default '0',
  `structuresdestroyed` smallint(6) NOT NULL default '0',
  `structuresrecycled` smallint(6) NOT NULL default '0',
  `struct_alienresourcetower` smallint(6) NOT NULL default '0',
  `struct_defensechamber` smallint(6) NOT NULL default '0',
  `struct_genericammo` smallint(6) NOT NULL default '0',
  `struct_health` smallint(6) NOT NULL default '0',
  `struct_heavyarmor` smallint(6) NOT NULL default '0',
  `struct_jetpack` smallint(6) NOT NULL default '0',
  `struct_movementchamber` smallint(6) NOT NULL default '0',
  `struct_offensechamber` smallint(6) NOT NULL default '0',
  `struct_phasegate` smallint(6) NOT NULL default '0',
  `struct_resourcetower` smallint(6) NOT NULL default '0',
  `struct_scan` smallint(6) NOT NULL default '0',
  `struct_sensorychamber` smallint(6) NOT NULL default '0',
  `struct_siegeturret` smallint(6) NOT NULL default '0',
  `struct_armory` smallint(6) NOT NULL default '0',
  `struct_armslab` smallint(6) NOT NULL default '0',
  `struct_command` smallint(6) NOT NULL default '0',
  `struct_hive` smallint(6) NOT NULL default '0',
  `struct_infportal` smallint(6) NOT NULL default '0',
  `struct_observatory` smallint(6) NOT NULL default '0',
  `struct_prototypelab` smallint(6) NOT NULL default '0',
  `struct_turretfactory` smallint(6) NOT NULL default '0',
  `struct_turret` smallint(6) NOT NULL default '0',
  `struct_grenadegun` smallint(6) NOT NULL default '0',
  `struct_heavymachinegun` smallint(6) NOT NULL default '0',
  `struct_mine` smallint(6) NOT NULL default '0',
  `struct_shotgun` smallint(6) NOT NULL default '0',
  `struct_welder` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`plrmapid`)
) TYPE=MyISAM COMMENT='Player map data (ns)';
# --------------------------------------------------------

#
# Table structure for table `pstats_plrroles`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 23, 2004 at 02:13 AM
#

CREATE TABLE `pstats_plrroles` (
  `plrroleid` int(10) unsigned NOT NULL auto_increment,
  `plrid` int(10) unsigned NOT NULL default '0',
  `roleid` smallint(5) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `joined` smallint(5) unsigned NOT NULL default '0',
  `kills` smallint(5) unsigned NOT NULL default '0',
  `deaths` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrroleid`),
  KEY `plrdays` (`plrid`,`statdate`),
  KEY `roleid` (`roleid`)
) TYPE=MyISAM COMMENT='Player data (weapons)' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_plrvictims`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
#

CREATE TABLE `pstats_plrvictims` (
  `plrvictimid` int(10) unsigned NOT NULL auto_increment,
  `plrid` int(10) unsigned NOT NULL default '0',
  `victimid` int(10) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `kills` smallint(6) NOT NULL default '0',
  `deaths` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`plrvictimid`),
  KEY `plrdays` (`plrid`,`statdate`)
) TYPE=MyISAM COMMENT='Player data (victims)' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_plrweapons`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:47 AM
#

CREATE TABLE `pstats_plrweapons` (
  `plrweaponid` int(10) unsigned NOT NULL auto_increment,
  `plrid` int(10) unsigned NOT NULL default '0',
  `weaponid` smallint(5) unsigned NOT NULL default '0',
  `statdate` date NOT NULL default '0000-00-00',
  `kills` smallint(6) NOT NULL default '0',
  `deaths` smallint(5) unsigned NOT NULL default '0',
  `headshots` smallint(5) unsigned NOT NULL default '0',
  `shots` int(10) unsigned NOT NULL default '0',
  `hits` int(10) unsigned NOT NULL default '0',
  `damage` int(10) unsigned NOT NULL default '0',
  `damagetaken` int(10) unsigned NOT NULL default '0',
  `ffkills` smallint(5) unsigned NOT NULL default '0',
  `ffdeaths` smallint(5) unsigned NOT NULL default '0',
  `shot_head` smallint(5) unsigned NOT NULL default '0',
  `shot_chest` smallint(5) unsigned NOT NULL default '0',
  `shot_stomach` smallint(5) unsigned NOT NULL default '0',
  `shot_leftarm` smallint(5) unsigned NOT NULL default '0',
  `shot_rightarm` smallint(5) unsigned NOT NULL default '0',
  `shot_leftleg` smallint(5) unsigned NOT NULL default '0',
  `shot_rightleg` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plrweaponid`),
  KEY `plrdays` (`plrid`,`statdate`),
  KEY `weaponid` (`weaponid`)
) TYPE=MyISAM COMMENT='Player data (weapons)' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_rcons`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: Apr 27, 2004 at 11:46 AM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_rcons` (
  `rconid` int(10) unsigned NOT NULL auto_increment,
  `statdate` date NOT NULL default '0000-00-00',
  `ipaddr` int(10) unsigned NOT NULL default '0',
  `badpw` tinyint(1) unsigned NOT NULL default '0',
  `password` varchar(32) NOT NULL default '',
  `cmd` varchar(255) NOT NULL default '',
  `timestamp` int(10) unsigned NOT NULL default '0',
  `gametype` smallint(5) unsigned NOT NULL default '0',
  `modtype` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rconid`),
  KEY `ipaddr` (`ipaddr`),
  KEY `statdate` (`statdate`)
) TYPE=MyISAM COMMENT='RCON event history' ;
# --------------------------------------------------------

#
# Table structure for table `pstats_sessions`
#
# Creation: Apr 23, 2004 at 02:13 AM
# Last update: May 06, 2004 at 04:05 PM
# Last check: Apr 29, 2004 at 11:22 PM
#

CREATE TABLE `pstats_sessions` (
  `session_id` char(32) NOT NULL default '',
  `session_userid` int(10) unsigned NOT NULL default '0',
  `session_start` int(10) unsigned NOT NULL default '0',
  `session_last` int(10) unsigned NOT NULL default '0',
  `session_ip` int(10) unsigned NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_userid` (`session_userid`)
) TYPE=MyISAM COMMENT='User sessions';