-- MySQL dump 10.11
--
-- Host: localhost    Database: mssql
-- ------------------------------------------------------
-- Server version	5.0.84-log

/*!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 `agtAgentTypes`
--

DROP TABLE IF EXISTS `agtAgentTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agtAgentTypes` (
  `agentTypeID` int(11) NOT NULL,
  `agentType` varchar(50) default NULL,
  PRIMARY KEY  (`agentTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `agtAgents`
--

DROP TABLE IF EXISTS `agtAgents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agtAgents` (
  `agentID` int(11) NOT NULL,
  `divisionID` tinyint(3) unsigned default NULL,
  `corporationID` int(11) default NULL,
  `locationID` int(11) default NULL,
  `level` tinyint(4) default NULL,
  `quality` smallint(6) default NULL,
  `agentTypeID` int(11) default NULL,
  PRIMARY KEY  (`agentID`),
  KEY `agtAgents_IX_corporation` (`corporationID`),
  KEY `agtAgents_IX_station` (`locationID`),
  KEY `divisionID` (`divisionID`),
  KEY `agentTypeID` (`agentTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `agtConfig`
--

DROP TABLE IF EXISTS `agtConfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agtConfig` (
  `agentID` int(11) NOT NULL,
  `k` varchar(50) NOT NULL,
  `v` varchar(4000) default NULL,
  PRIMARY KEY  (`agentID`,`k`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `agtResearchAgents`
--

DROP TABLE IF EXISTS `agtResearchAgents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agtResearchAgents` (
  `agentID` int(11) NOT NULL,
  `typeID` int(11) NOT NULL,
  PRIMARY KEY  (`agentID`,`typeID`),
  KEY `agtResearchAgents_IX_type` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chrAncestries`
--

DROP TABLE IF EXISTS `chrAncestries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chrAncestries` (
  `ancestryID` tinyint(3) unsigned NOT NULL,
  `ancestryName` varchar(100) default NULL,
  `bloodlineID` tinyint(3) unsigned default NULL,
  `description` varchar(1000) default NULL,
  `perception` tinyint(4) default NULL,
  `willpower` tinyint(4) default NULL,
  `charisma` tinyint(4) default NULL,
  `memory` tinyint(4) default NULL,
  `intelligence` tinyint(4) default NULL,
  `iconID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  PRIMARY KEY  (`ancestryID`),
  KEY `bloodlineID` (`bloodlineID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chrAttributes`
--

DROP TABLE IF EXISTS `chrAttributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chrAttributes` (
  `attributeID` tinyint(3) unsigned NOT NULL,
  `attributeName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `iconID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  `notes` varchar(500) default NULL,
  PRIMARY KEY  (`attributeID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chrBloodlines`
--

DROP TABLE IF EXISTS `chrBloodlines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chrBloodlines` (
  `bloodlineID` tinyint(3) unsigned NOT NULL,
  `bloodlineName` varchar(100) default NULL,
  `raceID` tinyint(3) unsigned default NULL,
  `description` varchar(1000) default NULL,
  `maleDescription` varchar(1000) default NULL,
  `femaleDescription` varchar(1000) default NULL,
  `shipTypeID` int(11) default NULL,
  `corporationID` int(11) default NULL,
  `perception` tinyint(4) default NULL,
  `willpower` tinyint(4) default NULL,
  `charisma` tinyint(4) default NULL,
  `memory` tinyint(4) default NULL,
  `intelligence` tinyint(4) default NULL,
  `iconID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  `shortMaleDescription` varchar(500) default NULL,
  `shortFemaleDescription` varchar(500) default NULL,
  PRIMARY KEY  (`bloodlineID`),
  KEY `raceID` (`raceID`),
  KEY `shipTypeID` (`shipTypeID`),
  KEY `corporationID` (`corporationID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chrFactions`
--

DROP TABLE IF EXISTS `chrFactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chrFactions` (
  `factionID` int(11) NOT NULL,
  `factionName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `raceIDs` int(11) default NULL,
  `solarSystemID` int(11) default NULL,
  `corporationID` int(11) default NULL,
  `sizeFactor` double default NULL,
  `stationCount` smallint(6) default NULL,
  `stationSystemCount` smallint(6) default NULL,
  `militiaCorporationID` int(11) default NULL,
  `iconID` smallint(6) default NULL,
  PRIMARY KEY  (`factionID`),
  KEY `solarSystemID` (`solarSystemID`),
  KEY `corporationID` (`corporationID`),
  KEY `militiaCorporationID` (`militiaCorporationID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chrRaces`
--

DROP TABLE IF EXISTS `chrRaces`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chrRaces` (
  `raceID` tinyint(3) unsigned NOT NULL,
  `raceName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `iconID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  PRIMARY KEY  (`raceID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crpActivities`
--

DROP TABLE IF EXISTS `crpActivities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crpActivities` (
  `activityID` tinyint(3) unsigned NOT NULL,
  `activityName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  PRIMARY KEY  (`activityID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crpNPCCorporationDivisions`
--

DROP TABLE IF EXISTS `crpNPCCorporationDivisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crpNPCCorporationDivisions` (
  `corporationID` int(11) NOT NULL,
  `divisionID` tinyint(3) unsigned NOT NULL,
  `size` tinyint(4) default NULL,
  PRIMARY KEY  (`corporationID`,`divisionID`),
  KEY `divisionID` (`divisionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crpNPCCorporationResearchFields`
--

DROP TABLE IF EXISTS `crpNPCCorporationResearchFields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crpNPCCorporationResearchFields` (
  `skillID` int(11) NOT NULL,
  `corporationID` int(11) NOT NULL,
  PRIMARY KEY  (`skillID`,`corporationID`),
  KEY `corporationID` (`corporationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crpNPCCorporationTrades`
--

DROP TABLE IF EXISTS `crpNPCCorporationTrades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crpNPCCorporationTrades` (
  `corporationID` int(11) NOT NULL,
  `typeID` int(11) NOT NULL,
  PRIMARY KEY  (`corporationID`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crpNPCCorporations`
--

DROP TABLE IF EXISTS `crpNPCCorporations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crpNPCCorporations` (
  `corporationID` int(11) NOT NULL,
  `size` char(1) default NULL,
  `extent` char(1) default NULL,
  `solarSystemID` int(11) default NULL,
  `investorID1` int(11) default NULL,
  `investorShares1` tinyint(4) default NULL,
  `investorID2` int(11) default NULL,
  `investorShares2` tinyint(4) default NULL,
  `investorID3` int(11) default NULL,
  `investorShares3` tinyint(4) default NULL,
  `investorID4` int(11) default NULL,
  `investorShares4` tinyint(4) default NULL,
  `friendID` int(11) default NULL,
  `enemyID` int(11) default NULL,
  `publicShares` bigint(20) default NULL,
  `initialPrice` int(11) default NULL,
  `minSecurity` double default NULL,
  `scattered` tinyint(1) default NULL,
  `fringe` tinyint(4) default NULL,
  `corridor` tinyint(4) default NULL,
  `hub` tinyint(4) default NULL,
  `border` tinyint(4) default NULL,
  `factionID` int(11) default NULL,
  `sizeFactor` double default NULL,
  `stationCount` smallint(6) default NULL,
  `stationSystemCount` smallint(6) default NULL,
  `description` varchar(4000) default NULL,
  `iconID` smallint(6) default NULL,
  PRIMARY KEY  (`corporationID`),
  KEY `solarSystemID` (`solarSystemID`),
  KEY `factionID` (`factionID`),
  KEY `investorID1` (`investorID1`),
  KEY `investorID2` (`investorID2`),
  KEY `investorID3` (`investorID3`),
  KEY `investorID4` (`investorID4`),
  KEY `friendID` (`friendID`),
  KEY `enemyID` (`enemyID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crpNPCDivisions`
--

DROP TABLE IF EXISTS `crpNPCDivisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crpNPCDivisions` (
  `divisionID` tinyint(3) unsigned NOT NULL,
  `divisionName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `leaderType` varchar(100) default NULL,
  PRIMARY KEY  (`divisionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crtCategories`
--

DROP TABLE IF EXISTS `crtCategories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crtCategories` (
  `categoryID` tinyint(3) unsigned NOT NULL,
  `description` varchar(500) default NULL,
  `categoryName` varchar(256) default NULL,
  PRIMARY KEY  (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crtCertificates`
--

DROP TABLE IF EXISTS `crtCertificates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crtCertificates` (
  `certificateID` int(11) NOT NULL,
  `categoryID` tinyint(3) unsigned default NULL,
  `classID` int(11) default NULL,
  `grade` tinyint(4) default NULL,
  `corpID` int(11) default NULL,
  `iconID` smallint(6) default NULL,
  `description` varchar(500) default NULL,
  PRIMARY KEY  (`certificateID`),
  KEY `crtCertificates_IX_category` (`categoryID`),
  KEY `crtCertificates_IX_class` (`classID`),
  KEY `corpID` (`corpID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crtClasses`
--

DROP TABLE IF EXISTS `crtClasses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crtClasses` (
  `classID` int(11) NOT NULL,
  `description` varchar(500) default NULL,
  `className` varchar(256) default NULL,
  PRIMARY KEY  (`classID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crtRecommendations`
--

DROP TABLE IF EXISTS `crtRecommendations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crtRecommendations` (
  `recommendationID` int(11) NOT NULL,
  `shipTypeID` int(11) default NULL,
  `certificateID` int(11) default NULL,
  `recommendationLevel` tinyint(4) NOT NULL,
  PRIMARY KEY  (`recommendationID`),
  KEY `crtRecommendations_IX_certificate` (`certificateID`),
  KEY `crtRecommendations_IX_shipType` (`shipTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crtRelationships`
--

DROP TABLE IF EXISTS `crtRelationships`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crtRelationships` (
  `relationshipID` int(11) NOT NULL,
  `parentID` int(11) default NULL,
  `parentTypeID` int(11) default NULL,
  `parentLevel` tinyint(4) default NULL,
  `childID` int(11) default NULL,
  PRIMARY KEY  (`relationshipID`),
  KEY `crtRelationships_IX_child` (`childID`),
  KEY `crtRelationships_IX_parent` (`parentID`),
  KEY `parentTypeID` (`parentTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dgmAttributeCategories`
--

DROP TABLE IF EXISTS `dgmAttributeCategories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dgmAttributeCategories` (
  `categoryID` tinyint(3) unsigned NOT NULL,
  `categoryName` varchar(50) default NULL,
  `categoryDescription` varchar(200) default NULL,
  PRIMARY KEY  (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dgmAttributeTypes`
--

DROP TABLE IF EXISTS `dgmAttributeTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dgmAttributeTypes` (
  `attributeID` smallint(6) NOT NULL,
  `attributeName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `iconID` smallint(6) default NULL,
  `defaultValue` double default NULL,
  `published` tinyint(1) default NULL,
  `displayName` varchar(100) default NULL,
  `unitID` tinyint(3) unsigned default NULL,
  `stackable` tinyint(1) default NULL,
  `highIsGood` tinyint(1) default NULL,
  `categoryID` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`attributeID`),
  KEY `categoryID` (`categoryID`),
  KEY `unitID` (`unitID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dgmEffects`
--

DROP TABLE IF EXISTS `dgmEffects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dgmEffects` (
  `effectID` smallint(6) NOT NULL,
  `effectName` varchar(400) default NULL,
  `effectCategory` smallint(6) default NULL,
  `preExpression` int(11) default NULL,
  `postExpression` int(11) default NULL,
  `description` varchar(1000) default NULL,
  `guid` varchar(60) default NULL,
  `iconID` smallint(6) default NULL,
  `isOffensive` tinyint(1) default NULL,
  `isAssistance` tinyint(1) default NULL,
  `durationAttributeID` smallint(6) default NULL,
  `trackingSpeedAttributeID` smallint(6) default NULL,
  `dischargeAttributeID` smallint(6) default NULL,
  `rangeAttributeID` smallint(6) default NULL,
  `falloffAttributeID` smallint(6) default NULL,
  `disallowAutoRepeat` tinyint(1) default NULL,
  `published` tinyint(1) default NULL,
  `displayName` varchar(100) default NULL,
  `isWarpSafe` tinyint(1) default NULL,
  `rangeChance` tinyint(1) default NULL,
  `electronicChance` tinyint(1) default NULL,
  `propulsionChance` tinyint(1) default NULL,
  `distribution` tinyint(4) default NULL,
  `sfxName` varchar(20) default NULL,
  `npcUsageChanceAttributeID` smallint(6) default NULL,
  `npcActivationChanceAttributeID` smallint(6) default NULL,
  `fittingUsageChanceAttributeID` smallint(6) default NULL,
  PRIMARY KEY  (`effectID`),
  KEY `durationAttributeID` (`durationAttributeID`),
  KEY `trackingSpeedAttributeID` (`trackingSpeedAttributeID`),
  KEY `dischargeAttributeID` (`dischargeAttributeID`),
  KEY `rangeAttributeID` (`rangeAttributeID`),
  KEY `falloffAttributeID` (`falloffAttributeID`),
  KEY `npcUsageChanceAttributeID` (`npcUsageChanceAttributeID`),
  KEY `npcActivationChanceAttributeID` (`npcActivationChanceAttributeID`),
  KEY `fittingUsageChanceAttributeID` (`fittingUsageChanceAttributeID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dgmTypeAttributes`
--

DROP TABLE IF EXISTS `dgmTypeAttributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dgmTypeAttributes` (
  `typeID` int(11) NOT NULL,
  `attributeID` smallint(6) NOT NULL,
  `valueInt` int(11) default NULL,
  `valueFloat` double default NULL,
  PRIMARY KEY  (`typeID`,`attributeID`),
  KEY `attributeID` (`attributeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dgmTypeEffects`
--

DROP TABLE IF EXISTS `dgmTypeEffects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dgmTypeEffects` (
  `typeID` int(11) NOT NULL,
  `effectID` smallint(6) NOT NULL,
  `isDefault` tinyint(1) default NULL,
  PRIMARY KEY  (`typeID`,`effectID`),
  KEY `effectID` (`effectID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `eveGraphics`
--

DROP TABLE IF EXISTS `eveGraphics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eveGraphics` (
  `graphicID` smallint(6) NOT NULL default '0',
  `graphicFile` varchar(500) NOT NULL,
  `description` varchar(16000) NOT NULL,
  `obsolete` tinyint(1) NOT NULL,
  `graphicType` varchar(100) default NULL,
  `collidable` tinyint(1) default NULL,
  `explosionID` smallint(6) default NULL,
  `directoryID` int(11) default NULL,
  `graphicName` varchar(64) NOT NULL,
  PRIMARY KEY  (`graphicID`),
  KEY `explosionID` (`explosionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `eveIcons`
--

DROP TABLE IF EXISTS `eveIcons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eveIcons` (
  `iconID` smallint(6) NOT NULL default '0',
  `iconFile` varchar(500) NOT NULL,
  `description` varchar(16000) NOT NULL,
  PRIMARY KEY  (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `eveNames`
--

DROP TABLE IF EXISTS `eveNames`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eveNames` (
  `itemID` int(11) NOT NULL,
  `itemName` varchar(100) default NULL,
  `categoryID` tinyint(3) unsigned default NULL,
  `groupID` smallint(6) default NULL,
  `typeID` int(11) default NULL,
  PRIMARY KEY  (`itemID`),
  KEY `categoryID` (`categoryID`),
  KEY `groupID` (`groupID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `eveUnits`
--

DROP TABLE IF EXISTS `eveUnits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eveUnits` (
  `unitID` tinyint(3) unsigned NOT NULL,
  `unitName` varchar(100) default NULL,
  `displayName` varchar(20) default NULL,
  `description` varchar(1000) default NULL,
  PRIMARY KEY  (`unitID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invBlueprintTypes`
--

DROP TABLE IF EXISTS `invBlueprintTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invBlueprintTypes` (
  `blueprintTypeID` int(11) NOT NULL,
  `parentBlueprintTypeID` int(11) default NULL,
  `productTypeID` int(11) default NULL,
  `productionTime` int(11) default NULL,
  `techLevel` smallint(6) default NULL,
  `researchProductivityTime` int(11) default NULL,
  `researchMaterialTime` int(11) default NULL,
  `researchCopyTime` int(11) default NULL,
  `researchTechTime` int(11) default NULL,
  `productivityModifier` int(11) default NULL,
  `materialModifier` smallint(6) default NULL,
  `wasteFactor` smallint(6) default NULL,
  `maxProductionLimit` int(11) default NULL,
  PRIMARY KEY  (`blueprintTypeID`),
  KEY `parentBlueprintTypeID` (`parentBlueprintTypeID`),
  KEY `productTypeID` (`productTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invCategories`
--

DROP TABLE IF EXISTS `invCategories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invCategories` (
  `categoryID` tinyint(3) unsigned NOT NULL,
  `categoryName` varchar(100) default NULL,
  `description` varchar(3000) default NULL,
  `iconID` smallint(6) default NULL,
  `published` tinyint(1) default NULL,
  PRIMARY KEY  (`categoryID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invContrabandTypes`
--

DROP TABLE IF EXISTS `invContrabandTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invContrabandTypes` (
  `factionID` int(11) NOT NULL,
  `typeID` int(11) NOT NULL,
  `standingLoss` double default NULL,
  `confiscateMinSec` double default NULL,
  `fineByValue` double default NULL,
  `attackMinSec` double default NULL,
  PRIMARY KEY  (`factionID`,`typeID`),
  KEY `invContrabandTypes_IX_type` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invControlTowerResourcePurposes`
--

DROP TABLE IF EXISTS `invControlTowerResourcePurposes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invControlTowerResourcePurposes` (
  `purpose` tinyint(4) NOT NULL,
  `purposeText` varchar(100) default NULL,
  PRIMARY KEY  (`purpose`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invControlTowerResources`
--

DROP TABLE IF EXISTS `invControlTowerResources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invControlTowerResources` (
  `controlTowerTypeID` int(11) NOT NULL,
  `resourceTypeID` int(11) NOT NULL,
  `purpose` tinyint(4) default NULL,
  `quantity` int(11) default NULL,
  `minSecurityLevel` double default NULL,
  `factionID` int(11) default NULL,
  PRIMARY KEY  (`controlTowerTypeID`,`resourceTypeID`),
  KEY `resourceTypeID` (`resourceTypeID`),
  KEY `factionID` (`factionID`),
  KEY `purpose` (`purpose`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invFlags`
--

DROP TABLE IF EXISTS `invFlags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invFlags` (
  `flagID` smallint(6) NOT NULL,
  `flagName` varchar(200) default NULL,
  `flagText` varchar(100) default NULL,
  `orderID` int(11) default NULL,
  PRIMARY KEY  (`flagID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invGroups`
--

DROP TABLE IF EXISTS `invGroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invGroups` (
  `groupID` smallint(6) NOT NULL,
  `categoryID` tinyint(3) unsigned default NULL,
  `groupName` varchar(100) default NULL,
  `description` varchar(3000) default NULL,
  `iconID` smallint(6) default NULL,
  `useBasePrice` tinyint(1) default NULL,
  `allowManufacture` tinyint(1) default NULL,
  `allowRecycler` tinyint(1) default NULL,
  `anchored` tinyint(1) default NULL,
  `anchorable` tinyint(1) default NULL,
  `fittableNonSingleton` tinyint(1) default NULL,
  `published` tinyint(1) default NULL,
  PRIMARY KEY  (`groupID`),
  KEY `invGroups_IX_category` (`categoryID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invMarketGroups`
--

DROP TABLE IF EXISTS `invMarketGroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invMarketGroups` (
  `marketGroupID` smallint(6) NOT NULL,
  `parentGroupID` smallint(6) default NULL,
  `marketGroupName` varchar(100) default NULL,
  `description` varchar(3000) default NULL,
  `iconID` smallint(6) default NULL,
  `hasTypes` tinyint(1) default NULL,
  PRIMARY KEY  (`marketGroupID`),
  KEY `parentGroupID` (`parentGroupID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invMetaGroups`
--

DROP TABLE IF EXISTS `invMetaGroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invMetaGroups` (
  `metaGroupID` smallint(6) NOT NULL,
  `metaGroupName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `iconID` smallint(6) default NULL,
  PRIMARY KEY  (`metaGroupID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invMetaTypes`
--

DROP TABLE IF EXISTS `invMetaTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invMetaTypes` (
  `typeID` int(11) NOT NULL,
  `parentTypeID` int(11) default NULL,
  `metaGroupID` smallint(6) default NULL,
  PRIMARY KEY  (`typeID`),
  KEY `parentTypeID` (`parentTypeID`),
  KEY `metaGroupID` (`metaGroupID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invTypeMaterials`
--

DROP TABLE IF EXISTS `invTypeMaterials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invTypeMaterials` (
  `typeID` int(11) NOT NULL,
  `materialTypeID` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY  (`typeID`,`materialTypeID`),
  KEY `materialTypeID` (`materialTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invTypeReactions`
--

DROP TABLE IF EXISTS `invTypeReactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invTypeReactions` (
  `reactionTypeID` int(11) NOT NULL,
  `input` tinyint(1) NOT NULL,
  `typeID` int(11) NOT NULL,
  `quantity` smallint(6) default NULL,
  PRIMARY KEY  (`reactionTypeID`,`input`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invTypes`
--

DROP TABLE IF EXISTS `invTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invTypes` (
  `typeID` int(11) NOT NULL,
  `groupID` smallint(6) default NULL,
  `typeName` varchar(100) default NULL,
  `description` varchar(3000) default NULL,
  `graphicID` smallint(6) default NULL,
  `radius` double default NULL,
  `mass` double default NULL,
  `volume` double default NULL,
  `capacity` double default NULL,
  `portionSize` int(11) default NULL,
  `raceID` tinyint(3) unsigned default NULL,
  `basePrice` double default NULL,
  `published` tinyint(1) default NULL,
  `marketGroupID` smallint(6) default NULL,
  `chanceOfDuplicating` double default NULL,
  `iconID` smallint(6) default NULL,
  PRIMARY KEY  (`typeID`),
  KEY `invTypes_IX_Group` (`groupID`),
  KEY `graphicID` (`graphicID`),
  KEY `raceID` (`raceID`),
  KEY `marketGroupID` (`marketGroupID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapCelestialStatistics`
--

DROP TABLE IF EXISTS `mapCelestialStatistics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapCelestialStatistics` (
  `celestialID` int(11) NOT NULL,
  `temperature` double default NULL,
  `spectralClass` varchar(10) default NULL,
  `luminosity` double default NULL,
  `age` double default NULL,
  `life` double default NULL,
  `orbitRadius` double default NULL,
  `eccentricity` double default NULL,
  `massDust` double default NULL,
  `massGas` double default NULL,
  `fragmented` tinyint(1) default NULL,
  `density` double default NULL,
  `surfaceGravity` double default NULL,
  `escapeVelocity` double default NULL,
  `orbitPeriod` double default NULL,
  `rotationRate` double default NULL,
  `locked` tinyint(1) default NULL,
  `pressure` double default NULL,
  `radius` double default NULL,
  `mass` double default NULL,
  PRIMARY KEY  (`celestialID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapConstellationJumps`
--

DROP TABLE IF EXISTS `mapConstellationJumps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapConstellationJumps` (
  `fromRegionID` int(11) default NULL,
  `fromConstellationID` int(11) NOT NULL,
  `toConstellationID` int(11) NOT NULL,
  `toRegionID` int(11) default NULL,
  PRIMARY KEY  (`fromConstellationID`,`toConstellationID`),
  KEY `mapConstellationJumps_IX_fromRegion` (`fromRegionID`),
  KEY `toConstellationID` (`toConstellationID`,`toRegionID`),
  KEY `fromConstellationID` (`fromConstellationID`,`fromRegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapConstellations`
--

DROP TABLE IF EXISTS `mapConstellations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapConstellations` (
  `regionID` int(11) default NULL,
  `constellationID` int(11) NOT NULL,
  `constellationName` varchar(100) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `xMin` double default NULL,
  `xMax` double default NULL,
  `yMin` double default NULL,
  `yMax` double default NULL,
  `zMin` double default NULL,
  `zMax` double default NULL,
  `factionID` int(11) default NULL,
  `radius` double default NULL,
  PRIMARY KEY  (`constellationID`),
  UNIQUE KEY `constellationID` (`constellationID`,`regionID`),
  KEY `mapConstellations_IX_region` (`regionID`),
  KEY `factionID` (`factionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapDenormalize`
--

DROP TABLE IF EXISTS `mapDenormalize`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapDenormalize` (
  `itemID` int(11) NOT NULL,
  `typeID` int(11) default NULL,
  `groupID` smallint(6) default NULL,
  `solarSystemID` int(11) default NULL,
  `constellationID` int(11) default NULL,
  `regionID` int(11) default NULL,
  `orbitID` int(11) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `radius` double default NULL,
  `itemName` varchar(100) default NULL,
  `security` double default NULL,
  `celestialIndex` tinyint(4) default NULL,
  `orbitIndex` tinyint(4) default NULL,
  PRIMARY KEY  (`itemID`),
  KEY `mapDenormalize_IX_constellation` (`constellationID`),
  KEY `mapDenormalize_IX_groupConstellation` (`groupID`,`constellationID`),
  KEY `mapDenormalize_IX_groupRegion` (`groupID`,`regionID`),
  KEY `mapDenormalize_IX_groupSystem` (`groupID`,`solarSystemID`),
  KEY `mapDenormalize_IX_orbit` (`orbitID`),
  KEY `mapDenormalize_IX_region` (`regionID`),
  KEY `mapDenormalize_IX_system` (`solarSystemID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapJumps`
--

DROP TABLE IF EXISTS `mapJumps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapJumps` (
  `stargateID` int(11) NOT NULL,
  `celestialID` int(11) default NULL,
  PRIMARY KEY  (`stargateID`),
  KEY `celestialID` (`celestialID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapLandmarks`
--

DROP TABLE IF EXISTS `mapLandmarks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapLandmarks` (
  `landmarkID` smallint(6) NOT NULL,
  `landmarkName` varchar(100) default NULL,
  `description` varchar(7000) default NULL,
  `locationID` int(11) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `radius` double default NULL,
  `iconID` smallint(6) default NULL,
  `importance` tinyint(4) default NULL,
  PRIMARY KEY  (`landmarkID`),
  KEY `locationID` (`locationID`),
  KEY `iconID` (`iconID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapLocationScenes`
--

DROP TABLE IF EXISTS `mapLocationScenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapLocationScenes` (
  `locationID` int(11) NOT NULL,
  `sceneID` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapLocationWormholeClasses`
--

DROP TABLE IF EXISTS `mapLocationWormholeClasses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapLocationWormholeClasses` (
  `locationID` int(11) NOT NULL,
  `wormholeClassID` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapRegionJumps`
--

DROP TABLE IF EXISTS `mapRegionJumps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapRegionJumps` (
  `fromRegionID` int(11) NOT NULL,
  `toRegionID` int(11) NOT NULL,
  PRIMARY KEY  (`fromRegionID`,`toRegionID`),
  KEY `toRegionID` (`toRegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapRegions`
--

DROP TABLE IF EXISTS `mapRegions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapRegions` (
  `regionID` int(11) NOT NULL,
  `regionName` varchar(100) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `xMin` double default NULL,
  `xMax` double default NULL,
  `yMin` double default NULL,
  `yMax` double default NULL,
  `zMin` double default NULL,
  `zMax` double default NULL,
  `factionID` int(11) default NULL,
  `radius` double default NULL,
  PRIMARY KEY  (`regionID`),
  KEY `factionID` (`factionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapSolarSystemJumps`
--

DROP TABLE IF EXISTS `mapSolarSystemJumps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapSolarSystemJumps` (
  `fromRegionID` int(11) default NULL,
  `fromConstellationID` int(11) default NULL,
  `fromSolarSystemID` int(11) NOT NULL,
  `toSolarSystemID` int(11) NOT NULL,
  `toConstellationID` int(11) default NULL,
  `toRegionID` int(11) default NULL,
  PRIMARY KEY  (`fromSolarSystemID`,`toSolarSystemID`),
  KEY `mapSolarSystemJumps_IX_fromConstellation` (`fromConstellationID`),
  KEY `mapSolarSystemJumps_IX_fromRegion` (`fromRegionID`),
  KEY `fromSolarSystemID` (`fromSolarSystemID`,`fromConstellationID`,`fromRegionID`),
  KEY `toSolarSystemID` (`toSolarSystemID`,`toConstellationID`,`toRegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapSolarSystems`
--

DROP TABLE IF EXISTS `mapSolarSystems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapSolarSystems` (
  `regionID` int(11) default NULL,
  `constellationID` int(11) default NULL,
  `solarSystemID` int(11) NOT NULL,
  `solarSystemName` varchar(100) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `xMin` double default NULL,
  `xMax` double default NULL,
  `yMin` double default NULL,
  `yMax` double default NULL,
  `zMin` double default NULL,
  `zMax` double default NULL,
  `luminosity` double default NULL,
  `border` tinyint(1) default NULL,
  `fringe` tinyint(1) default NULL,
  `corridor` tinyint(1) default NULL,
  `hub` tinyint(1) default NULL,
  `international` tinyint(1) default NULL,
  `regional` tinyint(1) default NULL,
  `constellation` tinyint(1) default NULL,
  `security` double default NULL,
  `factionID` int(11) default NULL,
  `radius` double default NULL,
  `sunTypeID` int(11) default NULL,
  `securityClass` varchar(2) default NULL,
  PRIMARY KEY  (`solarSystemID`),
  UNIQUE KEY `solarSystemID` (`solarSystemID`,`constellationID`,`regionID`),
  KEY `mapSolarSystems_IX_constellation` (`constellationID`),
  KEY `mapSolarSystems_IX_region` (`regionID`),
  KEY `mapSolarSystems_IX_security` (`security`),
  KEY `factionID` (`factionID`),
  KEY `sunTypeID` (`sunTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mapUniverse`
--

DROP TABLE IF EXISTS `mapUniverse`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mapUniverse` (
  `universeID` int(11) NOT NULL,
  `universeName` varchar(100) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `xMin` double default NULL,
  `xMax` double default NULL,
  `yMin` double default NULL,
  `yMax` double default NULL,
  `zMin` double default NULL,
  `zMax` double default NULL,
  `radius` double default NULL,
  PRIMARY KEY  (`universeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `planetSchematics`
--

DROP TABLE IF EXISTS `planetSchematics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `planetSchematics` (
  `schematicID` smallint(6) NOT NULL,
  `schematicName` varchar(255) default NULL,
  `cycleTime` int(11) default NULL,
  PRIMARY KEY  (`schematicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `planetSchematicsPinMap`
--

DROP TABLE IF EXISTS `planetSchematicsPinMap`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `planetSchematicsPinMap` (
  `schematicID` smallint(6) NOT NULL,
  `pinTypeID` int(11) NOT NULL,
  PRIMARY KEY  (`schematicID`,`pinTypeID`),
  KEY `pinTypeID` (`pinTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `planetSchematicsTypeMap`
--

DROP TABLE IF EXISTS `planetSchematicsTypeMap`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `planetSchematicsTypeMap` (
  `schematicID` smallint(6) NOT NULL,
  `typeID` int(11) NOT NULL,
  `quantity` smallint(6) default NULL,
  `isInput` tinyint(1) default NULL,
  PRIMARY KEY  (`schematicID`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramActivities`
--

DROP TABLE IF EXISTS `ramActivities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramActivities` (
  `activityID` tinyint(3) unsigned NOT NULL,
  `activityName` varchar(100) default NULL,
  `iconNo` varchar(5) default NULL,
  `description` varchar(1000) default NULL,
  `published` tinyint(1) default NULL,
  PRIMARY KEY  (`activityID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramAssemblyLineStations`
--

DROP TABLE IF EXISTS `ramAssemblyLineStations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramAssemblyLineStations` (
  `stationID` int(11) NOT NULL,
  `assemblyLineTypeID` tinyint(3) unsigned NOT NULL,
  `quantity` tinyint(4) default NULL,
  `stationTypeID` int(11) default NULL,
  `ownerID` int(11) default NULL,
  `solarSystemID` int(11) default NULL,
  `regionID` int(11) default NULL,
  PRIMARY KEY  (`stationID`,`assemblyLineTypeID`),
  KEY `ramAssemblyLineStations_IX_owner` (`ownerID`),
  KEY `ramAssemblyLineStations_IX_region` (`regionID`),
  KEY `assemblyLineTypeID` (`assemblyLineTypeID`),
  KEY `stationTypeID` (`stationTypeID`),
  KEY `solarSystemID` (`solarSystemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramAssemblyLineTypeDetailPerCategory`
--

DROP TABLE IF EXISTS `ramAssemblyLineTypeDetailPerCategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramAssemblyLineTypeDetailPerCategory` (
  `assemblyLineTypeID` tinyint(3) unsigned NOT NULL,
  `categoryID` tinyint(3) unsigned NOT NULL,
  `timeMultiplier` double default NULL,
  `materialMultiplier` double default NULL,
  PRIMARY KEY  (`assemblyLineTypeID`,`categoryID`),
  KEY `categoryID` (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramAssemblyLineTypeDetailPerGroup`
--

DROP TABLE IF EXISTS `ramAssemblyLineTypeDetailPerGroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramAssemblyLineTypeDetailPerGroup` (
  `assemblyLineTypeID` tinyint(3) unsigned NOT NULL,
  `groupID` smallint(6) NOT NULL,
  `timeMultiplier` double default NULL,
  `materialMultiplier` double default NULL,
  PRIMARY KEY  (`assemblyLineTypeID`,`groupID`),
  KEY `groupID` (`groupID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramAssemblyLineTypes`
--

DROP TABLE IF EXISTS `ramAssemblyLineTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramAssemblyLineTypes` (
  `assemblyLineTypeID` tinyint(3) unsigned NOT NULL,
  `assemblyLineTypeName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `baseTimeMultiplier` double default NULL,
  `baseMaterialMultiplier` double default NULL,
  `volume` double default NULL,
  `activityID` tinyint(3) unsigned default NULL,
  `minCostPerHour` double default NULL,
  PRIMARY KEY  (`assemblyLineTypeID`),
  KEY `activityID` (`activityID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramAssemblyLines`
--

DROP TABLE IF EXISTS `ramAssemblyLines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramAssemblyLines` (
  `assemblyLineID` int(11) NOT NULL,
  `assemblyLineTypeID` tinyint(3) unsigned default NULL,
  `containerID` int(11) default NULL,
  `nextFreeTime` datetime default NULL,
  `UIGroupingID` tinyint(3) unsigned default NULL,
  `costInstall` double default NULL,
  `costPerHour` double default NULL,
  `restrictionMask` tinyint(4) default NULL,
  `discountPerGoodStandingPoint` double default NULL,
  `surchargePerBadStandingPoint` double default NULL,
  `minimumStanding` double default NULL,
  `minimumCharSecurity` double default NULL,
  `minimumCorpSecurity` double default NULL,
  `maximumCharSecurity` double default NULL,
  `maximumCorpSecurity` double default NULL,
  `ownerID` int(11) default NULL,
  `activityID` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`assemblyLineID`),
  KEY `ramAssemblyLines_IX_container` (`containerID`),
  KEY `ramAssemblyLines_IX_owner` (`ownerID`),
  KEY `assemblyLineTypeID` (`assemblyLineTypeID`),
  KEY `activityID` (`activityID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramInstallationTypeContents`
--

DROP TABLE IF EXISTS `ramInstallationTypeContents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramInstallationTypeContents` (
  `installationTypeID` int(11) NOT NULL,
  `assemblyLineTypeID` tinyint(3) unsigned NOT NULL,
  `quantity` tinyint(4) default NULL,
  PRIMARY KEY  (`installationTypeID`,`assemblyLineTypeID`),
  KEY `assemblyLineTypeID` (`assemblyLineTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ramTypeRequirements`
--

DROP TABLE IF EXISTS `ramTypeRequirements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ramTypeRequirements` (
  `typeID` int(11) NOT NULL,
  `activityID` tinyint(3) unsigned NOT NULL,
  `requiredTypeID` int(11) NOT NULL,
  `quantity` int(11) default NULL,
  `damagePerJob` double default NULL,
  `recycle` tinyint(1) default NULL,
  PRIMARY KEY  (`typeID`,`activityID`,`requiredTypeID`),
  KEY `requiredTypeID` (`requiredTypeID`),
  KEY `activityID` (`activityID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `staOperationServices`
--

DROP TABLE IF EXISTS `staOperationServices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staOperationServices` (
  `operationID` tinyint(3) unsigned NOT NULL,
  `serviceID` int(11) NOT NULL,
  PRIMARY KEY  (`operationID`,`serviceID`),
  KEY `serviceID` (`serviceID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `staOperations`
--

DROP TABLE IF EXISTS `staOperations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staOperations` (
  `activityID` tinyint(3) unsigned default NULL,
  `operationID` tinyint(3) unsigned NOT NULL,
  `operationName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `fringe` tinyint(4) default NULL,
  `corridor` tinyint(4) default NULL,
  `hub` tinyint(4) default NULL,
  `border` tinyint(4) default NULL,
  `ratio` tinyint(4) default NULL,
  `caldariStationTypeID` int(11) default NULL,
  `minmatarStationTypeID` int(11) default NULL,
  `amarrStationTypeID` int(11) default NULL,
  `gallenteStationTypeID` int(11) default NULL,
  `joveStationTypeID` int(11) default NULL,
  PRIMARY KEY  (`operationID`),
  KEY `activityID` (`activityID`),
  KEY `caldariStationTypeID` (`caldariStationTypeID`),
  KEY `minmatarStationTypeID` (`minmatarStationTypeID`),
  KEY `amarrStationTypeID` (`amarrStationTypeID`),
  KEY `gallenteStationTypeID` (`gallenteStationTypeID`),
  KEY `joveStationTypeID` (`joveStationTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `staServices`
--

DROP TABLE IF EXISTS `staServices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staServices` (
  `serviceID` int(11) NOT NULL,
  `serviceName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  PRIMARY KEY  (`serviceID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `staStationTypes`
--

DROP TABLE IF EXISTS `staStationTypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staStationTypes` (
  `stationTypeID` int(11) NOT NULL,
  `dockEntryX` double default NULL,
  `dockEntryY` double default NULL,
  `dockEntryZ` double default NULL,
  `dockOrientationX` double default NULL,
  `dockOrientationY` double default NULL,
  `dockOrientationZ` double default NULL,
  `operationID` tinyint(3) unsigned default NULL,
  `officeSlots` tinyint(4) default NULL,
  `reprocessingEfficiency` double default NULL,
  `conquerable` tinyint(1) default NULL,
  PRIMARY KEY  (`stationTypeID`),
  KEY `operationID` (`operationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `staStations`
--

DROP TABLE IF EXISTS `staStations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staStations` (
  `stationID` int(11) NOT NULL,
  `security` smallint(6) default NULL,
  `dockingCostPerVolume` double default NULL,
  `maxShipVolumeDockable` double default NULL,
  `officeRentalCost` int(11) default NULL,
  `operationID` tinyint(3) unsigned default NULL,
  `stationTypeID` int(11) default NULL,
  `corporationID` int(11) default NULL,
  `solarSystemID` int(11) default NULL,
  `constellationID` int(11) default NULL,
  `regionID` int(11) default NULL,
  `stationName` varchar(100) default NULL,
  `x` double default NULL,
  `y` double default NULL,
  `z` double default NULL,
  `reprocessingEfficiency` double default NULL,
  `reprocessingStationsTake` double default NULL,
  `reprocessingHangarFlag` tinyint(4) default NULL,
  PRIMARY KEY  (`stationID`),
  KEY `staStations_IX_constellation` (`constellationID`),
  KEY `staStations_IX_corporation` (`corporationID`),
  KEY `staStations_IX_operation` (`operationID`),
  KEY `staStations_IX_region` (`regionID`),
  KEY `staStations_IX_system` (`solarSystemID`),
  KEY `staStations_IX_type` (`stationTypeID`),
  KEY `solarSystemID` (`solarSystemID`,`constellationID`,`regionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `trnTranslationColumns`
--

DROP TABLE IF EXISTS `trnTranslationColumns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trnTranslationColumns` (
  `tcGroupID` smallint(6) default NULL,
  `tcID` smallint(6) NOT NULL,
  `tableName` varchar(256) NOT NULL,
  `columnName` varchar(128) NOT NULL,
  `masterID` varchar(128) default NULL,
  PRIMARY KEY  (`tcID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `trnTranslations`
--

DROP TABLE IF EXISTS `trnTranslations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trnTranslations` (
  `tcID` smallint(6) NOT NULL,
  `keyID` int(11) NOT NULL,
  `languageID` char(2) NOT NULL,
  `text` varchar(16000) NOT NULL,
  PRIMARY KEY  (`tcID`,`keyID`,`languageID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2010-12-09 23:18:14