Por el momento los dos únicos resultados que necesito de estos datos son el conjunto estoy trabajando ahora, siendo el conjunto que me dice que los sistemas que están dentro de N saltos de cualquier sistema dado, y el camino más corto entre dos sistemas, que ya tengo de trabajo.
Aquí están las tablas que tengo que trabajar. La tabla con la que trabajo principalmente es la tabla mapSolarSystemJumps, que tiene 14.334 filas.
CREATE TABLE `mapSolarSystems` (
`regionID` int(11) DEFAULT NULL,
`constellationID` int(11) DEFAULT NULL,
`solarSystemID` int(11) NOT NULL,
`solarSystemName` varchar(100) DEFAULT NULL,
`x` double DEFAULT NULL,
`y` double DEFAULT NULL,
`z` double DEFAULT NULL,
`xMin` double DEFAULT NULL,
`xMax` double DEFAULT NULL,
`yMin` double DEFAULT NULL,
`yMax` double DEFAULT NULL,
`zMin` double DEFAULT NULL,
`zMax` double DEFAULT NULL,
`luminosity` double DEFAULT NULL,
`border` tinyint(1) DEFAULT NULL,
`fringe` tinyint(1) DEFAULT NULL,
`corridor` tinyint(1) DEFAULT NULL,
`hub` tinyint(1) DEFAULT NULL,
`international` tinyint(1) DEFAULT NULL,
`regional` tinyint(1) DEFAULT NULL,
`constellation` tinyint(1) DEFAULT NULL,
`security` double DEFAULT NULL,
`factionID` int(11) DEFAULT NULL,
`radius` double DEFAULT NULL,
`sunTypeID` smallint(6) DEFAULT NULL,
`securityClass` varchar(2) DEFAULT NULL,
PRIMARY KEY (`solarSystemID`),
UNIQUE KEY `solarSystemID` (`solarSystemID`,`constellationID`,`regionID`),
KEY `mapSolarSystems_IX_constellation` (`constellationID`),
KEY `mapSolarSystems_IX_region` (`regionID`),
KEY `mapSolarSystems_IX_security` (`security`),
KEY `factionID` (`factionID`),
KEY `sunTypeID` (`sunTypeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `mapSolarSystems` (
- `regionID` int(11) DEFAULT NULL,
- `constellationID` int(11) DEFAULT NULL,
- `solarSystemID` int(11) NOT NULL,
- `solarSystemName` varchar(100) DEFAULT NULL,
- `x` double DEFAULT NULL,
- `y` double DEFAULT NULL,
- `z` double DEFAULT NULL,
- `xMin` double DEFAULT NULL,
- `xMax` double DEFAULT NULL,
- `yMin` double DEFAULT NULL,
- `yMax` double DEFAULT NULL,
- `zMin` double DEFAULT NULL,
- `zMax` double DEFAULT NULL,
- `luminosity` double DEFAULT NULL,
- `border` tinyint(1) DEFAULT NULL,
- `fringe` tinyint(1) DEFAULT NULL,
- `corridor` tinyint(1) DEFAULT NULL,
- `hub` tinyint(1) DEFAULT NULL,
- `international` tinyint(1) DEFAULT NULL,
- `regional` tinyint(1) DEFAULT NULL,
- `constellation` tinyint(1) DEFAULT NULL,
- `security` double DEFAULT NULL,
- `factionID` int(11) DEFAULT NULL,
- `radius` double DEFAULT NULL,
- `sunTypeID` smallint(6) DEFAULT NULL,
- `securityClass` varchar(2) DEFAULT NULL,
- PRIMARY KEY (`solarSystemID`),
- UNIQUE KEY `solarSystemID` (`solarSystemID`,`constellationID`,`regionID`),
- KEY `mapSolarSystems_IX_constellation` (`constellationID`),
- KEY `mapSolarSystems_IX_region` (`regionID`),
- KEY `mapSolarSystems_IX_security` (`security`),
- KEY `factionID` (`factionID`),
- KEY `sunTypeID` (`sunTypeID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `mapSolarSystemJumps` (
`fromRegionID` int(11) DEFAULT NULL,
`fromConstellationID` int(11) DEFAULT NULL,
`fromSolarSystemID` int(11) NOT NULL,
`toSolarSystemID` int(11) NOT NULL,
`toConstellationID` int(11) DEFAULT NULL,
`toRegionID` int(11) DEFAULT NULL,
PRIMARY KEY (`fromSolarSystemID`,`toSolarSystemID`),
KEY `mapSolarSystemJumps_IX_fromConstellation` (`fromConstellationID`),
KEY `mapSolarSystemJumps_IX_fromRegion` (`fromRegionID`),
KEY `fromSolarSystemID` (`fromSolarSystemID`,`fromConstellationID`,`fromRegionID`),
KEY `toSolarSystemID` (`toSolarSystemID`,`toConstellationID`,`toRegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `mapSolarSystemJumps` (
- `fromRegionID` int(11) DEFAULT NULL,
- `fromConstellationID` int(11) DEFAULT NULL,
- `fromSolarSystemID` int(11) NOT NULL,
- `toSolarSystemID` int(11) NOT NULL,
- `toConstellationID` int(11) DEFAULT NULL,
- `toRegionID` int(11) DEFAULT NULL,
- PRIMARY KEY (`fromSolarSystemID`,`toSolarSystemID`),
- KEY `mapSolarSystemJumps_IX_fromConstellation` (`fromConstellationID`),
- KEY `mapSolarSystemJumps_IX_fromRegion` (`fromRegionID`),
- KEY `fromSolarSystemID` (`fromSolarSystemID`,`fromConstellationID`,`fromRegionID`),
- KEY `toSolarSystemID` (`toSolarSystemID`,`toConstellationID`,`toRegionID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `mapRegions` (
`regionID` int(11) NOT NULL,
`regionName` varchar(100) DEFAULT NULL,
`x` double DEFAULT NULL,
`y` double DEFAULT NULL,
`z` double DEFAULT NULL,
`xMin` double DEFAULT NULL,
`xMax` double DEFAULT NULL,
`yMin` double DEFAULT NULL,
`yMax` double DEFAULT NULL,
`zMin` double DEFAULT NULL,
`zMax` double DEFAULT NULL,
`factionID` int(11) DEFAULT NULL,
`radius` double DEFAULT NULL,
PRIMARY KEY (`regionID`),
KEY `factionID` (`factionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `mapRegions` (
- `regionID` int(11) NOT NULL,
- `regionName` varchar(100) DEFAULT NULL,
- `x` double DEFAULT NULL,
- `y` double DEFAULT NULL,
- `z` double DEFAULT NULL,
- `xMin` double DEFAULT NULL,
- `xMax` double DEFAULT NULL,
- `yMin` double DEFAULT NULL,
- `yMax` double DEFAULT NULL,
- `zMin` double DEFAULT NULL,
- `zMax` double DEFAULT NULL,
- `factionID` int(11) DEFAULT NULL,
- `radius` double DEFAULT NULL,
- PRIMARY KEY (`regionID`),
- KEY `factionID` (`factionID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `mapRegionJumps` (
`fromRegionID` int(11) NOT NULL,
`toRegionID` int(11) NOT NULL,
PRIMARY KEY (`fromRegionID`,`toRegionID`),
KEY `toRegionID` (`toRegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `mapRegionJumps` (
- `fromRegionID` int(11) NOT NULL,
- `toRegionID` int(11) NOT NULL,
- PRIMARY KEY (`fromRegionID`,`toRegionID`),
- KEY `toRegionID` (`toRegionID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `mapConstellations` (
`regionID` int(11) DEFAULT NULL,
`constellationID` int(11) NOT NULL,
`constellationName` varchar(100) DEFAULT NULL,
`x` double DEFAULT NULL,
`y` double DEFAULT NULL,
`z` double DEFAULT NULL,
`xMin` double DEFAULT NULL,
`xMax` double DEFAULT NULL,
`yMin` double DEFAULT NULL,
`yMax` double DEFAULT NULL,
`zMin` double DEFAULT NULL,
`zMax` double DEFAULT NULL,
`factionID` int(11) DEFAULT NULL,
`radius` double DEFAULT NULL,
PRIMARY KEY (`constellationID`),
UNIQUE KEY `constellationID` (`constellationID`,`regionID`),
KEY `mapConstellations_IX_region` (`regionID`),
KEY `factionID` (`factionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `mapConstellations` (
- `regionID` int(11) DEFAULT NULL,
- `constellationID` int(11) NOT NULL,
- `constellationName` varchar(100) DEFAULT NULL,
- `x` double DEFAULT NULL,
- `y` double DEFAULT NULL,
- `z` double DEFAULT NULL,
- `xMin` double DEFAULT NULL,
- `xMax` double DEFAULT NULL,
- `yMin` double DEFAULT NULL,
- `yMax` double DEFAULT NULL,
- `zMin` double DEFAULT NULL,
- `zMax` double DEFAULT NULL,
- `factionID` int(11) DEFAULT NULL,
- `radius` double DEFAULT NULL,
- PRIMARY KEY (`constellationID`),
- UNIQUE KEY `constellationID` (`constellationID`,`regionID`),
- KEY `mapConstellations_IX_region` (`regionID`),
- KEY `factionID` (`factionID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
CREATE TABLE `mapConstellationJumps` (
`fromRegionID` int(11) DEFAULT NULL,
`fromConstellationID` int(11) NOT NULL,
`toConstellationID` int(11) NOT NULL,
`toRegionID` int(11) DEFAULT NULL,
PRIMARY KEY (`fromConstellationID`,`toConstellationID`),
KEY `mapConstellationJumps_IX_fromRegion` (`fromRegionID`),
KEY `toConstellationID` (`toConstellationID`,`toRegionID`),
KEY `fromConstellationID` (`fromConstellationID`,`fromRegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `mapConstellationJumps` (
- `fromRegionID` int(11) DEFAULT NULL,
- `fromConstellationID` int(11) NOT NULL,
- `toConstellationID` int(11) NOT NULL,
- `toRegionID` int(11) DEFAULT NULL,
- PRIMARY KEY (`fromConstellationID`,`toConstellationID`),
- KEY `mapConstellationJumps_IX_fromRegion` (`fromRegionID`),
- KEY `toConstellationID` (`toConstellationID`,`toRegionID`),
- KEY `fromConstellationID` (`fromConstellationID`,`fromRegionID`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Strong with this one, the sudo is.