{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\sa200\sl276\slmult1\lang7\f0\fs22 -- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (x86_64)\par
--\par
-- Host: localhost    Database: ev0ke_kb2\par
-- ------------------------------------------------------\par
-- Server version       5.1.41-3.dotdeb.0-log\par
\par
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\par
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\par
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\par
/*!40101 SET NAMES utf8 */;\par
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;\par
/*!40103 SET TIME_ZONE='+00:00' */;\par
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\par
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\par
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;\par
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\par
\par
--\par
-- Table structure for table `kb3_all_corp`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_all_corp`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_all_corp` (\par
  `all_id` bigint(3) unsigned NOT NULL DEFAULT '0',\par
  `corp_id` bigint(3) unsigned NOT NULL DEFAULT '0',\par
  `all_name` varchar(200) DEFAULT NULL,\par
  PRIMARY KEY (`all_id`,`corp_id`)\par
) ENGINE=MyISAM DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_alliances`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_alliances`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_alliances` (\par
  `all_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `all_name` varchar(64) NOT NULL DEFAULT '',\par
  `all_external_id` int(11) unsigned DEFAULT NULL,\par
  PRIMARY KEY (`all_id`),\par
  UNIQUE KEY `all_name` (`all_name`),\par
  UNIQUE KEY `all_external_id` (`all_external_id`)\par
) ENGINE=InnoDB AUTO_INCREMENT=3028 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_api_user`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_api_user`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_api_user` (\par
  `userID` int(3) unsigned DEFAULT '0',\par
  `apiKey` varchar(64) DEFAULT NULL,\par
  `charID` int(3) unsigned DEFAULT '0',\par
  `charName` varchar(150) DEFAULT '0',\par
  `corpName` varchar(150) DEFAULT '0',\par
  `allianceName` varchar(150) DEFAULT NULL,\par
  `usr_id` int(10) DEFAULT NULL,\par
  `ban` tinyint(3) unsigned DEFAULT NULL\par
) ENGINE=MyISAM DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_apicache`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_apicache`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_apicache` (\par
  `cfg_site` varchar(16) NOT NULL DEFAULT '',\par
  `cfg_key` varchar(32) NOT NULL DEFAULT '',\par
  `cfg_value` text NOT NULL,\par
  PRIMARY KEY (`cfg_site`,`cfg_key`)\par
) ENGINE=InnoDB DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_apilog`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_apilog`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_apilog` (\par
  `log_site` varchar(20) NOT NULL,\par
  `log_keyname` varchar(20) NOT NULL,\par
  `log_posted` int(11) NOT NULL,\par
  `log_errors` int(11) NOT NULL,\par
  `log_ignored` int(11) NOT NULL,\par
  `log_verified` int(11) NOT NULL,\par
  `log_totalmails` int(11) NOT NULL,\par
  `log_source` varchar(20) NOT NULL,\par
  `log_type` varchar(20) NOT NULL,\par
  `log_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'\par
) ENGINE=InnoDB DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_banned_mails`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_banned_mails`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_banned_mails` (\par
  `bml_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\par
  `bml_ip` varchar(32) NOT NULL DEFAULT '',\par
  `bml_mail` text NOT NULL\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_battles_cache`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_battles_cache`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_battles_cache` (\par
  `battle_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `kll_id` int(11) NOT NULL,\par
  `killisk` bigint(20) NOT NULL,\par
  `lossisk` bigint(20) NOT NULL,\par
  `efficiency` float NOT NULL,\par
  `bar` tinyblob NOT NULL,\par
  `kills` int(11) NOT NULL,\par
  `losses` int(11) NOT NULL,\par
  `involved` int(11) NOT NULL,\par
  `system` varchar(100) NOT NULL,\par
  `start` datetime NOT NULL,\par
  `end` datetime NOT NULL,\par
  PRIMARY KEY (`battle_id`),\par
  KEY `start_end` (`end`,`start`)\par
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_comments`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_comments`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_comments` (\par
  `id` int(11) NOT NULL AUTO_INCREMENT,\par
  `site` char(16) COLLATE utf8_unicode_ci DEFAULT NULL,\par
  `kll_id` int(11) NOT NULL,\par
  `comment` text COLLATE utf8_unicode_ci NOT NULL,\par
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,\par
  `posttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\par
  `ip` varbinary(39) NOT NULL DEFAULT '0:0:0:0',\par
  PRIMARY KEY (`id`),\par
  KEY `site_kll_id` (`site`,`kll_id`)\par
) ENGINE=InnoDB AUTO_INCREMENT=2914 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_config`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_config`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_config` (\par
  `cfg_site` varchar(16) NOT NULL DEFAULT '',\par
  `cfg_key` varchar(32) NOT NULL DEFAULT '',\par
  `cfg_value` text NOT NULL,\par
  PRIMARY KEY (`cfg_site`,`cfg_key`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_constellations`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_constellations`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_constellations` (\par
  `con_id` int(11) NOT NULL DEFAULT '0',\par
  `con_name` char(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\par
  `con_reg_id` int(11) NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`con_id`),\par
  KEY `con_reg_id` (`con_reg_id`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_contract_details`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_contract_details`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_contract_details` (\par
  `ctd_ctr_id` int(11) NOT NULL DEFAULT '0',\par
  `ctd_crp_id` int(11) NOT NULL DEFAULT '0',\par
  `ctd_all_id` int(11) NOT NULL DEFAULT '0',\par
  `ctd_reg_id` int(11) NOT NULL DEFAULT '0',\par
  `ctd_sys_id` int(11) NOT NULL DEFAULT '0',\par
  KEY `ctd_ctr_id` (`ctd_ctr_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_contracts`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_contracts`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_contracts` (\par
  `ctr_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `ctr_name` varchar(128) NOT NULL DEFAULT '',\par
  `ctr_site` varchar(64) NOT NULL DEFAULT '',\par
  `ctr_campaign` smallint(6) NOT NULL DEFAULT '0',\par
  `ctr_started` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\par
  `ctr_ended` datetime DEFAULT '0000-00-00 00:00:00',\par
  PRIMARY KEY (`ctr_id`)\par
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_corps`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_corps`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_corps` (\par
  `crp_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `crp_name` varchar(64) NOT NULL DEFAULT '',\par
  `crp_all_id` int(11) NOT NULL DEFAULT '0',\par
  `crp_updated` datetime DEFAULT NULL,\par
  `crp_external_id` int(11) unsigned DEFAULT NULL,\par
  PRIMARY KEY (`crp_id`),\par
  UNIQUE KEY `crp_external_id` (`crp_external_id`),\par
  KEY `crp_all` (`crp_all_id`),\par
  KEY `crp_name` (`crp_name`)\par
) ENGINE=InnoDB AUTO_INCREMENT=15717 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_dgmattributetypes`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_dgmattributetypes`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_dgmattributetypes` (\par
  `attributeID` int(11) NOT NULL DEFAULT '0',\par
  `attributeName` char(100) NOT NULL,\par
  `icon` char(5) NOT NULL,\par
  `defaultValue` int(11) NOT NULL DEFAULT '0',\par
  `published` enum('true','false') NOT NULL DEFAULT 'true',\par
  `displayName` char(100) NOT NULL,\par
  `unitID` int(11) DEFAULT NULL,\par
  `stackable` enum('true','false') NOT NULL DEFAULT 'true',\par
  `highIsGood` enum('true','false') NOT NULL DEFAULT 'true',\par
  PRIMARY KEY (`attributeID`),\par
  KEY `attributeName` (`attributeName`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_dgmeffects`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_dgmeffects`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_dgmeffects` (\par
  `effectID` smallint(5) NOT NULL DEFAULT '0',\par
  `effectName` text NOT NULL,\par
  `effectCategory` smallint(5) NOT NULL DEFAULT '0',\par
  `preExpression` int(11) DEFAULT NULL,\par
  `postExpression` int(11) DEFAULT NULL,\par
  `description` text,\par
  `guid` char(60) DEFAULT NULL,\par
  `graphicID` smallint(5) DEFAULT NULL,\par
  `isOffensive` enum('true','false') NOT NULL DEFAULT 'false',\par
  `isAssistance` enum('true','false') NOT NULL DEFAULT 'false',\par
  `durationAttributeID` smallint(5) DEFAULT NULL,\par
  `trackingSpeedAttributeID` smallint(5) DEFAULT NULL,\par
  `dischargeAttributeID` smallint(5) DEFAULT NULL,\par
  `rangeAttributeID` smallint(5) DEFAULT NULL,\par
  `falloffAttributeID` smallint(5) DEFAULT NULL,\par
  `disallowAutoRepeat` enum('true','false') NOT NULL DEFAULT 'false',\par
  `published` enum('true','false') NOT NULL DEFAULT 'true',\par
  `displayName` char(100) NOT NULL,\par
  `isWarpSafe` enum('true','false') NOT NULL DEFAULT 'false',\par
  `rangeChance` enum('true','false') NOT NULL DEFAULT 'false',\par
  `electronicChance` enum('true','false') NOT NULL DEFAULT 'false',\par
  `propulsionChance` enum('true','false') NOT NULL DEFAULT 'false',\par
  `distribution` int(11) DEFAULT NULL,\par
  `sfxName` char(20) NOT NULL,\par
  `npcUsageChanceAttributeID` smallint(5) DEFAULT NULL,\par
  `npcActivationChanceAttributeID` smallint(5) DEFAULT NULL,\par
  `fittingUsageChanceAttributeID` smallint(5) DEFAULT NULL,\par
  PRIMARY KEY (`effectID`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_dgmtypeattributes`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_dgmtypeattributes`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_dgmtypeattributes` (\par
  `typeID` smallint(5) NOT NULL DEFAULT '0',\par
  `attributeID` smallint(5) NOT NULL DEFAULT '0',\par
  `value` double NOT NULL,\par
  KEY `typeID` (`typeID`),\par
  KEY `attributeID` (`attributeID`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_dgmtypeeffects`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_dgmtypeeffects`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_dgmtypeeffects` (\par
  `typeID` int(11) NOT NULL DEFAULT '0',\par
  `effectID` int(11) NOT NULL DEFAULT '0',\par
  `isDefault` enum('true','false') NOT NULL DEFAULT 'false',\par
  PRIMARY KEY (`typeID`,`effectID`),\par
  KEY `isDefault` (`isDefault`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_eve_central`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_eve_central`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_eve_central` (\par
  `item_id` int(10) unsigned NOT NULL,\par
  `item_price` varchar(20) DEFAULT NULL,\par
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\par
  PRIMARY KEY (`item_id`)\par
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='EVE central sync tracker';\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_eveunits`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_eveunits`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_eveunits` (\par
  `unitID` int(5) NOT NULL DEFAULT '0',\par
  `unitName` char(100) DEFAULT NULL,\par
  `displayName` char(20) DEFAULT NULL,\par
  `description` text,\par
  PRIMARY KEY (`unitID`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_inv_all`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_inv_all`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_inv_all` (\par
  `ina_kll_id` int(6) NOT NULL DEFAULT '0',\par
  `ina_all_id` int(3) NOT NULL DEFAULT '0',\par
  `ina_timestamp` datetime NOT NULL,\par
  PRIMARY KEY (`ina_kll_id`,`ina_all_id`),\par
  KEY `ina_all_time` (`ina_all_id`,`ina_timestamp`)\par
) ENGINE=InnoDB DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_inv_crp`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_inv_crp`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_inv_crp` (\par
  `inc_kll_id` int(6) NOT NULL DEFAULT '0',\par
  `inc_crp_id` int(3) NOT NULL DEFAULT '0',\par
  `inc_timestamp` datetime NOT NULL,\par
  PRIMARY KEY (`inc_kll_id`,`inc_crp_id`),\par
  KEY `inc_crp_time` (`inc_crp_id`,`inc_timestamp`)\par
) ENGINE=InnoDB DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_inv_detail`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_inv_detail`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_inv_detail` (\par
  `ind_kll_id` int(6) NOT NULL DEFAULT '0',\par
  `ind_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\par
  `ind_plt_id` int(6) NOT NULL DEFAULT '0',\par
  `ind_sec_status` varchar(5) DEFAULT NULL,\par
  `ind_all_id` int(3) NOT NULL DEFAULT '0',\par
  `ind_crp_id` int(5) NOT NULL DEFAULT '0',\par
  `ind_shp_id` int(3) NOT NULL DEFAULT '0',\par
  `ind_wep_id` int(5) NOT NULL DEFAULT '0',\par
  `ind_order` int(2) NOT NULL DEFAULT '0',\par
  `ind_dmgdone` int(11) NOT NULL,\par
  KEY `ind_shp_id` (`ind_shp_id`),\par
  KEY `ind_kll_id` (`ind_kll_id`),\par
  KEY `ind_plt_id` (`ind_plt_id`),\par
  KEY `ind_crp_id` (`ind_crp_id`),\par
  KEY `ind_plt_time` (`ind_plt_id`,`ind_timestamp`),\par
  KEY `ind_all_id` (`ind_all_id`),\par
  KEY `ind_timestamp` (`ind_timestamp`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_invtypes`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_invtypes`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_invtypes` (\par
  `typeID` int(11) NOT NULL DEFAULT '0',\par
  `groupID` int(11) NOT NULL DEFAULT '0',\par
  `typeName` char(100) NOT NULL,\par
  `description` text NOT NULL,\par
  `icon` char(5) DEFAULT NULL,\par
  `radius` float NOT NULL DEFAULT '0',\par
  `mass` float NOT NULL DEFAULT '0',\par
  `volume` float NOT NULL DEFAULT '0',\par
  `capacity` float NOT NULL DEFAULT '0',\par
  `portionSize` int(11) NOT NULL DEFAULT '1',\par
  `raceID` int(11) DEFAULT NULL,\par
  `basePrice` float NOT NULL DEFAULT '0',\par
  `marketGroupID` int(11) DEFAULT NULL,\par
  PRIMARY KEY (`typeID`),\par
  KEY `groupID` (`groupID`),\par
  KEY `marketGroupID` (`marketGroupID`),\par
  KEY `typeName` (`typeName`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_ip_bans`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_ip_bans`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_ip_bans` (\par
  `ipb_ip` varchar(32) NOT NULL DEFAULT '',\par
  `ipb_comment` varchar(128) NOT NULL DEFAULT '',\par
  UNIQUE KEY `ipb_ip` (`ipb_ip`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_item_locations`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_item_locations`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_item_locations` (\par
  `itl_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `itl_location` char(24) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\par
  PRIMARY KEY (`itl_id`),\par
  KEY `itl_id` (`itl_location`,`itl_id`)\par
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_item_price`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_item_price`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_item_price` (\par
  `typeID` int(11) NOT NULL,\par
  `price` bigint(11) NOT NULL,\par
  PRIMARY KEY (`typeID`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_item_types`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_item_types`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_item_types` (\par
  `itt_id` int(11) NOT NULL DEFAULT '0',\par
  `itt_cat` int(11) NOT NULL,\par
  `itt_name` char(120) NOT NULL,\par
  `itt_slot` tinyint(4) NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`itt_id`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_items_destroyed`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_items_destroyed`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_items_destroyed` (\par
  `itd_kll_id` int(11) NOT NULL DEFAULT '0',\par
  `itd_itm_id` int(11) NOT NULL DEFAULT '0',\par
  `itd_quantity` int(11) NOT NULL DEFAULT '1',\par
  `itd_itl_id` smallint(11) NOT NULL DEFAULT '0',\par
  KEY `itd_kll_id` (`itd_kll_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_items_dropped`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_items_dropped`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_items_dropped` (\par
  `itd_kll_id` int(11) NOT NULL DEFAULT '0',\par
  `itd_itm_id` int(11) NOT NULL DEFAULT '0',\par
  `itd_quantity` int(11) NOT NULL DEFAULT '1',\par
  `itd_itl_id` smallint(11) NOT NULL DEFAULT '0',\par
  KEY `itd_kll_id` (`itd_kll_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_kill_poster`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_kill_poster`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_kill_poster` (\par
  `kill_id` int(3) unsigned DEFAULT '0',\par
  `charID` int(3) unsigned DEFAULT '0'\par
) ENGINE=MyISAM DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_kills`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_kills`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_kills` (\par
  `kll_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `kll_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\par
  `kll_victim_id` int(6) NOT NULL DEFAULT '0',\par
  `kll_all_id` int(3) NOT NULL DEFAULT '0',\par
  `kll_crp_id` int(6) NOT NULL DEFAULT '0',\par
  `kll_ship_id` int(3) NOT NULL DEFAULT '0',\par
  `kll_system_id` int(4) NOT NULL DEFAULT '0',\par
  `kll_fb_plt_id` int(6) DEFAULT NULL,\par
  `kll_points` int(11) NOT NULL DEFAULT '0',\par
  `kll_dmgtaken` int(11) NOT NULL DEFAULT '0',\par
  `kll_external_id` int(11) unsigned DEFAULT NULL,\par
  `kll_isk_loss` float NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`kll_id`),\par
  UNIQUE KEY `kll_external_id` (`kll_external_id`),\par
  KEY `kll_ship_id` (`kll_ship_id`),\par
  KEY `kll_victim_id` (`kll_victim_id`),\par
  KEY `kll_timestamp` (`kll_timestamp`),\par
  KEY `kll_all_id` (`kll_all_id`),\par
  KEY `kll_crp_id` (`kll_crp_id`),\par
  KEY `kll_system_id` (`kll_system_id`)\par
) ENGINE=InnoDB AUTO_INCREMENT=72864 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_log`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_log`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_log` (\par
  `log_kll_id` int(11) NOT NULL DEFAULT '0',\par
  `log_site` varchar(20) NOT NULL DEFAULT '',\par
  `log_ip_address` varchar(100) NOT NULL,\par
  `log_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\par
  UNIQUE KEY `log_kll_id` (`log_kll_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_moons`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_moons`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_moons` (\par
  `itemID` int(11) NOT NULL,\par
  `itemName` varchar(100) DEFAULT NULL,\par
  PRIMARY KEY (`itemID`)\par
) ENGINE=MyISAM DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_navigation`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_navigation`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_navigation` (\par
  `ID` int(11) NOT NULL AUTO_INCREMENT,\par
  `nav_type` tinytext NOT NULL,\par
  `intern` int(1) NOT NULL,\par
  `descr` tinytext NOT NULL,\par
  `url` tinytext NOT NULL,\par
  `target` varchar(10) NOT NULL,\par
  `posnr` int(11) NOT NULL,\par
  `page` tinytext NOT NULL,\par
  `hidden` tinyint(1) NOT NULL DEFAULT '0',\par
  `KBSITE` varchar(16) NOT NULL,\par
  PRIMARY KEY (`ID`)\par
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_pilots`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_pilots`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_pilots` (\par
  `plt_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `plt_name` varchar(64) NOT NULL,\par
  `plt_crp_id` int(11) NOT NULL DEFAULT '0',\par
  `plt_externalid` int(11) NOT NULL DEFAULT '0',\par
  `plt_updated` datetime DEFAULT NULL,\par
  PRIMARY KEY (`plt_id`),\par
  UNIQUE KEY `plt_name` (`plt_name`)\par
) ENGINE=InnoDB AUTO_INCREMENT=73096 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_races`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_races`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_races` (\par
  `rce_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `rce_race` char(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\par
  PRIMARY KEY (`rce_id`)\par
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_regions`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_regions`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_regions` (\par
  `reg_id` int(11) NOT NULL DEFAULT '0',\par
  `reg_name` char(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\par
  `reg_x` float NOT NULL DEFAULT '0',\par
  `reg_y` float NOT NULL DEFAULT '0',\par
  `reg_z` float NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`reg_id`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_roles`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_roles`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_roles` (\par
  `rol_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `rol_site` varchar(16) NOT NULL,\par
  `rol_name` varchar(200) NOT NULL,\par
  `rol_descr` varchar(200) NOT NULL,\par
  PRIMARY KEY (`rol_id`),\par
  UNIQUE KEY `rol_name` (`rol_name`)\par
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_ship_classes`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_ship_classes`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_ship_classes` (\par
  `scl_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `scl_class` char(32) NOT NULL,\par
  `scl_value` bigint(4) NOT NULL DEFAULT '0',\par
  `scl_points` int(11) NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`scl_id`),\par
  UNIQUE KEY `scl_class` (`scl_class`)\par
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_ships`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_ships`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_ships` (\par
  `shp_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `shp_name` char(64) NOT NULL,\par
  `shp_class` int(11) NOT NULL DEFAULT '18',\par
  `shp_externalid` int(11) NOT NULL DEFAULT '0',\par
  `shp_rce_id` int(11) NOT NULL DEFAULT '0',\par
  `shp_baseprice` bigint(12) NOT NULL DEFAULT '0',\par
  `shp_techlevel` tinyint(4) NOT NULL DEFAULT '1',\par
  PRIMARY KEY (`shp_id`),\par
  UNIQUE KEY `shp_name` (`shp_name`),\par
  KEY `shp_class` (`shp_class`)\par
) ENGINE=MyISAM AUTO_INCREMENT=698 DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_ships_values`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_ships_values`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_ships_values` (\par
  `shp_id` int(11) NOT NULL,\par
  `shp_value` bigint(4) NOT NULL,\par
  PRIMARY KEY (`shp_id`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_standings`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_standings`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_standings` (\par
  `sta_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `sta_from` int(11) NOT NULL DEFAULT '0',\par
  `sta_to` int(11) NOT NULL DEFAULT '0',\par
  `sta_from_type` enum('a','c') NOT NULL DEFAULT 'a',\par
  `sta_to_type` enum('a','c') NOT NULL DEFAULT 'a',\par
  `sta_value` float NOT NULL DEFAULT '0',\par
  `sta_comment` varchar(200) NOT NULL,\par
  `site` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\par
  `from_ts` datetime NOT NULL,\par
  `to_ts` datetime NOT NULL DEFAULT '2999-12-31 23:59:59',\par
  PRIMARY KEY (`sta_id`),\par
  KEY `sta_from` (`sta_from`),\par
  KEY `site` (`site`)\par
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_sum_alliance`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_sum_alliance`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_sum_alliance` (\par
  `asm_all_id` int(11) NOT NULL DEFAULT '0',\par
  `asm_shp_id` int(3) NOT NULL DEFAULT '0',\par
  `asm_kill_count` int(11) NOT NULL DEFAULT '0',\par
  `asm_kill_isk` float NOT NULL DEFAULT '0',\par
  `asm_loss_count` int(11) NOT NULL DEFAULT '0',\par
  `asm_loss_isk` float NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`asm_all_id`,`asm_shp_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_sum_corp`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_sum_corp`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_sum_corp` (\par
  `csm_crp_id` int(11) NOT NULL DEFAULT '0',\par
  `csm_shp_id` int(3) NOT NULL DEFAULT '0',\par
  `csm_kill_count` int(11) NOT NULL DEFAULT '0',\par
  `csm_kill_isk` float NOT NULL DEFAULT '0',\par
  `csm_loss_count` int(11) NOT NULL DEFAULT '0',\par
  `csm_loss_isk` float NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`csm_crp_id`,`csm_shp_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_sum_pilot`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_sum_pilot`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_sum_pilot` (\par
  `psm_plt_id` int(11) NOT NULL DEFAULT '0',\par
  `psm_shp_id` int(3) NOT NULL DEFAULT '0',\par
  `psm_kill_count` int(11) NOT NULL DEFAULT '0',\par
  `psm_kill_isk` float NOT NULL DEFAULT '0',\par
  `psm_loss_count` int(11) NOT NULL DEFAULT '0',\par
  `psm_loss_isk` float NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`psm_plt_id`,`psm_shp_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_system_jumps`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_system_jumps`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_system_jumps` (\par
  `sjp_from` int(11) NOT NULL DEFAULT '0',\par
  `sjp_to` int(11) NOT NULL DEFAULT '0',\par
  KEY `sjp_from` (`sjp_from`)\par
) ENGINE=MyISAM DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_systems`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_systems`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_systems` (\par
  `sys_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `sys_eve_id` int(11) NOT NULL DEFAULT '0',\par
  `sys_con_id` int(11) NOT NULL DEFAULT '0',\par
  `sys_name` char(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\par
  `sys_x` float NOT NULL DEFAULT '0',\par
  `sys_y` float NOT NULL DEFAULT '0',\par
  `sys_z` float NOT NULL DEFAULT '0',\par
  `sys_sec` decimal(12,5) NOT NULL DEFAULT '0.00000',\par
  PRIMARY KEY (`sys_id`),\par
  KEY `sys_eve_id` (`sys_eve_id`),\par
  KEY `sys_con_id` (`sys_con_id`),\par
  KEY `sys_name` (`sys_name`)\par
) ENGINE=MyISAM AUTO_INCREMENT=7931 DEFAULT CHARSET=utf8;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_titles`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_titles`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_titles` (\par
  `ttl_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `ttl_name` varchar(100) NOT NULL,\par
  `ttl_descr` varchar(200) NOT NULL,\par
  `ttl_site` varchar(16) NOT NULL,\par
  PRIMARY KEY (`ttl_id`),\par
  UNIQUE KEY `ttl_name` (`ttl_name`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_titles_roles`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_titles_roles`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_titles_roles` (\par
  `ttl_id` int(11) NOT NULL,\par
  `rol_id` int(11) NOT NULL,\par
  KEY `ttl_id` (`ttl_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_user`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_user`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_user` (\par
  `usr_id` int(11) NOT NULL AUTO_INCREMENT,\par
  `usr_site` varchar(16) NOT NULL,\par
  `usr_login` varchar(40) NOT NULL,\par
  `usr_pass` varchar(32) NOT NULL,\par
  `usr_pilot_id` int(11) NOT NULL DEFAULT '0',\par
  `usr_state` tinyint(1) NOT NULL DEFAULT '0',\par
  PRIMARY KEY (`usr_id`),\par
  UNIQUE KEY `sitelogin` (`usr_site`,`usr_login`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_user_extra`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_user_extra`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_user_extra` (\par
  `use_usr_id` int(11) NOT NULL,\par
  `use_key` varchar(60) NOT NULL,\par
  `use_value` varchar(200) NOT NULL,\par
  KEY `use_usr_id` (`use_usr_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_user_roles`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_user_roles`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_user_roles` (\par
  `uro_usr_id` int(11) NOT NULL,\par
  `uro_rol_id` int(11) NOT NULL,\par
  KEY `uro_usr_id` (`uro_usr_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
\par
--\par
-- Table structure for table `kb3_user_titles`\par
--\par
\par
DROP TABLE IF EXISTS `kb3_user_titles`;\par
/*!40101 SET @saved_cs_client     = @@character_set_client */;\par
/*!40101 SET character_set_client = utf8 */;\par
CREATE TABLE `kb3_user_titles` (\par
  `ust_usr_id` int(11) NOT NULL,\par
  `ust_ttl_id` int(11) NOT NULL,\par
  KEY `ust_usr_id` (`ust_usr_id`)\par
) ENGINE=InnoDB DEFAULT CHARSET=latin1;\par
/*!40101 SET character_set_client = @saved_cs_client */;\par
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;\par
\par
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;\par
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;\par
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;\par
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\par
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\par
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\par
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;\par
\par
-- Dump completed on 2010-01-21 13:47:34\par
}