MySQL Table containing secure and insecure distances from and to every system in New Eden

[EveDataRules]

Download here: https://github.com/antihax/eve-jumps

Simple table allowing silly queries to find things within a distance from a system.

CREATE TABLE `jumps` (
  `toSolarSystemID` int(10) unsigned NOT NULL DEFAULT '0',
  `fromSolarSystemID` int(10) unsigned NOT NULL DEFAULT '0',
  `jumps` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `secureJumps` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`toSolarSystemID`,`fromSolarSystemID`),
  KEY `fromSolarSystemID` (`fromSolarSystemID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Can do such queries as this one which will find every highsec “island” system disconnected by low or null from the major trade hubs in 0.125s.

SELECT DISTINCT solarSystemName, regionName 
  FROM evedata.jumps J 
  INNER JOIN mapSolarSystems S ON J.toSolarSystemID = S.solarSystemID
   AND ROUND(S.security, 1) >= 0.5
  INNER JOIN mapRegions R ON S.regionID = R.regionID
  WHERE fromSolarSystemID IN (30000001, 30002510, 30002659, 30002187, 30000142) 
   AND secureJumps >= 254