timerboard/add_indexes.sql at master · StupidGenius/timerboard · GitHub

1
2
3
4
5
6
7
8
9
10
11
ALTER TABLE mapdenormalize
ADD INDEX `mapDenormalize_IX_constellation` (`constellationID`),
ADD INDEX `mapDenormalize_IX_groupConstellation` (`groupID`, `constellationID`),
ADD INDEX `mapDenormalize_IX_groupRegion` (`groupID`, `regionID`),
ADD INDEX `mapDenormalize_IX_groupSystem` (`groupID`, `solarSystemID`),
ADD INDEX `mapDenormalize_IX_orbit` (`orbitID`),
ADD INDEX `mapDenormalize_IX_region` (`regionID`),
ADD INDEX `mapDenormalize_IX_system` (`solarSystemID`),
ADD INDEX `itemName` (`itemName`),
ADD INDEX `mapDenormalize_security` (`security`),
ADD INDEX `mapDenormalize_typeID` (`typeID`);