CREATE INDEX "agtAgents_IX_agents_IX_corporation" ON "agtAgents" ("corporationID");
CREATE INDEX "agtAgents_IX_agents_IX_station" ON "agtAgents" ("stationID");
CREATE INDEX "agtAgents_IX_divisionID" ON "agtAgents" ("divisionID");
CREATE INDEX "agtAgents_IX_agentTypeID" ON "agtAgents" ("agentTypeID");
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_raceID" ON "chrBloodlines" ("raceID");
CREATE INDEX "chrBloodlines_IX_shipTypeID" ON "chrBloodlines" ("shipTypeID");
CREATE INDEX "chrBloodlines_IX_corporationID" ON "chrBloodlines" ("corporationID");
CREATE INDEX "chrBloodlines_IX_graphicID" ON "chrBloodlines" ("graphicID");
CREATE INDEX "chrCareerSkills_IX_skillTypeID" ON "chrCareerSkills" ("skillTypeID");
CREATE INDEX "chrCareerSpecialities_IX_careerID" ON "chrCareerSpecialities" ("careerID");
CREATE INDEX "chrCareerSpecialities_IX_graphicID" ON "chrCareerSpecialities" ("graphicID");
CREATE INDEX "chrCareerSpecialitySkills_IX_skillTypeID" ON "chrCareerSpecialitySkills" ("skillTypeID");
CREATE INDEX "chrCareers_IX_raceID" ON "chrCareers" ("raceID");
CREATE INDEX "chrCareers_IX_schoolID" ON "chrCareers" ("schoolID");
CREATE INDEX "chrCareers_IX_graphicID" ON "chrCareers" ("graphicID");
CREATE INDEX "chrFactions_IX_solarSystemID" ON "chrFactions" ("solarSystemID");
CREATE INDEX "chrFactions_IX_corporationID" ON "chrFactions" ("corporationID");
CREATE INDEX "chrFactions_IX_militiaCorporationID" ON "chrFactions" ("militiaCorporationID");
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_raceID" ON "chrSchools" ("raceID");
CREATE INDEX "chrSchools_IX_graphicID" ON "chrSchools" ("graphicID");
CREATE INDEX "chrSchools_IX_corporationID" ON "chrSchools" ("corporationID");
CREATE INDEX "chrSchools_IX_careerID" ON "chrSchools" ("careerID");
CREATE INDEX "chrSchools_IX_newAgentID" ON "chrSchools" ("newAgentID");
CREATE INDEX "crpNPCCorporationDivisions_IX_divisionID" ON "crpNPCCorporationDivisions" ("divisionID");
CREATE INDEX "crpNPCCorporationResearchFields_IX_corporationID" ON "crpNPCCorporationResearchFields" ("corporationID");
CREATE INDEX "crpNPCCorporations_IX_solarSystemID" ON "crpNPCCorporations" ("solarSystemID");
CREATE INDEX "crpNPCCorporations_IX_factionID" ON "crpNPCCorporations" ("factionID");
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_friendID" ON "crpNPCCorporations" ("friendID");
CREATE INDEX "crpNPCCorporations_IX_enemyID" ON "crpNPCCorporations" ("enemyID");
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_graphicID" ON "dgmEffects" ("graphicID");
CREATE INDEX "dgmEffects_IX_durationAttributeID" ON "dgmEffects" ("durationAttributeID");
CREATE INDEX "dgmEffects_IX_trackingSpeedAttributeID" ON "dgmEffects" ("trackingSpeedAttributeID");
CREATE INDEX "dgmEffects_IX_dischargeAttributeID" ON "dgmEffects" ("dischargeAttributeID");
CREATE INDEX "dgmEffects_IX_rangeAttributeID" ON "dgmEffects" ("rangeAttributeID");
CREATE INDEX "dgmEffects_IX_falloffAttributeID" ON "dgmEffects" ("falloffAttributeID");
CREATE INDEX "dgmEffects_IX_npcUsageChanceAttributeID" ON "dgmEffects" ("npcUsageChanceAttributeID");
CREATE INDEX "dgmEffects_IX_npcActivationChanceAttributeID" ON "dgmEffects" ("npcActivationChanceAttributeID");
CREATE INDEX "dgmEffects_IX_fittingUsageChanceAttributeID" ON "dgmEffects" ("fittingUsageChanceAttributeID");
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_resourceTypeID" ON "invControlTowerResources" ("resourceTypeID");
CREATE INDEX "invControlTowerResources_IX_factionID" ON "invControlTowerResources" ("factionID");
CREATE INDEX "invControlTowerResources_IX_purpose" ON "invControlTowerResources" ("purpose");
CREATE INDEX "invGroups_IX_category" ON "invGroups" ("categoryID");
CREATE INDEX "invGroups_IX_graphicID" ON "invGroups" ("graphicID");
CREATE INDEX "invMarketGroups_IX_parentGroupID" ON "invMarketGroups" ("parentGroupID");
CREATE INDEX "invMarketGroups_IX_graphicID" ON "invMarketGroups" ("graphicID");
CREATE INDEX "invMetaGroups_IX_graphicID" ON "invMetaGroups" ("graphicID");
CREATE INDEX "invMetaTypes_IX_parentTypeID" ON "invMetaTypes" ("parentTypeID");
CREATE INDEX "invMetaTypes_IX_metaGroupID" ON "invMetaTypes" ("metaGroupID");
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_raceID" ON "invTypes" ("raceID");
CREATE INDEX "invTypes_IX_marketGroupID" ON "invTypes" ("marketGroupID");
CREATE INDEX "mapConstellationJumps_IX_fromRegion" ON "mapConstellationJumps" ("fromRegionID");
CREATE INDEX "mapConstellationJumps_IX_toConstellationID" ON "mapConstellationJumps" ("toConstellationID","toRegionID");
CREATE INDEX "mapConstellationJumps_IX_fromConstellationID" ON "mapConstellationJumps" ("fromConstellationID","fromRegionID");
CREATE INDEX "mapConstellations_IX_region" ON "mapConstellations" ("regionID");
CREATE INDEX "mapConstellations_IX_constellationID" ON "mapConstellations" ("constellationID","regionID");
CREATE INDEX "mapConstellations_IX_factionID" ON "mapConstellations" ("factionID");
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_locationID" ON "mapLandmarks" ("locationID");
CREATE INDEX "mapLandmarks_IX_graphicID" ON "mapLandmarks" ("graphicID");
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_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_factionID" ON "mapSolarSystems" ("factionID");
CREATE INDEX "mapSolarSystems_IX_sunTypeID" ON "mapSolarSystems" ("sunTypeID");
CREATE INDEX "ramAssemblyLineStations_IX_owner" ON "ramAssemblyLineStations" ("ownerID");
CREATE INDEX "ramAssemblyLineStations_IX_region" ON "ramAssemblyLineStations" ("regionID");
CREATE INDEX "ramAssemblyLineStations_IX_assemblyLineTypeID" ON "ramAssemblyLineStations" ("assemblyLineTypeID");
CREATE INDEX "ramAssemblyLineStations_IX_stationTypeID" ON "ramAssemblyLineStations" ("stationTypeID");
CREATE INDEX "ramAssemblyLineStations_IX_solarSystemID" ON "ramAssemblyLineStations" ("solarSystemID");
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_container" ON "ramAssemblyLines" ("containerID");
CREATE INDEX "ramAssemblyLines_IX_owner" ON "ramAssemblyLines" ("ownerID");
CREATE INDEX "ramAssemblyLines_IX_assemblyLineTypeID" ON "ramAssemblyLines" ("assemblyLineTypeID");
CREATE INDEX "ramAssemblyLines_IX_activityID" ON "ramAssemblyLines" ("activityID");
CREATE INDEX "staOperationServices_IX_serviceID" ON "staOperationServices" ("serviceID");
CREATE INDEX "staOperations_IX_activityID" ON "staOperations" ("activityID");
CREATE INDEX "staOperations_IX_caldariStationTypeID" ON "staOperations" ("caldariStationTypeID");
CREATE INDEX "staOperations_IX_minmatarStationTypeID" ON "staOperations" ("minmatarStationTypeID");
CREATE INDEX "staOperations_IX_amarrStationTypeID" ON "staOperations" ("amarrStationTypeID");
CREATE INDEX "staOperations_IX_gallenteStationTypeID" ON "staOperations" ("gallenteStationTypeID");
CREATE INDEX "staOperations_IX_joveStationTypeID" ON "staOperations" ("joveStationTypeID");
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_system" ON "staStations" ("solarSystemID");
CREATE INDEX "staStations_IX_type" ON "staStations" ("stationTypeID");
CREATE INDEX "staStations_IX_solarSystemID" ON "staStations" ("solarSystemID","constellationID","regionID");
CREATE INDEX "typeActivityMaterials_IX_activity" ON "typeActivityMaterials" ("activityID");
CREATE INDEX "typeActivityMaterials_IX_requiredTypeID" ON "typeActivityMaterials" ("requiredTypeID");