gistfile1.sql

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` tinyint(3) unsigned 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;

CREATE TABLE `agtAgentTypes` (
  `agentTypeID` tinyint(3) unsigned NOT NULL,
  `agentType` varchar(50) default NULL,
  PRIMARY KEY  (`agentTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

CREATE TABLE `agtResearchAgents` (
  `agentID` int(11) NOT NULL,
  `typeID` smallint(6) NOT NULL,
  PRIMARY KEY  (`agentID`,`typeID`),
  KEY `agtResearchAgents_IX_type` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=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,
  `graphicID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  PRIMARY KEY  (`ancestryID`),
  KEY `bloodlineID` (`bloodlineID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `chrAttributes` (
  `attributeID` tinyint(3) unsigned NOT NULL,
  `attributeName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `graphicID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  `notes` varchar(500) default NULL,
  PRIMARY KEY  (`attributeID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=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` smallint(6) 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,
  `graphicID` 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 `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=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,
  PRIMARY KEY  (`factionID`),
  KEY `solarSystemID` (`solarSystemID`),
  KEY `corporationID` (`corporationID`),
  KEY `militiaCorporationID` (`militiaCorporationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `chrRaces` (
  `raceID` tinyint(3) unsigned NOT NULL,
  `raceName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `graphicID` smallint(6) default NULL,
  `shortDescription` varchar(500) default NULL,
  PRIMARY KEY  (`raceID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

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;

CREATE TABLE `crpNPCCorporationResearchFields` (
  `skillID` smallint(6) NOT NULL,
  `corporationID` int(11) NOT NULL,
  PRIMARY KEY  (`skillID`,`corporationID`),
  KEY `corporationID` (`corporationID`)
) ENGINE=MyISAM DEFAULT CHARSET=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,
  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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `crpNPCCorporationTrades` (
  `corporationID` int(11) NOT NULL,
  `typeID` smallint(6) NOT NULL,
  PRIMARY KEY  (`corporationID`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

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;

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` int(11) default NULL,
  `description` varchar(500) default NULL,
  PRIMARY KEY  (`certificateID`),
  KEY `crtCertificates_IX_category` (`categoryID`),
  KEY `crtCertificates_IX_class` (`classID`),
  KEY `corpID` (`corpID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

CREATE TABLE `crtRecommendations` (
  `recommendationID` int(11) NOT NULL,
  `shipTypeID` smallint(6) 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;

CREATE TABLE `crtRelationships` (
  `relationshipID` int(11) NOT NULL,
  `parentID` int(11) default NULL,
  `parentTypeID` smallint(6) 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;

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;

CREATE TABLE `dgmAttributeTypes` (
  `attributeID` smallint(6) NOT NULL,
  `attributeName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `graphicID` 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 `graphicID` (`graphicID`),
  KEY `unitID` (`unitID`)
) ENGINE=MyISAM DEFAULT CHARSET=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,
  `graphicID` 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 `graphicID` (`graphicID`),
  KEY `durationAttributeID` (`durationAttributeID`),
  KEY `trackingSpeedAttributeID` (`trackingSpeedAttributeID`),
  KEY `dischargeAttributeID` (`dischargeAttributeID`),
  KEY `rangeAttributeID` (`rangeAttributeID`),
  KEY `falloffAttributeID` (`falloffAttributeID`),
  KEY `npcUsageChanceAttributeID` (`npcUsageChanceAttributeID`),
  KEY `npcActivationChanceAttributeID` (`npcActivationChanceAttributeID`),
  KEY `fittingUsageChanceAttributeID` (`fittingUsageChanceAttributeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `dgmTypeAttributes` (
  `typeID` smallint(6) 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;

CREATE TABLE `dgmTypeEffects` (
  `typeID` smallint(6) NOT NULL,
  `effectID` smallint(6) NOT NULL,
  `isDefault` tinyint(1) default NULL,
  PRIMARY KEY  (`typeID`,`effectID`),
  KEY `effectID` (`effectID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `eveGraphics` (
  `graphicID` smallint(6) NOT NULL,
  `url3D` varchar(100) default NULL,
  `urlWeb` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `published` tinyint(1) default NULL,
  `obsolete` tinyint(1) default NULL,
  `icon` varchar(100) default NULL,
  `urlSound` varchar(100) default NULL,
  `explosionID` smallint(6) default NULL,
  PRIMARY KEY  (`graphicID`),
  KEY `explosionID` (`explosionID`)
) ENGINE=MyISAM DEFAULT CHARSET=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` smallint(6) default NULL,
  PRIMARY KEY  (`itemID`),
  KEY `categoryID` (`categoryID`),
  KEY `groupID` (`groupID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

CREATE TABLE `invBlueprintTypes` (
  `blueprintTypeID` smallint(6) NOT NULL,
  `parentBlueprintTypeID` smallint(6) default NULL,
  `productTypeID` smallint(6) 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;

CREATE TABLE `invCategories` (
  `categoryID` tinyint(3) unsigned NOT NULL,
  `categoryName` varchar(100) default NULL,
  `description` varchar(3000) default NULL,
  `graphicID` smallint(6) default NULL,
  `published` tinyint(1) default NULL,
  PRIMARY KEY  (`categoryID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invContrabandTypes` (
  `factionID` int(11) NOT NULL,
  `typeID` smallint(6) 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;

CREATE TABLE `invControlTowerResourcePurposes` (
  `purpose` tinyint(4) NOT NULL,
  `purposeText` varchar(100) default NULL,
  PRIMARY KEY  (`purpose`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invControlTowerResources` (
  `controlTowerTypeID` smallint(6) NOT NULL,
  `resourceTypeID` smallint(6) 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;

CREATE TABLE `invFlags` (
  `flagID` tinyint(3) unsigned NOT NULL,
  `flagName` varchar(100) default NULL,
  `flagText` varchar(100) default NULL,
  `flagType` varchar(20) default NULL,
  `orderID` smallint(6) default NULL,
  PRIMARY KEY  (`flagID`)
) ENGINE=MyISAM DEFAULT CHARSET=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,
  `graphicID` 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 `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invMarketGroups` (
  `marketGroupID` smallint(6) NOT NULL,
  `parentGroupID` smallint(6) default NULL,
  `marketGroupName` varchar(100) default NULL,
  `description` varchar(3000) default NULL,
  `graphicID` smallint(6) default NULL,
  `hasTypes` tinyint(1) default NULL,
  PRIMARY KEY  (`marketGroupID`),
  KEY `parentGroupID` (`parentGroupID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invMetaGroups` (
  `metaGroupID` smallint(6) NOT NULL,
  `metaGroupName` varchar(100) default NULL,
  `description` varchar(1000) default NULL,
  `graphicID` smallint(6) default NULL,
  PRIMARY KEY  (`metaGroupID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invMetaTypes` (
  `typeID` smallint(6) NOT NULL,
  `parentTypeID` smallint(6) default NULL,
  `metaGroupID` smallint(6) default NULL,
  PRIMARY KEY  (`typeID`),
  KEY `parentTypeID` (`parentTypeID`),
  KEY `metaGroupID` (`metaGroupID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invTypeMaterials` (
  `typeID` smallint(6) NOT NULL,
  `materialTypeID` smallint(6) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY  (`typeID`,`materialTypeID`),
  KEY `materialTypeID` (`materialTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invTypeReactions` (
  `reactionTypeID` smallint(6) NOT NULL,
  `input` tinyint(1) NOT NULL,
  `typeID` smallint(6) NOT NULL,
  `quantity` smallint(6) default NULL,
  PRIMARY KEY  (`reactionTypeID`,`input`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `invTypes` (
  `typeID` smallint(6) 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,
  PRIMARY KEY  (`typeID`),
  KEY `invTypes_IX_Group` (`groupID`),
  KEY `graphicID` (`graphicID`),
  KEY `raceID` (`raceID`),
  KEY `marketGroupID` (`marketGroupID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

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;

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;

CREATE TABLE `mapDenormalize` (
  `itemID` int(11) NOT NULL,
  `typeID` smallint(6) 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;

CREATE TABLE `mapJumps` (
  `stargateID` int(11) NOT NULL,
  `celestialID` int(11) default NULL,
  PRIMARY KEY  (`stargateID`),
  KEY `celestialID` (`celestialID`)
) ENGINE=MyISAM DEFAULT CHARSET=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,
  `graphicID` smallint(6) default NULL,
  `importance` tinyint(4) default NULL,
  `url2d` varchar(255) default NULL,
  PRIMARY KEY  (`landmarkID`),
  KEY `locationID` (`locationID`),
  KEY `graphicID` (`graphicID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `mapLocationScenes` (
  `locationID` int(11) NOT NULL,
  `sceneID` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `mapLocationWormholeClasses` (
  `locationID` int(11) NOT NULL,
  `wormholeClassID` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`locationID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

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;

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;

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` smallint(6) 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;

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;

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;

CREATE TABLE `planetSchematicsPinMap` (
  `schematicID` smallint(6) NOT NULL,
  `pinTypeID` smallint(6) NOT NULL,
  PRIMARY KEY  (`schematicID`,`pinTypeID`),
  KEY `pinTypeID` (`pinTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `planetSchematicsTypeMap` (
  `schematicID` smallint(6) NOT NULL,
  `typeID` smallint(6) NOT NULL,
  `quantity` smallint(6) default NULL,
  `isInput` tinyint(1) default NULL,
  PRIMARY KEY  (`schematicID`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

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;

CREATE TABLE `ramAssemblyLineStations` (
  `stationID` int(11) NOT NULL,
  `assemblyLineTypeID` tinyint(3) unsigned NOT NULL,
  `quantity` tinyint(4) default NULL,
  `stationTypeID` smallint(6) 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;

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;

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;

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;

CREATE TABLE `ramInstallationTypeContents` (
  `installationTypeID` smallint(6) 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;

CREATE TABLE `ramTypeRequirements` (
  `typeID` smallint(6) NOT NULL,
  `activityID` tinyint(3) unsigned NOT NULL,
  `requiredTypeID` smallint(6) 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;

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` smallint(6) default NULL,
  `minmatarStationTypeID` smallint(6) default NULL,
  `amarrStationTypeID` smallint(6) default NULL,
  `gallenteStationTypeID` smallint(6) default NULL,
  `joveStationTypeID` smallint(6) 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;

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;

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;

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` smallint(6) 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;

CREATE TABLE `staStationTypes` (
  `stationTypeID` smallint(6) NOT NULL,
  `dockingBayGraphicID` smallint(6) default NULL,
  `hangarGraphicID` smallint(6) default 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 `dockingBayGraphicID` (`dockingBayGraphicID`),
  KEY `hangarGraphicID` (`hangarGraphicID`),
  KEY `operationID` (`operationID`)
) ENGINE=MyISAM DEFAULT CHARSET=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;

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;