CREATE TABLE "agtAgentTypes" (
  "agentTypeID" tinyint(3) NOT NULL,
  "agentType" varchar(50) default NULL,
  PRIMARY KEY  ("agentTypeID")
);
CREATE TABLE "agtAgents" (
  "agentID" int(11) NOT NULL,
  "divisionID" tinyint(3) default NULL,
  "corporationID" int(11) default NULL,
  "stationID" int(11) default NULL,
  "level" tinyint(4) default NULL,
  "quality" smallint(6) default NULL,
  "agentTypeID" tinyint(3) default NULL,
  PRIMARY KEY  ("agentID")
);
CREATE TABLE "agtConfig" (
  "agentID" int(11) NOT NULL,
  "k" varchar(50) NOT NULL,
  "v" varchar(4000) default NULL,
  PRIMARY KEY  ("agentID","k")
);
CREATE TABLE "agtResearchAgents" (
  "agentID" int(11) NOT NULL,
  "typeID" smallint(6) NOT NULL,
  PRIMARY KEY  ("agentID","typeID")
);
CREATE TABLE "chrAncestries" (
  "ancestryID" tinyint(3) NOT NULL,
  "ancestryName" varchar(100) default NULL,
  "bloodlineID" tinyint(3) 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")
);
CREATE TABLE "chrAttributes" (
  "attributeID" tinyint(3) 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")
);
CREATE TABLE "chrBloodlines" (
  "bloodlineID" tinyint(3) NOT NULL,
  "bloodlineName" varchar(100) default NULL,
  "raceID" tinyint(3) 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")
);
CREATE TABLE "chrCareerSpecialities" (
  "specialityID" tinyint(3) NOT NULL,
  "careerID" tinyint(3) default NULL,
  "specialityName" varchar(100) default NULL,
  "description" varchar(2000) default NULL,
  "shortDescription" varchar(500) default NULL,
  "graphicID" smallint(6) default NULL,
  PRIMARY KEY  ("specialityID")
);
CREATE TABLE "chrCareers" (
  "raceID" tinyint(3) default NULL,
  "careerID" tinyint(3) NOT NULL,
  "careerName" varchar(100) default NULL,
  "description" varchar(2000) default NULL,
  "shortDescription" varchar(500) default NULL,
  "graphicID" smallint(6) default NULL,
  "schoolID" tinyint(3) default NULL,
  PRIMARY KEY  ("careerID")
);
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")
);
CREATE TABLE "chrRaceSkills" (
  "raceID" tinyint(3) NOT NULL,
  "skillTypeID" smallint(6) NOT NULL,
  "levels" tinyint(4) default NULL,
  PRIMARY KEY  ("raceID","skillTypeID")
);
CREATE TABLE "chrRaces" (
  "raceID" tinyint(3) 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")
);
CREATE TABLE "chrSchoolAgents" (
  "schoolID" tinyint(3) NOT NULL,
  "agentIndex" tinyint(4) NOT NULL,
  "agentID" int(11) default NULL,
  PRIMARY KEY  ("schoolID","agentIndex")
);
CREATE TABLE "chrSchools" (
  "raceID" tinyint(3) default NULL,
  "schoolID" tinyint(3) NOT NULL,
  "schoolName" varchar(100) default NULL,
  "description" varchar(1000) default NULL,
  "graphicID" smallint(6) default NULL,
  "corporationID" int(11) default NULL,
  "newAgentID" int(11) default NULL,
  "careerID" tinyint(3) default NULL,
  PRIMARY KEY  ("schoolID")
);
CREATE TABLE "crpActivities" (
  "activityID" tinyint(3) NOT NULL,
  "activityName" varchar(100) default NULL,
  "description" varchar(1000) default NULL,
  PRIMARY KEY  ("activityID")
);
CREATE TABLE "crpNPCCorporationDivisions" (
  "corporationID" int(11) NOT NULL,
  "divisionID" tinyint(3) NOT NULL,
  "size" tinyint(4) default NULL,
  PRIMARY KEY  ("corporationID","divisionID")
);
CREATE TABLE "crpNPCCorporationResearchFields" (
  "skillID" smallint(6) NOT NULL,
  "corporationID" int(11) NOT NULL,
  PRIMARY KEY  ("skillID","corporationID")
);
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")
);
CREATE TABLE "crpNPCDivisions" (
  "divisionID" tinyint(3) NOT NULL,
  "divisionName" varchar(100) default NULL,
  "description" varchar(1000) default NULL,
  "leaderType" varchar(100) default NULL,
  PRIMARY KEY  ("divisionID")
);
CREATE TABLE "crtCategories" (
  "categoryID" tinyint(3) NOT NULL,
  "description" varchar(500) default NULL,
  "categoryName" varchar(256) default NULL,
  PRIMARY KEY  ("categoryID")
);
CREATE TABLE "crtCertificates" (
  "certificateID" int(11) NOT NULL,
  "categoryID" tinyint(3) 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")
);
CREATE TABLE "crtClasses" (
  "classID" int(11) NOT NULL,
  "description" varchar(500) default NULL,
  "className" varchar(256) default NULL,
  PRIMARY KEY  ("classID")
);
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")
);
CREATE TABLE "dgmAttributeCategories" (
  "categoryID" tinyint(3) NOT NULL,
  "categoryName" varchar(50) default NULL,
  "categoryDescription" varchar(200) default NULL,
  PRIMARY KEY  ("categoryID")
);
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) default NULL,
  "stackable" tinyint(1) default NULL,
  "highIsGood" tinyint(1) default NULL,
  "categoryID" tinyint(3) default NULL,
  PRIMARY KEY  ("attributeID")
);
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")
);
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")
);
CREATE TABLE "dgmTypeEffects" (
  "typeID" smallint(6) NOT NULL,
  "effectID" smallint(6) NOT NULL,
  "isDefault" tinyint(1) default NULL,
  PRIMARY KEY  ("typeID","effectID")
);
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")
);
CREATE TABLE "eveNames" (
  "itemID" int(11) NOT NULL,
  "itemName" varchar(100) default NULL,
  "categoryID" tinyint(3) default NULL,
  "groupID" smallint(6) default NULL,
  "typeID" smallint(6) default NULL,
  PRIMARY KEY  ("itemID")
);
CREATE TABLE "eveUnits" (
  "unitID" tinyint(3) NOT NULL,
  "unitName" varchar(100) default NULL,
  "displayName" varchar(20) default NULL,
  "description" varchar(1000) default NULL,
  PRIMARY KEY  ("unitID")
);
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")
);
CREATE TABLE "invCategories" (
  "categoryID" tinyint(3) 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")
);
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")
);
CREATE TABLE "invControlTowerResourcePurposes" (
  "purpose" tinyint(4) NOT NULL,
  "purposeText" varchar(100) default NULL,
  PRIMARY KEY  ("purpose")
);
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")
);
CREATE TABLE "invFlags" (
  "flagID" tinyint(3) 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")
);
CREATE TABLE "invGroups" (
  "groupID" smallint(6) NOT NULL,
  "categoryID" tinyint(3) 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")
);
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")
);
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")
);
CREATE TABLE "invMetaTypes" (
  "typeID" smallint(6) NOT NULL,
  "parentTypeID" smallint(6) default NULL,
  "metaGroupID" smallint(6) default NULL,
  PRIMARY KEY  ("typeID")
);
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")
);
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) default NULL,
  "basePrice" double default NULL,
  "published" tinyint(1) default NULL,
  "marketGroupID" smallint(6) default NULL,
  "chanceOfDuplicating" double default NULL,
  PRIMARY KEY  ("typeID")
);
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")
);
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")
);
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")
);
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")
);
CREATE TABLE "mapJumps" (
  "stargateID" int(11) NOT NULL,
  "celestialID" int(11) default NULL,
  PRIMARY KEY  ("stargateID")
);
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")
);
CREATE TABLE "mapRegionJumps" (
  "fromRegionID" int(11) NOT NULL,
  "toRegionID" int(11) NOT NULL,
  PRIMARY KEY  ("fromRegionID","toRegionID")
);
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")
);
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")
);
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")
);
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")
);
CREATE TABLE "ramActivities" (
  "activityID" tinyint(3) 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")
);
CREATE TABLE "ramAssemblyLineStations" (
  "stationID" int(11) NOT NULL,
  "assemblyLineTypeID" tinyint(3) 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")
);
CREATE TABLE "ramAssemblyLineTypeDetailPerCategory" (
  "assemblyLineTypeID" tinyint(3) NOT NULL,
  "categoryID" tinyint(3) NOT NULL,
  "timeMultiplier" double default NULL,
  "materialMultiplier" double default NULL,
  PRIMARY KEY  ("assemblyLineTypeID","categoryID")
);
CREATE TABLE "ramAssemblyLineTypeDetailPerGroup" (
  "assemblyLineTypeID" tinyint(3) NOT NULL,
  "groupID" smallint(6) NOT NULL,
  "timeMultiplier" double default NULL,
  "materialMultiplier" double default NULL,
  PRIMARY KEY  ("assemblyLineTypeID","groupID")
);
CREATE TABLE "ramAssemblyLineTypes" (
  "assemblyLineTypeID" tinyint(3) 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) default NULL,
  "minCostPerHour" double default NULL,
  PRIMARY KEY  ("assemblyLineTypeID")
);
CREATE TABLE "ramAssemblyLines" (
  "assemblyLineID" int(11) NOT NULL,
  "assemblyLineTypeID" tinyint(3) default NULL,
  "containerID" int(11) default NULL,
  "nextFreeTime" datetime default NULL,
  "UIGroupingID" tinyint(3) 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) default NULL,
  PRIMARY KEY  ("assemblyLineID")
);
CREATE TABLE "staOperationServices" (
  "operationID" tinyint(3) NOT NULL,
  "serviceID" int(11) NOT NULL,
  PRIMARY KEY  ("operationID","serviceID")
);
CREATE TABLE "staOperations" (
  "activityID" tinyint(3) default NULL,
  "operationID" tinyint(3) 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")
);
CREATE TABLE "staServices" (
  "serviceID" int(11) NOT NULL,
  "serviceName" varchar(100) default NULL,
  "description" varchar(1000) default NULL,
  PRIMARY KEY  ("serviceID")
);
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) default NULL,
  "officeSlots" tinyint(4) default NULL,
  "reprocessingEfficiency" double default NULL,
  "conquerable" tinyint(1) default NULL,
  PRIMARY KEY  ("stationTypeID")
);
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) 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")
);
CREATE TABLE "typeActivityMaterials" (
  "typeID" smallint(6) NOT NULL,
  "activityID" tinyint(3) 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")
);
CREATE INDEX "agtAgents_IX_agentTypeID" ON "agtAgents" ("agentTypeID");
CREATE INDEX "agtAgents_IX_corporation" ON "agtAgents" ("corporationID");
CREATE INDEX "agtAgents_IX_divisionID" ON "agtAgents" ("divisionID");
CREATE INDEX "agtAgents_IX_station" ON "agtAgents" ("stationID");
CREATE INDEX "agtResearchAgents_IX_type" ON "agtResearchAgents" ("typeID");
CREATE INDEX "chrAncestries_IX_bloodlineID" ON "chrAncestries" ("bloodlineID");
CREATE INDEX "chrAncestries_IX_graphicID" ON "chrAncestries" ("graphicID");
CREATE INDEX "chrAttributes_IX_graphicID" ON "chrAttributes" ("graphicID");
CREATE INDEX "chrBloodlines_IX_corporationID" ON "chrBloodlines" ("corporationID");
CREATE INDEX "chrBloodlines_IX_graphicID" ON "chrBloodlines" ("graphicID");
CREATE INDEX "chrBloodlines_IX_raceID" ON "chrBloodlines" ("raceID");
CREATE INDEX "chrBloodlines_IX_shipTypeID" ON "chrBloodlines" ("shipTypeID");
CREATE INDEX "chrCareerSpecialities_IX_careerID" ON "chrCareerSpecialities" ("careerID");
CREATE INDEX "chrCareerSpecialities_IX_graphicID" ON "chrCareerSpecialities" ("graphicID");
CREATE INDEX "chrCareers_IX_graphicID" ON "chrCareers" ("graphicID");
CREATE INDEX "chrCareers_IX_raceID" ON "chrCareers" ("raceID");
CREATE INDEX "chrCareers_IX_schoolID" ON "chrCareers" ("schoolID");
CREATE INDEX "chrFactions_IX_corporationID" ON "chrFactions" ("corporationID");
CREATE INDEX "chrFactions_IX_militiaCorporationID" ON "chrFactions" ("militiaCorporationID");
CREATE INDEX "chrFactions_IX_solarSystemID" ON "chrFactions" ("solarSystemID");
CREATE INDEX "chrRaceSkills_IX_skillTypeID" ON "chrRaceSkills" ("skillTypeID");
CREATE INDEX "chrRaces_IX_graphicID" ON "chrRaces" ("graphicID");
CREATE INDEX "chrSchoolAgents_IX_agentID" ON "chrSchoolAgents" ("agentID");
CREATE INDEX "chrSchools_IX_careerID" ON "chrSchools" ("careerID");
CREATE INDEX "chrSchools_IX_corporationID" ON "chrSchools" ("corporationID");
CREATE INDEX "chrSchools_IX_graphicID" ON "chrSchools" ("graphicID");
CREATE INDEX "chrSchools_IX_newAgentID" ON "chrSchools" ("newAgentID");
CREATE INDEX "chrSchools_IX_raceID" ON "chrSchools" ("raceID");
CREATE INDEX "crpNPCCorporationDivisions_IX_divisionID" ON "crpNPCCorporationDivisions" ("divisionID");
CREATE INDEX "crpNPCCorporationResearchFields_IX_corporationID" ON "crpNPCCorporationResearchFields" ("corporationID");
CREATE INDEX "crpNPCCorporations_IX_enemyID" ON "crpNPCCorporations" ("enemyID");
CREATE INDEX "crpNPCCorporations_IX_factionID" ON "crpNPCCorporations" ("factionID");
CREATE INDEX "crpNPCCorporations_IX_friendID" ON "crpNPCCorporations" ("friendID");
CREATE INDEX "crpNPCCorporations_IX_investorID1" ON "crpNPCCorporations" ("investorID1");
CREATE INDEX "crpNPCCorporations_IX_investorID2" ON "crpNPCCorporations" ("investorID2");
CREATE INDEX "crpNPCCorporations_IX_investorID3" ON "crpNPCCorporations" ("investorID3");
CREATE INDEX "crpNPCCorporations_IX_investorID4" ON "crpNPCCorporations" ("investorID4");
CREATE INDEX "crpNPCCorporations_IX_solarSystemID" ON "crpNPCCorporations" ("solarSystemID");
CREATE INDEX "crtCertificates_IX_category" ON "crtCertificates" ("categoryID");
CREATE INDEX "crtCertificates_IX_class" ON "crtCertificates" ("classID");
CREATE INDEX "crtCertificates_IX_corpID" ON "crtCertificates" ("corpID");
CREATE INDEX "crtRelationships_IX_child" ON "crtRelationships" ("childID");
CREATE INDEX "crtRelationships_IX_parent" ON "crtRelationships" ("parentID");
CREATE INDEX "crtRelationships_IX_parentTypeID" ON "crtRelationships" ("parentTypeID");
CREATE INDEX "dgmAttributeTypes_IX_categoryID" ON "dgmAttributeTypes" ("categoryID");
CREATE INDEX "dgmAttributeTypes_IX_graphicID" ON "dgmAttributeTypes" ("graphicID");
CREATE INDEX "dgmAttributeTypes_IX_unitID" ON "dgmAttributeTypes" ("unitID");
CREATE INDEX "dgmEffects_IX_dischargeAttributeID" ON "dgmEffects" ("dischargeAttributeID");
CREATE INDEX "dgmEffects_IX_durationAttributeID" ON "dgmEffects" ("durationAttributeID");
CREATE INDEX "dgmEffects_IX_falloffAttributeID" ON "dgmEffects" ("falloffAttributeID");
CREATE INDEX "dgmEffects_IX_fittingUsageChanceAttributeID" ON "dgmEffects" ("fittingUsageChanceAttributeID");
CREATE INDEX "dgmEffects_IX_graphicID" ON "dgmEffects" ("graphicID");
CREATE INDEX "dgmEffects_IX_npcActivationChanceAttributeID" ON "dgmEffects" ("npcActivationChanceAttributeID");
CREATE INDEX "dgmEffects_IX_npcUsageChanceAttributeID" ON "dgmEffects" ("npcUsageChanceAttributeID");
CREATE INDEX "dgmEffects_IX_rangeAttributeID" ON "dgmEffects" ("rangeAttributeID");
CREATE INDEX "dgmEffects_IX_trackingSpeedAttributeID" ON "dgmEffects" ("trackingSpeedAttributeID");
CREATE INDEX "dgmTypeAttributes_IX_attributeID" ON "dgmTypeAttributes" ("attributeID");
CREATE INDEX "dgmTypeEffects_IX_effectID" ON "dgmTypeEffects" ("effectID");
CREATE INDEX "eveGraphics_IX_explosionID" ON "eveGraphics" ("explosionID");
CREATE INDEX "eveNames_IX_categoryID" ON "eveNames" ("categoryID");
CREATE INDEX "eveNames_IX_groupID" ON "eveNames" ("groupID");
CREATE INDEX "eveNames_IX_typeID" ON "eveNames" ("typeID");
CREATE INDEX "invBlueprintTypes_IX_parentBlueprintTypeID" ON "invBlueprintTypes" ("parentBlueprintTypeID");
CREATE INDEX "invBlueprintTypes_IX_productTypeID" ON "invBlueprintTypes" ("productTypeID");
CREATE INDEX "invCategories_IX_graphicID" ON "invCategories" ("graphicID");
CREATE INDEX "invContrabandTypes_IX_type" ON "invContrabandTypes" ("typeID");
CREATE INDEX "invControlTowerResources_IX_factionID" ON "invControlTowerResources" ("factionID");
CREATE INDEX "invControlTowerResources_IX_purpose" ON "invControlTowerResources" ("purpose");
CREATE INDEX "invControlTowerResources_IX_resourceTypeID" ON "invControlTowerResources" ("resourceTypeID");
CREATE INDEX "invGroups_IX_category" ON "invGroups" ("categoryID");
CREATE INDEX "invGroups_IX_graphicID" ON "invGroups" ("graphicID");
CREATE INDEX "invMarketGroups_IX_graphicID" ON "invMarketGroups" ("graphicID");
CREATE INDEX "invMarketGroups_IX_parentGroupID" ON "invMarketGroups" ("parentGroupID");
CREATE INDEX "invMetaGroups_IX_graphicID" ON "invMetaGroups" ("graphicID");
CREATE INDEX "invMetaTypes_IX_metaGroupID" ON "invMetaTypes" ("metaGroupID");
CREATE INDEX "invMetaTypes_IX_parentTypeID" ON "invMetaTypes" ("parentTypeID");
CREATE INDEX "invTypeReactions_IX_typeID" ON "invTypeReactions" ("typeID");
CREATE INDEX "invTypes_IX_Group" ON "invTypes" ("groupID");
CREATE INDEX "invTypes_IX_graphicID" ON "invTypes" ("graphicID");
CREATE INDEX "invTypes_IX_marketGroupID" ON "invTypes" ("marketGroupID");
CREATE INDEX "invTypes_IX_raceID" ON "invTypes" ("raceID");
CREATE INDEX "mapConstellationJumps_IX_fromConstellationID" ON "mapConstellationJumps" ("fromConstellationID","fromRegionID");
CREATE INDEX "mapConstellationJumps_IX_fromRegion" ON "mapConstellationJumps" ("fromRegionID");
CREATE INDEX "mapConstellationJumps_IX_toConstellationID" ON "mapConstellationJumps" ("toConstellationID","toRegionID");
CREATE INDEX "mapConstellations_IX_constellationID" ON "mapConstellations" ("constellationID","regionID");
CREATE INDEX "mapConstellations_IX_constellationID_2" ON "mapConstellations" ("constellationID","regionID");
CREATE INDEX "mapConstellations_IX_factionID" ON "mapConstellations" ("factionID");
CREATE INDEX "mapConstellations_IX_region" ON "mapConstellations" ("regionID");
CREATE INDEX "mapDenormalize_IX_constellation" ON "mapDenormalize" ("constellationID");
CREATE INDEX "mapDenormalize_IX_groupConstellation" ON "mapDenormalize" ("groupID","constellationID");
CREATE INDEX "mapDenormalize_IX_groupRegion" ON "mapDenormalize" ("groupID","regionID");
CREATE INDEX "mapDenormalize_IX_groupSystem" ON "mapDenormalize" ("groupID","solarSystemID");
CREATE INDEX "mapDenormalize_IX_orbit" ON "mapDenormalize" ("orbitID");
CREATE INDEX "mapDenormalize_IX_region" ON "mapDenormalize" ("regionID");
CREATE INDEX "mapDenormalize_IX_system" ON "mapDenormalize" ("solarSystemID");
CREATE INDEX "mapDenormalize_IX_typeID" ON "mapDenormalize" ("typeID");
CREATE INDEX "mapJumps_IX_celestialID" ON "mapJumps" ("celestialID");
CREATE INDEX "mapLandmarks_IX_graphicID" ON "mapLandmarks" ("graphicID");
CREATE INDEX "mapLandmarks_IX_locationID" ON "mapLandmarks" ("locationID");
CREATE INDEX "mapRegionJumps_IX_toRegionID" ON "mapRegionJumps" ("toRegionID");
CREATE INDEX "mapRegions_IX_factionID" ON "mapRegions" ("factionID");
CREATE INDEX "mapSolarSystemJumps_IX_fromConstellation" ON "mapSolarSystemJumps" ("fromConstellationID");
CREATE INDEX "mapSolarSystemJumps_IX_fromRegion" ON "mapSolarSystemJumps" ("fromRegionID");
CREATE INDEX "mapSolarSystemJumps_IX_fromSolarSystemID" ON "mapSolarSystemJumps" ("fromSolarSystemID","fromConstellationID","fromRegionID");
CREATE INDEX "mapSolarSystemJumps_IX_toSolarSystemID" ON "mapSolarSystemJumps" ("toSolarSystemID","toConstellationID","toRegionID");
CREATE INDEX "mapSolarSystems_IX_constellation" ON "mapSolarSystems" ("constellationID");
CREATE INDEX "mapSolarSystems_IX_factionID" ON "mapSolarSystems" ("factionID");
CREATE INDEX "mapSolarSystems_IX_region" ON "mapSolarSystems" ("regionID");
CREATE INDEX "mapSolarSystems_IX_security" ON "mapSolarSystems" ("security");
CREATE INDEX "mapSolarSystems_IX_solarSystemID" ON "mapSolarSystems" ("solarSystemID","constellationID","regionID");
CREATE INDEX "mapSolarSystems_IX_solarSystemID_2" ON "mapSolarSystems" ("solarSystemID","constellationID","regionID");
CREATE INDEX "mapSolarSystems_IX_sunTypeID" ON "mapSolarSystems" ("sunTypeID");
CREATE INDEX "ramAssemblyLineStations_IX_assemblyLineTypeID" ON "ramAssemblyLineStations" ("assemblyLineTypeID");
CREATE INDEX "ramAssemblyLineStations_IX_owner" ON "ramAssemblyLineStations" ("ownerID");
CREATE INDEX "ramAssemblyLineStations_IX_region" ON "ramAssemblyLineStations" ("regionID");
CREATE INDEX "ramAssemblyLineStations_IX_solarSystemID" ON "ramAssemblyLineStations" ("solarSystemID");
CREATE INDEX "ramAssemblyLineStations_IX_stationTypeID" ON "ramAssemblyLineStations" ("stationTypeID");
CREATE INDEX "ramAssemblyLineTypeDetailPerCategory_IX_categoryID" ON "ramAssemblyLineTypeDetailPerCategory" ("categoryID");
CREATE INDEX "ramAssemblyLineTypeDetailPerGroup_IX_groupID" ON "ramAssemblyLineTypeDetailPerGroup" ("groupID");
CREATE INDEX "ramAssemblyLineTypes_IX_activityID" ON "ramAssemblyLineTypes" ("activityID");
CREATE INDEX "ramAssemblyLines_IX_activityID" ON "ramAssemblyLines" ("activityID");
CREATE INDEX "ramAssemblyLines_IX_assemblyLineTypeID" ON "ramAssemblyLines" ("assemblyLineTypeID");
CREATE INDEX "ramAssemblyLines_IX_container" ON "ramAssemblyLines" ("containerID");
CREATE INDEX "ramAssemblyLines_IX_owner" ON "ramAssemblyLines" ("ownerID");
CREATE INDEX "staOperationServices_IX_serviceID" ON "staOperationServices" ("serviceID");
CREATE INDEX "staOperations_IX_activityID" ON "staOperations" ("activityID");
CREATE INDEX "staOperations_IX_amarrStationTypeID" ON "staOperations" ("amarrStationTypeID");
CREATE INDEX "staOperations_IX_caldariStationTypeID" ON "staOperations" ("caldariStationTypeID");
CREATE INDEX "staOperations_IX_gallenteStationTypeID" ON "staOperations" ("gallenteStationTypeID");
CREATE INDEX "staOperations_IX_joveStationTypeID" ON "staOperations" ("joveStationTypeID");
CREATE INDEX "staOperations_IX_minmatarStationTypeID" ON "staOperations" ("minmatarStationTypeID");
CREATE INDEX "staStationTypes_IX_dockingBayGraphicID" ON "staStationTypes" ("dockingBayGraphicID");
CREATE INDEX "staStationTypes_IX_hangarGraphicID" ON "staStationTypes" ("hangarGraphicID");
CREATE INDEX "staStationTypes_IX_operationID" ON "staStationTypes" ("operationID");
CREATE INDEX "staStations_IX_constellation" ON "staStations" ("constellationID");
CREATE INDEX "staStations_IX_corporation" ON "staStations" ("corporationID");
CREATE INDEX "staStations_IX_operation" ON "staStations" ("operationID");
CREATE INDEX "staStations_IX_region" ON "staStations" ("regionID");
CREATE INDEX "staStations_IX_solarSystemID" ON "staStations" ("solarSystemID","constellationID","regionID");
CREATE INDEX "staStations_IX_system" ON "staStations" ("solarSystemID");
CREATE INDEX "staStations_IX_type" ON "staStations" ("stationTypeID");
CREATE INDEX "typeActivityMaterials_IX_activity" ON "typeActivityMaterials" ("activityID");
CREATE INDEX "typeActivityMaterials_IX_requiredTypeID" ON "typeActivityMaterials" ("requiredTypeID");