-- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: pugbot
-- ------------------------------------------------------
-- Server version	5.1.41-3ubuntu12.10

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `banlist`
--

DROP TABLE IF EXISTS `banlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banlist` (
  `ban_id` int(5) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL,
  `nick` varchar(30) NOT NULL,
  `reason` varchar(128) NOT NULL,
  `guid` varchar(32) NOT NULL,
  `user_id` int(5) NOT NULL,
  `type` varchar(10) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `host` varchar(32) NOT NULL,
  `repeat` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ban_id`)
) ENGINE=MyISAM AUTO_INCREMENT=588 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banlist`
--

LOCK TABLES `banlist` WRITE;
/*!40000 ALTER TABLE `banlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `banlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bugs`
--

DROP TABLE IF EXISTS `bugs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bugs` (
  `bug_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `from` varchar(120) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` enum('','complete','planned','denied') NOT NULL,
  PRIMARY KEY (`bug_id`)
) ENGINE=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bugs`
--

LOCK TABLES `bugs` WRITE;
/*!40000 ALTER TABLE `bugs` DISABLE KEYS */;
/*!40000 ALTER TABLE `bugs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ip_group_city`
--

DROP TABLE IF EXISTS `ip_group_city`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ip_group_city` (
  `ip_start` bigint(20) NOT NULL,
  `country_code` varchar(2) NOT NULL,
  `country_name` varchar(64) NOT NULL,
  `region_code` varchar(2) NOT NULL,
  `region_name` varchar(64) NOT NULL,
  `city` varchar(64) NOT NULL,
  `zipcode` varchar(6) NOT NULL,
  `latitude` float NOT NULL,
  `longitude` float NOT NULL,
  `timezone` varchar(4) NOT NULL,
  `gmtOffset` varchar(4) NOT NULL,
  `dstOffset` varchar(4) NOT NULL,
  UNIQUE KEY `ip_start` (`ip_start`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ip_group_city`
--

LOCK TABLES `ip_group_city` WRITE;
/*!40000 ALTER TABLE `ip_group_city` DISABLE KEYS */;
/*!40000 ALTER TABLE `ip_group_city` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ip_group_country`
--

DROP TABLE IF EXISTS `ip_group_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ip_group_country` (
  `ip_start` bigint(20) NOT NULL,
  `ip_cidr` varchar(20) NOT NULL,
  `country_code` varchar(2) NOT NULL,
  `country_name` varchar(64) NOT NULL,
  UNIQUE KEY `ip_start` (`ip_start`),
  KEY `country` (`country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ip_group_country`
--

LOCK TABLES `ip_group_country` WRITE;
/*!40000 ALTER TABLE `ip_group_country` DISABLE KEYS */;
/*!40000 ALTER TABLE `ip_group_country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lang_txt`
--

DROP TABLE IF EXISTS `lang_txt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lang_txt` (
  `lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` varchar(2) NOT NULL DEFAULT 'en',
  `text` text NOT NULL,
  `txt_id` text NOT NULL,
  PRIMARY KEY (`lang_id`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lang_txt`
--

LOCK TABLES `lang_txt` WRITE;
/*!40000 ALTER TABLE `lang_txt` DISABLE KEYS */;
INSERT INTO `lang_txt` VALUES (7,'en','blk_ylwCommands: .join [map] [gametype], .status, .active/.last, .vote [map] [gametype], .maps, .gametypes, .quit, .region [na/sa/eu/clear]','txt_help1'),(4,'en','Please authenticate yourself through the following link: ','txt_auth'),(5,'en','blk_ylwYou have successfully logged in.','txt_login_good'),(6,'en','blk_ylwblk_ylwWrong user/password combination','txt_login_bad'),(8,'en','blk_ylwPlease go to gry_bluhttp://pugbot.com/wiki/blk_ylw for more information on PUGBot and our other bots.','txt_help2'),(9,'en','blk_ylwPlease use .bug [bug/suggestion] for any bugs or suggestions.','txt_help3'),(10,'en','blk_ylwYou are using: ','txt_network'),(11,'en','blk_ylwPlease click the following link before you can join: ','txt_token_link'),(12,'en','blk_ylwYou are missing parameters.','txt_missing_params'),(13,'en','blk_ylwThis email has been used before.','txt_bad_email'),(14,'en','blk_ylwYou\'ve registered. Please check your email to activate.','txt_registered'),(15,'en','blk_ylwThe login contains invalid characters.','txt_invalid_login'),(16,'en','blk_ylwThis login has already been registered.','txt_used_login'),(17,'en','blk_ylwYou\\\'re late! Use the following command to connect: /connect ','txt_late_pug'),(18,'en','\\00316,3PUG #','txt_pug_starting1'),(19,'en','IS CURRENTLY STARTING, SETTING UP SERVER AND SENDING OUT INFO, PLEASE WAIT!!!','txt_pugstarting2'),(20,'en','\\00316,3PUG #','txt_pug_delayed1'),(21,'en','HAS BEEN DELAYED, RAN OUT OF FREE SERVERS, SLEEPING FOR 30 SECONDS AND TRYING AGAIN!','txt_pug_delayed2'),(22,'en','\\00316,3PUG #','txt_pug_raindelay1'),(23,'en',' HAS BEEN DELAYED, APPERENT SERVER MISHAP OR RAN OUT OF FREE SERVERS, SLEEPING FOR 30 SECONDS AND TRYING AGAIN!','txt_pug_raindelay2'),(24,'en','blk_ylwPUG HAS STARTED - TS3 info: Pugbot.com:9987 - Gameserver: /connect ','txt_pug_start1'),(25,'en','; password ','txt_pug_start2'),(26,'en','; name ','txt_pug_start3'),(27,'en','grn_whtPUG #','txt_cpt_1'),(28,'en',' HAS STARTED. ','txt_cpt_2'),(29,'en','\" AND \"','txt_cpt_3'),(30,'en',' ARE CAPTAINS.','txt_cpt_4'),(31,'en','\\\"Captians are: ','txt_cpn_1'),(32,'en',' AND ','txt_cpn_2'),(33,'en',' EVERYONE ELSE SPEC!!!\\\"','txt_cpn_3'),(34,'en','blk_ylwYou are already in this PUG/a ringer.','txt_ringer_error'),(35,'en','blk_ylwYou have been added as a ringer. If you are needed, we will send you a message.','txt_ringer_added'),(36,'en','blk_ylwYou have been removed as a ringer.','txt_ringer_removed'),(37,'en','blk_ylwInvalid ringer parameter.','txt_ringer_invalid'),(38,'en','blk_ylwYou are already in a PUG. Please wait for it to finish before joining another.','txt_error_in_pug'),(39,'en','blk_ylw You have faced the wrath of the BANHAMMER. Time left on ban:\\00309,01 ','txt_ban1'),(40,'en','\\00308,01  Current level:\\00309,01 ','txt_ban2'),(41,'en','blk_ylwPlease click the following link before you can join: ','txt_auth_link'),(42,'en','blk_ylwYou are already in this PUG.','txt_error_in_pug'),(43,'en','blk_ylwYOU ARE A RINGER - TS3 info: Pugbot.com:9987 - Gameserver: /connect ','txt_pug_start_1'),(44,'en',' from blk_grn','txt_joined_1'),(45,'en','blk_ylw has joined from blk_grn','txt_joined_2'),(46,'en','blk_ylwNo ringers needed at this time','txt_no_ringer_needed'),(47,'en','blk_ylwThere are no active pugs.','txt_no_active_pugs'),(48,'en','blk_ylwACTIVE PUG:blk_grn ','txt_active_pug1'),(49,'en','blk_ylw: Startedblk_grn ','txt_active_pug2'),(50,'en','blk_ylw minutes ago. Map:blk_grn ','txt_active_pug3'),(51,'en','blk_ylw. Ringers Needed:','txt_active_pug4'),(52,'en','blk_ylwPlayers - ','txt_active_pug5'),(53,'en','blk_ylwLast vote, pug ending!','txt_pug_ending'),(54,'en','blk_ylwYou\\\'re not in any pugs!','txt_in_no_pug'),(55,'en','blk_ylwInvalid pug number.','txt_invalid_pug_num'),(56,'en','blk_ylwPUG:blk_grn ','txt_last_start1'),(57,'en','blk_ylw: Startedblk_grn ','txt_last_start2'),(58,'en','blk_ylw minutes ago. Map:blk_grn ','txt_last_start3'),(59,'en','blk_ylw. Gametype:blk_grn ','txt_last_start3'),(60,'en','blk_ylwPlayers - ','txt_last_start_5'),(61,'en','blk_ylwInvalid region preference, chubbs.','txt_invalid_region'),(62,'en','blk_ylwYour region has been cleared for this pug and session.','txt_cleared_region'),(63,'en','blk_ylwYour region has been updated to ','txt_updated_region1'),(64,'en',' for this pug and session.','txt_updated_region2'),(65,'en','blk_ylwYour region has been updated to ','txt_region_updated'),(66,'en','blk_ylwYou didn\'t enter a preference, chubbs.','txt_no_region_pref'),(67,'en',' \\00315,1|blk_ylw Map: blk_grn','txt_map'),(68,'en',' \\00315,1|blk_ylw Gametype: blk_grn','txt_gametype'),(69,'en',' \\00315,1|blk_ylw Open Slots: blk_grn ','txt_open_slots'),(70,'en','blk_ylwPlayers in PUG #','txt_players_in_pug'),(71,'en','blk_ylwPug is empty ','txt_empty_pug'),(72,'en','blk_ylwPug Info:','txt_pug_info'),(73,'en','blk_ylwPlayers in PUG# ','pug_players'),(74,'en','blk_ylwPug is empty ','pug_empty'),(75,'en','blk_ylwNeedblk_grn ','txt_need1'),(76,'en','blk_ylw players. Type .join to play. ','txt_need2'),(77,'en','blk_ylwYou are not in this PUG.','txt_not_in_pug'),(78,'en','blk_ylwMap vote accepted.','txt_mvote_accepted'),(79,'en','blk_ylwInvalid map vote.','txt_mvote_bad'),(80,'en','blk_ylwGametype vote accepted.','txt_gvote_accepted'),(81,'en','blk_ylwInvalid gametype vote.','txt_gvote_bad'),(82,'en','blk_ylwYou\'ve quit!','txt_quit'),(83,'en','blk_ylwYou weren\'t in this PUG.','txt_not_in_pug'),(85,'en','blk_ylwMaps:','txt_maps'),(86,'en','blk_ylwYou\'ve checked in.','txt_checked_in'),(87,'en','blk_ylwYou\'re not in this pug, suckah.','txt_not_in_pug'),(88,'en','blk_ylwYou were taken out of PUGs for being idle too long.','pug_long_idle'),(89,'en','blk_ylwYou have ','txt_checkin1'),(90,'en',' minutes left to checkin. Please do !checkin to stay in the PUG.','txt_checkin2'),(91,'en','blk_ylwSupported gametypes:','txt_supported_gametypes'),(92,'en','blk_ylwYou have logged out.','txt_logged_out'),(93,'en','blk_ylwYou were not logged in.','txt_not_logged_in'),(94,'en','NAMES ','txt_names'),(95,'en','blk_ylw RINGERS NEEDED FOR PUG#blk_grn ','txt_ringers_need1'),(96,'en','blk_ylw. Map:blk_grn ','txt_map2'),(97,'en','blk_ylw. Gametype:blk_grn ','txt_gametype2'),(98,'en','blk_ylw. TYPEblk_grn .join ringerblk_ylw NOW!!!','txt_ringers_need2'),(99,'en','blk_ylwYou\\\'re not in any pugs!','txt_in_no_pugs'),(100,'en','blk_ylwVote ','txt_vote');
/*!40000 ALTER TABLE `lang_txt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `league_info`
--

DROP TABLE IF EXISTS `league_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `league_info` (
  `league_id` int(11) NOT NULL AUTO_INCREMENT,
  `admins` varchar(128) NOT NULL,
  `title` text NOT NULL,
  `info` text NOT NULL,
  `max_teams` int(3) NOT NULL,
  `dow` varchar(2) NOT NULL,
  `tod` int(10) NOT NULL,
  `players` int(11) NOT NULL,
  PRIMARY KEY (`league_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `league_info`
--

LOCK TABLES `league_info` WRITE;
/*!40000 ALTER TABLE `league_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `league_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `league_schedule`
--

DROP TABLE IF EXISTS `league_schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `league_schedule` (
  `team_a` varchar(10) NOT NULL,
  `team_b` varchar(10) NOT NULL,
  `time` varchar(10) NOT NULL,
  `score_a1` int(3) NOT NULL,
  `score_a2` int(3) NOT NULL,
  `score_a3` int(3) NOT NULL,
  `score_b1` int(3) NOT NULL,
  `score_b2` int(3) NOT NULL,
  `score_b3` int(3) NOT NULL,
  `a_dispute` text NOT NULL,
  `b_dispute` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `league_schedule`
--

LOCK TABLES `league_schedule` WRITE;
/*!40000 ALTER TABLE `league_schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `league_schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `league_teams`
--

DROP TABLE IF EXISTS `league_teams`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `league_teams` (
  `league_id` int(11) NOT NULL,
  `team_id` int(11) NOT NULL,
  `status` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `league_teams`
--

LOCK TABLES `league_teams` WRITE;
/*!40000 ALTER TABLE `league_teams` DISABLE KEYS */;
/*!40000 ALTER TABLE `league_teams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `master_stat_serv`
--

DROP TABLE IF EXISTS `master_stat_serv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `master_stat_serv` (
  `track_id` int(5) NOT NULL,
  `pug_id` int(5) NOT NULL,
  `server_id` int(5) NOT NULL,
  `host` varchar(32) NOT NULL,
  `port` int(5) NOT NULL,
  `rcon` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_stat_serv`
--

LOCK TABLES `master_stat_serv` WRITE;
/*!40000 ALTER TABLE `master_stat_serv` DISABLE KEYS */;
/*!40000 ALTER TABLE `master_stat_serv` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `offline_messages`
--

DROP TABLE IF EXISTS `offline_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offline_messages` (
  `o_msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `pitcher` int(11) NOT NULL,
  `taker` int(11) NOT NULL,
  `message` text NOT NULL,
  `type` varchar(10) NOT NULL,
  PRIMARY KEY (`o_msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `offline_messages`
--

LOCK TABLES `offline_messages` WRITE;
/*!40000 ALTER TABLE `offline_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `offline_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outgoing_messages`
--

DROP TABLE IF EXISTS `outgoing_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `outgoing_messages` (
  `message_id` int(10) NOT NULL AUTO_INCREMENT,
  `message` varchar(500) NOT NULL,
  `type` varchar(10) NOT NULL,
  `network` varchar(30) NOT NULL,
  `target` varchar(30) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outgoing_messages`
--

LOCK TABLES `outgoing_messages` WRITE;
/*!40000 ALTER TABLE `outgoing_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `outgoing_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
  `admin_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `host` varchar(128) NOT NULL,
  `nick` varchar(50) NOT NULL,
  `password` varchar(32) NOT NULL,
  `perms` tinyint(1) NOT NULL,
  `indent` varchar(50) NOT NULL,
  PRIMARY KEY (`admin_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pug_game_log`
--

DROP TABLE IF EXISTS `pug_game_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pug_game_log` (
  `pug_id` int(5) NOT NULL,
  `type` varchar(8) NOT NULL,
  `info_1` varchar(10) NOT NULL,
  `info_2` varchar(10) NOT NULL,
  `user_1` int(5) NOT NULL,
  `user_2` int(5) NOT NULL,
  `gametime` varchar(6) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pug_game_log`
--

LOCK TABLES `pug_game_log` WRITE;
/*!40000 ALTER TABLE `pug_game_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `pug_game_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pug_log`
--

DROP TABLE IF EXISTS `pug_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pug_log` (
  `pug_log_entry_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pug_id` int(5) NOT NULL,
  `host` varchar(128) NOT NULL,
  `kills` int(3) NOT NULL,
  `deaths` int(3) NOT NULL,
  `map_vote` varchar(15) NOT NULL,
  `gametype_vote` varchar(15) NOT NULL,
  `nick` varchar(30) NOT NULL,
  `session_id` int(8) NOT NULL,
  `join_type` enum('pug','ringer','any') NOT NULL DEFAULT 'any',
  `ip` varchar(15) NOT NULL,
  `reg_pref` varchar(5) NOT NULL,
  `status` varchar(10) NOT NULL,
  `slot` tinyint(4) NOT NULL,
  `guid` varchar(32) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rank` int(11) NOT NULL,
  `country_code` varchar(3) NOT NULL,
  `time` int(10) NOT NULL,
  `network` varchar(32) NOT NULL,
  `chan` varchar(32) NOT NULL,
  `missing` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pug_log_entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=65577 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pug_log`
--

LOCK TABLES `pug_log` WRITE;
/*!40000 ALTER TABLE `pug_log` DISABLE KEYS */;
INSERT INTO `pug_log` VALUES (65576,0,'afbc73456049fa5c39a2301791df295d',0,0,'','','TheRick',829,'any','204.195.144.205','','',0,'',0,0,'',1308461205,'','',0);
/*!40000 ALTER TABLE `pug_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pug_stats`
--

DROP TABLE IF EXISTS `pug_stats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pug_stats` (
  `pug_id` int(5) NOT NULL,
  `user_id` varchar(5) NOT NULL,
  `score` int(5) NOT NULL,
  `awards` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pug_stats`
--

LOCK TABLES `pug_stats` WRITE;
/*!40000 ALTER TABLE `pug_stats` DISABLE KEYS */;
/*!40000 ALTER TABLE `pug_stats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pugs`
--

DROP TABLE IF EXISTS `pugs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pugs` (
  `pug_id` int(5) NOT NULL AUTO_INCREMENT,
  `server_id` int(5) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `ended_timestamp` int(11) DEFAULT NULL,
  `password` varchar(5) NOT NULL,
  `map` varchar(30) NOT NULL,
  `ringers` tinyint(4) NOT NULL,
  `status` varchar(10) NOT NULL,
  `players` int(11) NOT NULL,
  `gameover` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pug_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3277 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pugs`
--

LOCK TABLES `pugs` WRITE;
/*!40000 ALTER TABLE `pugs` DISABLE KEYS */;
/*!40000 ALTER TABLE `pugs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rcon`
--

DROP TABLE IF EXISTS `rcon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rcon` (
  `server_id` int(5) NOT NULL,
  `host` varchar(32) NOT NULL,
  `port` int(5) NOT NULL,
  `pass` varchar(16) NOT NULL,
  `command` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rcon`
--

LOCK TABLES `rcon` WRITE;
/*!40000 ALTER TABLE `rcon` DISABLE KEYS */;
/*!40000 ALTER TABLE `rcon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scrimbot_challenges`
--

DROP TABLE IF EXISTS `scrimbot_challenges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scrimbot_challenges` (
  `team_a` varchar(10) NOT NULL,
  `team_b` varchar(10) NOT NULL,
  `players` int(1) NOT NULL,
  `request` text NOT NULL,
  `timestamp` varchar(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scrimbot_challenges`
--

LOCK TABLES `scrimbot_challenges` WRITE;
/*!40000 ALTER TABLE `scrimbot_challenges` DISABLE KEYS */;
/*!40000 ALTER TABLE `scrimbot_challenges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scrimbot_log`
--

DROP TABLE IF EXISTS `scrimbot_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scrimbot_log` (
  `scrim_id` int(5) NOT NULL,
  `players` int(2) NOT NULL,
  `notes` text NOT NULL,
  `team_a` varchar(10) NOT NULL,
  `team_b` varchar(10) NOT NULL,
  `team_a_score` int(3) NOT NULL,
  `team_b_score` int(3) NOT NULL,
  `timestamp` varchar(15) NOT NULL,
  `status` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scrimbot_log`
--

LOCK TABLES `scrimbot_log` WRITE;
/*!40000 ALTER TABLE `scrimbot_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `scrimbot_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scrimbot_notes`
--

DROP TABLE IF EXISTS `scrimbot_notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scrimbot_notes` (
  `team` varchar(10) NOT NULL,
  `author` varchar(10) NOT NULL,
  `note` text NOT NULL,
  `timestamp` varchar(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scrimbot_notes`
--

LOCK TABLES `scrimbot_notes` WRITE;
/*!40000 ALTER TABLE `scrimbot_notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `scrimbot_notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scrimbot_waiting`
--

DROP TABLE IF EXISTS `scrimbot_waiting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scrimbot_waiting` (
  `team` varchar(32) NOT NULL,
  `nick` varchar(30) NOT NULL,
  `players` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scrimbot_waiting`
--

LOCK TABLES `scrimbot_waiting` WRITE;
/*!40000 ALTER TABLE `scrimbot_waiting` DISABLE KEYS */;
/*!40000 ALTER TABLE `scrimbot_waiting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servers`
--

DROP TABLE IF EXISTS `servers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `servers` (
  `server_id` int(3) NOT NULL AUTO_INCREMENT,
  `host` varchar(25) NOT NULL,
  `port` int(6) NOT NULL,
  `rcon` tinytext NOT NULL,
  `name` varchar(50) NOT NULL,
  `game` varchar(10) NOT NULL,
  `status` varchar(10) NOT NULL,
  `slave_port` int(5) NOT NULL,
  `slave_host` varchar(32) NOT NULL,
  `api_key` varchar(32) NOT NULL,
  `current_map` varchar(30) NOT NULL,
  `region` varchar(3) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `current_pug` int(5) NOT NULL,
  `mod` varchar(10) NOT NULL,
  `user_id` int(5) NOT NULL,
  PRIMARY KEY (`server_id`)
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servers`
--

LOCK TABLES `servers` WRITE;
/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `session`
--

DROP TABLE IF EXISTS `session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `session` (
  `session_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(5) NOT NULL,
  `nick` varchar(30) NOT NULL,
  `rank` int(6) NOT NULL,
  `host` varchar(128) NOT NULL,
  `network` varchar(100) NOT NULL,
  `sockid` tinyint(3) NOT NULL,
  `timestamp` int(12) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `ipkey` int(10) NOT NULL,
  `token` varchar(64) NOT NULL,
  `country` varchar(64) NOT NULL,
  `state` varchar(64) NOT NULL,
  `reg_pref` varchar(5) NOT NULL,
  `country_code` varchar(3) NOT NULL,
  `captain` varchar(32) NOT NULL,
  `teams` varchar(32) NOT NULL,
  `groups` varchar(128) NOT NULL,
  `pmsys` varchar(64) NOT NULL,
  `lang` varchar(2) NOT NULL,
  PRIMARY KEY (`session_id`,`user_id`),
  KEY `host` (`host`)
) ENGINE=MEMORY AUTO_INCREMENT=834 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `session`
--

LOCK TABLES `session` WRITE;
/*!40000 ALTER TABLE `session` DISABLE KEYS */;
INSERT INTO `session` VALUES (831,0,'GT-Testbot',0,'e74e8bebba598ef74d3f1a87310bcf59','freenode',0,1308472380,'208.93.223.140',2147483647,'','','','','','','','','',''),(830,0,'GT-Testbot553',0,'e74e8bebba598ef74d3f1a87310bcf59','freenode',0,1308472097,'208.93.223.140',2147483647,'','','','','','','','','',''),(832,0,'slack-m',0,'ad0aa2a274a0878847e4ca6e1ccd5b56','freenode',0,1308536642,'67.8.167.52',1124640564,'','','','','','','','','',''),(833,0,'GT-Test-01',0,'e74e8bebba598ef74d3f1a87310bcf59','freenode',0,1308537764,'208.93.223.140',2147483647,'','','','','','','','','','');
/*!40000 ALTER TABLE `session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `spam`
--

DROP TABLE IF EXISTS `spam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `spam` (
  `spam_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `sent` int(4) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`spam_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `spam`
--

LOCK TABLES `spam` WRITE;
/*!40000 ALTER TABLE `spam` DISABLE KEYS */;
/*!40000 ALTER TABLE `spam` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tracker_aliases`
--

DROP TABLE IF EXISTS `tracker_aliases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tracker_aliases` (
  `tuser_id` int(11) NOT NULL,
  `alias` varchar(30) NOT NULL,
  `ipkey` int(12) NOT NULL,
  `counter` int(5) NOT NULL,
  `ip` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tracker_aliases`
--

LOCK TABLES `tracker_aliases` WRITE;
/*!40000 ALTER TABLE `tracker_aliases` DISABLE KEYS */;
/*!40000 ALTER TABLE `tracker_aliases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tracker_status`
--

DROP TABLE IF EXISTS `tracker_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tracker_status` (
  `key` bigint(20) NOT NULL AUTO_INCREMENT,
  `server_id` int(11) NOT NULL,
  `pid` tinyint(4) NOT NULL,
  `score` tinyint(6) NOT NULL,
  `ping` smallint(6) NOT NULL,
  `name` varchar(25) NOT NULL,
  `lastmsg` smallint(6) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `ipkey` int(12) NOT NULL,
  `port` int(11) NOT NULL,
  `qport` smallint(6) NOT NULL,
  `rate` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=MyISAM AUTO_INCREMENT=7095010 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tracker_status`
--

LOCK TABLES `tracker_status` WRITE;
/*!40000 ALTER TABLE `tracker_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `tracker_status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tracker_users`
--

DROP TABLE IF EXISTS `tracker_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tracker_users` (
  `tuser_id` int(5) NOT NULL AUTO_INCREMENT,
  `initial_ip` varchar(15) NOT NULL,
  `ipkey` int(12) NOT NULL,
  PRIMARY KEY (`tuser_id`)
) ENGINE=MyISAM AUTO_INCREMENT=177070 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tracker_users`
--

LOCK TABLES `tracker_users` WRITE;
/*!40000 ALTER TABLE `tracker_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `tracker_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'pugbot'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-06-20  9:02:32