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.
 

Static Data Export (SDE) for Escalation 1.0 and MySQL conversion
Author
Previous Topic Next Topic
Luminocity
The Dark Revenants
PLEASE NOT VIOLENCE OUR BOATS
#1 - 2012-04-25 07:53:25 UTC  |  Edited by: Luminocity
CCP has released a new version of the MSSQL static data dump. It is available on the toolkit site or directly from the URL below:
http://content.eveonline.com/data/Escalation_1.0_67593_db.zip

Official changelog:
Quote:
CHANGED IN ESCALATION 1.0
-- invTypes.marketGroupID changed to int
-- invMarketGroups.marketGroupID changed to int
-- invMarketGroups.parentGroupID changed to int

I have also created a MySQL 5.5 conversion. No extended inserts, camelCase table naming, MyISAM engine. Pretty standard stuff. It is available here:
escalation1.0.67593-mysql5-v2.zip

Enjoy! :)
Luminocity
The Dark Revenants
PLEASE NOT VIOLENCE OUR BOATS
#2 - 2012-04-25 13:25:21 UTC  |  Edited by: Luminocity
A few data dump changes which I found interesting/important enough to check out in more detail (with their corresponding listing from the patch notes)

Quote:
Worldshaping
  • The security status of systems in Etherium Reach, Malpais, Oasa, Outer Passage, Perrigen Falls, The Kalvela Expanse and the Spire has been adjusted upwards to bring them more into line with the rest of nullse
    • Changed systems are listed here: link (610 total)

    Quote:
    Miscellaneous
  • A few types which were erroneously removed from Tranquility in Crucible 1.5 have been restored, most notably the old mines and their blueprints. People who were previously in possession of these types will have them re-added to their assets over the following few days
    • List of added/removed invTypes is here: link

    Quote:
    Market & Contracts
  • A lot of modules have been added to the market that previously could only be found in Contracts. Mostly these are officer, deadspace, faction and storyline modules. Note that this only means that players can now buy and sell them between themselves.
    • List of added modules is here: link (1626 total)

    EDIT: It seems EVE-O forums breaks the google docs links for different sheets. Just open any of those and navigate to the correct sheet by hand (they are linked on the top of the page)