ALTER TABLE `TL2MaterialsForTypeWithActivity` ADD   PRIMARY KEY  (`typeID`,`activity`,`requiredTypeID`);
ALTER TABLE `agtAgentTypes` ADD   PRIMARY KEY  (`agentTypeID`);
ALTER TABLE `agtAgents` ADD   PRIMARY KEY  (`agentID`);
ALTER TABLE `agtConfig` ADD   PRIMARY KEY  (`agentID`,`k`);
ALTER TABLE `chrAncestries` ADD   PRIMARY KEY  (`ancestryID`);
ALTER TABLE `chrAttributes` ADD   PRIMARY KEY  (`attributeID`);
ALTER TABLE `chrBloodlines` ADD   PRIMARY KEY  (`bloodlineID`);
ALTER TABLE `chrCareerSkills` ADD   PRIMARY KEY  (`careerID`,`skillTypeID`);
ALTER TABLE `chrCareerSpecialities` ADD   PRIMARY KEY  (`careerID`,`specialityID`);
ALTER TABLE `chrCareerSpecialitySkills` ADD   PRIMARY KEY  (`specialityID`,`skillTypeID`);
ALTER TABLE `chrCareers` ADD   PRIMARY KEY  (`raceID`,`careerID`);
ALTER TABLE `chrFactions` ADD   PRIMARY KEY  (`factionID`);
ALTER TABLE `chrRaceSkills` ADD   PRIMARY KEY  (`raceID`,`skillTypeID`);
ALTER TABLE `chrRaces` ADD   PRIMARY KEY  (`raceID`);
ALTER TABLE `chrSchoolAgents` ADD   PRIMARY KEY  (`schoolID`,`agentIndex`,`agentID`);
ALTER TABLE `chrSchools` ADD   PRIMARY KEY  (`schoolID`);
ALTER TABLE `crpActivities` ADD   PRIMARY KEY  (`activityID`);
ALTER TABLE `crpNPCCorporationDivisions` ADD   PRIMARY KEY  (`corporationID`,`divisionID`);
ALTER TABLE `crpNPCCorporationResearchFields` ADD   PRIMARY KEY  (`skillID`,`corporationID`);
ALTER TABLE `crpNPCCorporations` ADD   PRIMARY KEY  (`corporationID`);
ALTER TABLE `crpNPCDivisions` ADD   PRIMARY KEY  (`divisionID`);
ALTER TABLE `dgmAttributeTypes` ADD   PRIMARY KEY  (`attributeID`);
ALTER TABLE `dgmEffects` ADD   PRIMARY KEY  (`effectID`);
ALTER TABLE `dgmTypeAttributes` ADD   PRIMARY KEY  (`typeID`,`attributeID`);
ALTER TABLE `dgmTypeEffects` ADD   PRIMARY KEY  (`typeID`,`effectID`);
ALTER TABLE `eveGraphics` ADD   PRIMARY KEY  (`graphicID`);
ALTER TABLE `eveNames` ADD   PRIMARY KEY  (`itemID`);
ALTER TABLE `eveNames` ADD   KEY  (`itemName`);
ALTER TABLE `eveUnits` ADD   PRIMARY KEY  (`unitID`);
ALTER TABLE `invBlueprintTypes` ADD   PRIMARY KEY  (`blueprintTypeID`);
ALTER TABLE `invCategories` ADD   PRIMARY KEY  (`categoryID`);
ALTER TABLE `invContrabandTypes` ADD   PRIMARY KEY  (`factionID`,`typeID`);
ALTER TABLE `invControlTowerResourcePurposes` ADD   PRIMARY KEY  (`purpose`);
ALTER TABLE `invControlTowerResources` ADD   PRIMARY KEY  (`controlTowerTypeID`,`resourceTypeID`);
ALTER TABLE `invFlags` ADD   PRIMARY KEY  (`flagID`);
ALTER TABLE `invGroups` ADD   PRIMARY KEY  (`groupID`);
ALTER TABLE `invMarketGroups` ADD   PRIMARY KEY  (`marketGroupID`);
ALTER TABLE `invMetaGroups` ADD   PRIMARY KEY  (`metaGroupID`);
ALTER TABLE `invMetaTypes` ADD   PRIMARY KEY  (`typeID`);
ALTER TABLE `invTypeReactions` ADD   PRIMARY KEY  (`reactionTypeID`,`input`,`typeID`);
ALTER TABLE `invTypes` ADD   PRIMARY KEY  (`typeID`);
ALTER TABLE `mapCelestialStatistics` ADD   PRIMARY KEY  (`celestialID`);
ALTER TABLE `mapConstellationJumps` ADD   PRIMARY KEY  (`fromConstellationID`,`toConstellationID`);
ALTER TABLE `mapConstellations` ADD   PRIMARY KEY  (`constellationID`);
ALTER TABLE `mapDenormalize` ADD   KEY  (`solarSystemID`);
ALTER TABLE `mapDenormalize` ADD   KEY  (`constellationID`);
ALTER TABLE `mapDenormalize` ADD   KEY  (`regionID`);
ALTER TABLE `mapDenormalize` ADD   PRIMARY KEY  (`itemID`);
ALTER TABLE `mapJumps` ADD   PRIMARY KEY  (`stargateID`);
ALTER TABLE `mapLandmarks` ADD   PRIMARY KEY  (`landmarkID`);
ALTER TABLE `mapRegionJumps` ADD   PRIMARY KEY  (`fromRegionID`,`toRegionID`);
ALTER TABLE `mapRegions` ADD   PRIMARY KEY  (`regionID`);
ALTER TABLE `mapSolarSystemJumps` ADD   PRIMARY KEY  (`fromSolarSystemID`,`toSolarSystemID`);
ALTER TABLE `mapSolarSystems` ADD   PRIMARY KEY  (`solarSystemID`);
ALTER TABLE `mapUniverse` ADD   PRIMARY KEY  (`universeID`);
ALTER TABLE `ramAssemblyLineStations` ADD   PRIMARY KEY  (`stationID`,`assemblyLineTypeID`);
ALTER TABLE `ramAssemblyLineTypeDetailPerCategory` ADD   PRIMARY KEY  (`assemblyLineTypeID`,`categoryID`);
ALTER TABLE `ramAssemblyLineTypeDetailPerGroup` ADD   PRIMARY KEY  (`assemblyLineTypeID`,`groupID`);
ALTER TABLE `ramAssemblyLineTypes` ADD   PRIMARY KEY  (`assemblyLineTypeID`);
ALTER TABLE `ramAssemblyLines` ADD   PRIMARY KEY  (`assemblyLineID`);
ALTER TABLE `ramCompletedStatuses` ADD   PRIMARY KEY  (`completedStatus`);
ALTER TABLE `staOperationServices` ADD   PRIMARY KEY  (`operationID`,`serviceID`);
ALTER TABLE `staOperations` ADD   PRIMARY KEY  (`operationID`);
ALTER TABLE `staServices` ADD   PRIMARY KEY  (`serviceID`);
ALTER TABLE `staStationTypes` ADD   PRIMARY KEY  (`stationTypeID`);
ALTER TABLE `staStations` ADD   PRIMARY KEY  (`stationID`);