ALTER TABLE `eveIcons` ENGINE = INNODB;

ALTER TABLE `invCategories` ENGINE = INNODB,
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);


ALTER TABLE `invGroups` ENGINE = INNODB,
ADD FOREIGN KEY (`categoryID`) REFERENCES `invCategories` (`categoryID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `eveGraphics` ENGINE = INNODB;
ALTER TABLE `eveGraphics` ADD FOREIGN KEY (`explosionID`) REFERENCES `eveGraphics` (`graphicID`);

ALTER TABLE `chrRaces` ENGINE = INNODB,
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `invMarketGroups` ENGINE = INNODB;
ALTER TABLE `invMarketGroups` ADD FOREIGN KEY (`parentGroupID`) REFERENCES `invMarketGroups` (`marketGroupID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `invTypes` ENGINE = INNODB,
ADD FOREIGN KEY (`groupID`) REFERENCES `invGroups` (`groupID`),
ADD FOREIGN KEY (`graphicID`) REFERENCES `eveGraphics` (`graphicID`),
ADD FOREIGN KEY (`raceID`) REFERENCES `chrRaces` (`raceID`),
ADD FOREIGN KEY (`marketGroupID`) REFERENCES `invMarketGroups` (`marketGroupID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `agtAgentTypes` ENGINE = INNODB;

ALTER TABLE `eveNames` ENGINE = INNODB,
ADD FOREIGN KEY (`categoryID`) REFERENCES `invCategories` (`categoryID`),
ADD FOREIGN KEY (`groupID`) REFERENCES `invGroups` (`groupID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `chrFactions` ENGINE = INNODB;

ALTER TABLE `mapRegions` ENGINE = INNODB,
ADD FOREIGN KEY (`factionID`) REFERENCES `chrFactions` (`factionID`);

ALTER TABLE `mapConstellations` ENGINE = INNODB,
ADD FOREIGN KEY (`factionID`) REFERENCES `chrFactions` (`factionID`),
ADD FOREIGN KEY (`regionID`) REFERENCES `mapRegions` (`regionID`);

ALTER TABLE `mapSolarSystems` ENGINE = INNODB,
ADD FOREIGN KEY (`factionID`) REFERENCES `chrFactions` (`factionID`),
ADD FOREIGN KEY (`regionID`) REFERENCES `mapRegions` (`regionID`),
ADD FOREIGN KEY (`constellationID`) REFERENCES `mapConstellations` (`constellationID`),
ADD FOREIGN KEY (`sunTypeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `crpNPCCorporations` ENGINE = INNODB;

ALTER TABLE `chrFactions` ADD FOREIGN KEY (`militiaCorporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`solarSystemID`) REFERENCES `mapSolarSystems` (`solarSystemID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);


ALTER TABLE `crpNPCCorporations` ADD FOREIGN KEY (`corporationID`) REFERENCES `eveNames` (`itemID`),
ADD FOREIGN KEY (`solarSystemID`) REFERENCES `mapSolarSystems` (`solarSystemID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`),
ADD FOREIGN KEY (`factionID`) REFERENCES `chrFactions` (`factionID`),
ADD FOREIGN KEY (`investorID1`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`investorID2`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`investorID3`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`investorID4`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`friendID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`enemyID`) REFERENCES `crpNPCCorporations` (`corporationID`);

ALTER TABLE `crpNPCDivisions` ENGINE = INNODB;

ALTER TABLE `mapDenormalize` ENGINE = INNODB;
ALTER TABLE `mapDenormalize` ADD FOREIGN KEY (`orbitID`) REFERENCES `mapDenormalize` (`itemID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`groupID`) REFERENCES `invGroups` (`groupID`),
ADD FOREIGN KEY (`solarSystemID`) REFERENCES `mapSolarSystems` (`solarSystemID`),
ADD FOREIGN KEY (`constellationID`) REFERENCES `mapConstellations` (`constellationID`),
ADD FOREIGN KEY (`regionID`) REFERENCES `mapRegions` (`regionID`);

ALTER TABLE `agtAgents` ENGINE = INNODB,
ADD FOREIGN KEY (`agentID`) REFERENCES `eveNames` (`itemID`),
ADD FOREIGN KEY (`divisionID`) REFERENCES `crpNPCDivisions` (`divisionID`),
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`locationID`) REFERENCES `mapDenormalize` (`itemID`),
ADD FOREIGN KEY (`agentTypeID`) REFERENCES `agtAgentTypes` (`agentTypeID`);

ALTER TABLE `agtConfig` ENGINE = INNODB,
ADD FOREIGN KEY (`agentID`) REFERENCES `agtAgents` (`agentID`);

ALTER TABLE `agtResearchAgents` ENGINE = INNODB,
ADD FOREIGN KEY (`agentID`) REFERENCES `agtAgents` (`agentID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `chrBloodlines` ENGINE = INNODB,
ADD FOREIGN KEY (`raceID`) REFERENCES `chrRaces` (`raceID`),
ADD FOREIGN KEY (`shipTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `chrAncestries` ENGINE = INNODB,
ADD FOREIGN KEY (`bloodlineID`) REFERENCES `chrBloodlines` (`bloodlineID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `chrAttributes` ENGINE = INNODB,
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `crpActivities` ENGINE = INNODB;

ALTER TABLE `crpNPCCorporationDivisions` ENGINE = INNODB,
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`divisionID`) REFERENCES `crpNPCDivisions` (`divisionID`);

ALTER TABLE `crpNPCCorporationResearchFields` ENGINE = INNODB,
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`skillID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `crpNPCCorporationTrades` ENGINE = INNODB,
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `crtCategories` ENGINE = INNODB;
ALTER TABLE `crtClasses` ENGINE = INNODB;

ALTER TABLE `crtCertificates` ENGINE = INNODB,
ADD FOREIGN KEY (`categoryID`) REFERENCES `crtCategories` (`categoryID`),
ADD FOREIGN KEY (`classID`) REFERENCES `crtClasses` (`classID`),
ADD FOREIGN KEY (`corpID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `crtRecommendations` ENGINE = INNODB,
ADD FOREIGN KEY (`certificateID`) REFERENCES `crtCertificates` (`certificateID`),
ADD FOREIGN KEY (`shipTypeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `crtRelationships` ENGINE = INNODB,
ADD FOREIGN KEY (`parentID`) REFERENCES `crtCertificates` (`certificateID`),
ADD FOREIGN KEY (`parentTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`childID`) REFERENCES `crtCertificates` (`certificateID`);

ALTER TABLE `dgmAttributeCategories` ENGINE = INNODB;
ALTER TABLE `eveUnits` ENGINE = INNODB;

ALTER TABLE `dgmAttributeTypes` ENGINE = INNODB,
ADD FOREIGN KEY (`categoryID`) REFERENCES `dgmAttributeCategories` (`categoryID`),
ADD FOREIGN KEY (`unitID`) REFERENCES `eveUnits` (`unitID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `dgmTypeAttributes` ENGINE = INNODB,
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`attributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`);

ALTER TABLE `dgmEffects` ENGINE = INNODB,
ADD FOREIGN KEY (`durationAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`trackingSpeedAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`dischargeAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`rangeAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`falloffAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`npcUsageChanceAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`npcActivationChanceAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`fittingUsageChanceAttributeID`) REFERENCES `dgmAttributeTypes` (`attributeID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `dgmTypeEffects` ENGINE = INNODB,
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`effectID`) REFERENCES `dgmEffects` (`effectID`);

ALTER TABLE `invBlueprintTypes` ENGINE = INNODB,
ADD FOREIGN KEY (`blueprintTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`parentBlueprintTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`productTypeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `invContrabandTypes` ENGINE = INNODB,
ADD FOREIGN KEY (`factionID`) REFERENCES `chrFactions` (`factionID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `invControlTowerResourcePurposes` ENGINE = INNODB;

ALTER TABLE `invControlTowerResources` ENGINE = INNODB,
ADD FOREIGN KEY (`controlTowerTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`resourceTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`factionID`) REFERENCES `chrFactions` (`factionID`),
ADD FOREIGN KEY (`purpose`) REFERENCES `invControlTowerResourcePurposes` (`purpose`);

ALTER TABLE `invFlags` ENGINE = INNODB;

ALTER TABLE `invMetaGroups` ENGINE = INNODB,
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `invMetaTypes` ENGINE = INNODB,
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`parentTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`metaGroupID`) REFERENCES `invMetaGroups` (`metaGroupID`);

ALTER TABLE `invTypeMaterials` ENGINE = INNODB,
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`materialTypeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `invTypeReactions` ENGINE = INNODB,
ADD FOREIGN KEY (`reactionTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `mapCelestialStatistics` ENGINE = INNODB,
ADD FOREIGN KEY (`celestialID`) REFERENCES `mapDenormalize` (`itemID`);

ALTER TABLE `mapConstellationJumps` ENGINE = INNODB;
ALTER TABLE `mapConstellationJumps` ADD FOREIGN KEY (`fromConstellationID`, `fromRegionID`) REFERENCES `mapConstellations` (`constellationID`, `regionID`),
ADD FOREIGN KEY (`toConstellationID`, `toRegionID`) REFERENCES `mapConstellations` (`constellationID`, `regionID`),
add foreign key (`toConstellationID`, `toRegionID`) REFERENCES `mapConstellationJumps` (`fromConstellationID`, `fromRegionID`),
add foreign key (`fromConstellationID`, `fromRegionID`) REFERENCES `mapConstellationJumps` (`toConstellationID`, `toRegionID`);

ALTER TABLE `mapJumps` ENGINE = INNODB,
ADD FOREIGN KEY (`stargateID`) REFERENCES `mapDenormalize` (`itemID`),
ADD FOREIGN KEY (`celestialID`) REFERENCES `mapDenormalize` (`itemID`);

ALTER TABLE `mapLandmarks` ENGINE = INNODB,
ADD FOREIGN KEY (`locationID`) REFERENCES `mapSolarSystems` (`solarSystemID`),
ADD FOREIGN KEY (`iconID`) REFERENCES `eveIcons` (`iconID`);

ALTER TABLE `mapLocationScenes` ENGINE = INNODB,
ADD FOREIGN KEY (`locationID`) REFERENCES `mapDenormalize` (`itemID`);

ALTER TABLE `mapLocationWormholeClasses` ENGINE = INNODB,
ADD FOREIGN KEY (`locationID`) REFERENCES `mapDenormalize` (`itemID`);

ALTER TABLE `mapRegionJumps` ENGINE = INNODB,
ADD FOREIGN KEY (`fromRegionID`) REFERENCES `mapRegions` (`regionID`),
ADD FOREIGN KEY (`toRegionID`) REFERENCES `mapRegions` (`regionID`);

ALTER TABLE `mapSolarSystemJumps` ENGINE = INNODB;
ALTER TABLE `mapSolarSystemJumps` ADD FOREIGN KEY (`fromSolarSystemID`, `fromConstellationID`, `fromRegionID`) REFERENCES `mapSolarSystems` (`solarSystemID`, `constellationID`, `regionID`),
ADD FOREIGN KEY (`toSolarSystemID`, `toConstellationID`, `toRegionID`) REFERENCES `mapSolarSystems` (`solarSystemID`, `constellationID`, `regionID`),
add foreign key (`fromSolarSystemID`, `fromConstellationID`, `fromRegionID`) REFERENCES `mapSolarSystemJumps` (`toSolarSystemID`, `toConstellationID`, `toRegionID`),
add foreign key (`toSolarSystemID`, `toConstellationID`, `toRegionID`) REFERENCES `mapSolarSystems` (`solarSystemID`, `constellationID`, `regionID`);

ALTER TABLE `mapUniverse` ENGINE = INNODB;

ALTER TABLE `planetSchematics` ENGINE = INNODB;

ALTER TABLE `planetSchematicsPinMap` ENGINE = INNODB,
ADD FOREIGN KEY (`schematicID`) REFERENCES `planetSchematics` (`schematicID`),
ADD FOREIGN KEY (`pinTypeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `planetSchematicsTypeMap` ENGINE = INNODB,
ADD FOREIGN KEY (`schematicID`) REFERENCES `planetSchematics` (`schematicID`),
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `ramActivities` ENGINE = INNODB;

ALTER TABLE `ramAssemblyLineTypes` ENGINE = INNODB,
ADD FOREIGN KEY (`activityID`) REFERENCES `ramActivities` (`activityID`);

ALTER TABLE `staServices` ENGINE = INNODB;
ALTER TABLE `staStationTypes` ENGINE = INNODB;

ALTER TABLE `staOperations` ENGINE = INNODB,
ADD FOREIGN KEY (`activityID`) REFERENCES `crpActivities` (`activityID`),
ADD FOREIGN KEY (`caldariStationTypeID`) REFERENCES `staStationTypes` (`stationTypeID`),
ADD FOREIGN KEY (`minmatarStationTypeID`) REFERENCES `staStationTypes` (`stationTypeID`),
ADD FOREIGN KEY (`amarrStationTypeID`) REFERENCES `staStationTypes` (`stationTypeID`),
ADD FOREIGN KEY (`gallenteStationTypeID`) REFERENCES `staStationTypes` (`stationTypeID`),
ADD FOREIGN KEY (`joveStationTypeID`) REFERENCES `staStationTypes` (`stationTypeID`);

ALTER TABLE `staOperationServices` ENGINE = INNODB,
ADD FOREIGN KEY (`operationID`) REFERENCES `staOperations` (`operationID`),
ADD FOREIGN KEY (`serviceID`) REFERENCES `staServices` (`serviceID`);

ALTER TABLE `staStationTypes` ADD FOREIGN KEY (`stationTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`operationID`) REFERENCES `staOperations` (`operationID`);

ALTER TABLE `staStations` ENGINE = INNODB,
ADD FOREIGN KEY (`operationID`) REFERENCES `staOperations` (`operationID`),
ADD FOREIGN KEY (`stationTypeID`) REFERENCES `staStationTypes` (`stationTypeID`),
ADD FOREIGN KEY (`corporationID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`solarSystemID`, `constellationID`, `regionID`) REFERENCES `mapSolarSystems` (`solarSystemID`, `constellationID`, `regionID`);

ALTER TABLE `ramAssemblyLineStations` ENGINE = INNODB,
ADD FOREIGN KEY (`stationID`) REFERENCES `staStations` (`stationID`),
ADD FOREIGN KEY (`assemblyLineTypeID`) REFERENCES `ramAssemblyLineTypes` (`assemblyLineTypeID`),
ADD FOREIGN KEY (`stationTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`ownerID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`solarSystemID`) REFERENCES `mapSolarSystems` (`solarSystemID`),
ADD FOREIGN KEY (`regionID`) REFERENCES `mapRegions` (`regionID`);

ALTER TABLE `ramAssemblyLineTypeDetailPerCategory` ENGINE = INNODB,
ADD FOREIGN KEY (`assemblyLineTypeID`) REFERENCES `ramAssemblyLineTypes` (`assemblyLineTypeID`),
ADD FOREIGN KEY (`categoryID`) REFERENCES `invCategories` (`categoryID`);

ALTER TABLE `ramAssemblyLineTypeDetailPerGroup` ENGINE = INNODB,
ADD FOREIGN KEY (`assemblyLineTypeID`) REFERENCES `ramAssemblyLineTypes` (`assemblyLineTypeID`),
ADD FOREIGN KEY (`groupID`) REFERENCES `invGroups` (`groupID`);

ALTER TABLE `ramAssemblyLines` ENGINE = INNODB,
ADD FOREIGN KEY (`assemblyLineTypeID`) REFERENCES `ramAssemblyLineTypes` (`assemblyLineTypeID`),
ADD FOREIGN KEY (`activityID`) REFERENCES `ramActivities` (`activityID`),
ADD FOREIGN KEY (`ownerID`) REFERENCES `crpNPCCorporations` (`corporationID`),
ADD FOREIGN KEY (`containerID`) REFERENCES `staStations` (`stationID`);

ALTER TABLE `ramInstallationTypeContents` ENGINE = INNODB,
ADD FOREIGN KEY (`assemblyLineTypeID`) REFERENCES `ramAssemblyLineTypes` (`assemblyLineTypeID`),
ADD FOREIGN KEY (`installationTypeID`) REFERENCES `invTypes` (`typeID`);

ALTER TABLE `ramTypeRequirements` ENGINE = INNODB,
ADD FOREIGN KEY (`typeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`requiredTypeID`) REFERENCES `invTypes` (`typeID`),
ADD FOREIGN KEY (`activityID`) REFERENCES `ramActivities` (`activityID`);

ALTER TABLE `trnTranslationColumns` ENGINE = INNODB;
ALTER TABLE `trnTranslations` ENGINE = INNODB,
ADD FOREIGN KEY (`tcID`) REFERENCES `trnTranslationColumns` (`tcID`);