These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

SDE 20160628 conversions

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2016-06-28 19:01:46 UTC  |  Edited by: Steve Ronuken
mysql:
https://www.fuzzwork.co.uk/dump/mysql56-sde-20160628-TRANQUILITY.tbz2

sqlite:
https://www.fuzzwork.co.uk/dump/sde-20160628-TRANQUILITY/eve.db.bz2

postgres, in public schema:
https://www.fuzzwork.co.uk/dump/sde-20160628-TRANQUILITY/postgres-20160628-TRANQUILITY.dmp.bz2

postgres in evesde schema:
https://www.fuzzwork.co.uk/dump/sde-20160628-TRANQUILITY/postgres-20160628-TRANQUILITY-schema.dmp.bz2

Everything else:
https://www.fuzzwork.co.uk/dump/sde-20160628-TRANQUILITY/




Total side note:

I recently started a patreon. I'll keep doing the conversions, even if no-one donates, but I'm running into a problem with market.fuzzwork.co.uk . Namely that the process pegs out the disk on insert. I'll get it shifted over to a server with SSDs at some point, but support would be appreciated. Smile And if you're offended I'd ask, just ignore it.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Messenger Of Truth
Butlerian Crusade
#2 - 2016-06-30 20:17:14 UTC  |  Edited by: Messenger Of Truth
mapSolarSystemJumps is empty!

--
-- Dumping data for table `mapSolarSystemJumps`
--

LOCK TABLES `mapSolarSystemJumps` WRITE;
/*!40000 ALTER TABLE `mapSolarSystemJumps` DISABLE KEYS */;
/*!40000 ALTER TABLE `mapSolarSystemJumps` ENABLE KEYS */;
UNLOCK TABLES;



That's from sde-20160628-TRANQUILITY.sql

Trade Hub Price Checker: stop.hammerti.me.uk/pricecheck

Visit "Haulers Channel" in game for all matters courier-related.

Structure name/system API: stop.hammerti.me.uk/api
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2016-07-01 11:39:23 UTC
ahh. yes. that.

I knew I forgot to do something. (it's now written into the conversion code.)

insert into mapSolarSystemJumps (fromRegionID,fromConstellationID,fromSolarSystemID,toRegionID,toConstellationID,toSolarSystemID)
select f.regionID fromRegionID,f.constellationID fromConstellationID,f.solarSystemID fromSolarSystemID,t.regionID toRegionID,t.constellationID toConstellationID,t.solarSystemID toSolarSystemID
from mapJumps join mapDenormalize f on mapJumps.stargateID=f.itemID join mapDenormalize t on mapJumps.destinationID=t.itemID;

insert into mapRegionJumps
select distinct f.regionID,t.regionID
from mapJumps join mapDenormalize f on mapJumps.stargateID=f.itemID join mapDenormalize t on mapJumps.destinationID=t.itemID where f.regionID!=t.regionID;


insert into mapConstellationJumps
select distinct f.regionID,f.constellationID,t.constellationID,t.regionID
from mapJumps join mapDenormalize f on mapJumps.stargateID=f.itemID join mapDenormalize t on mapJumps.destinationID=t.itemID where f.constellationID!=t.constellationID;

will populate those tables for you.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter