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 and IEC for Crucible 1.5 (now with DB conversions)
Author
Previous Topic Next Topic
Desmont McCallock
#1 - 2012-03-16 11:04:33 UTC
Static Data Export

IEC Types
IEC Renders
IEC Icons

Change Log:
-- CHANGED IN CRUCIBLE 1.5
-- invCategories.categoryID changed to int
-- invGroups.groupID changed to int
-- invGroups.categoryID changed to int
-- invTypes.groupID changed to int
-- mapDenormalize.groupID changed to int
-- ramAssemblyLineTypeDetailPerCategory.categoryID changed to int
-- ramAssemblyLineTypeDetailPerGroup.groupID changed to int

MySQL 5.5:
Steve Ronuken's version: mysql55-cru15.sql.bz2
Jercy's Fravowitz version: cru15-mysql5-v1.sql.bz2

PostgreSQL 9:
Jercy's Fravowitz version: cru15-pgsql-v1.sql.bz2

SQLite 3:
Jercy's Fravowitz version: cru15-sqlite3-v1.db.bz2
Notice: Not compatible with EAM.

For individual tables of the SDE you can find them at Steve Ronuken's dump folder.
Cyerus
University of Caille
Gallente Federation
#2 - 2012-03-17 12:25:31 UTC
Thanks!
Dern Morrow
Dreddit
Test Alliance Please Ignore
#3 - 2012-03-18 08:33:05 UTC  |  Edited by: Dern Morrow
FYI: The Steve Ronuken version of the MySQL dump seems incorrect. It contains the updated implant names, but it still has Scourge missiles and some other things that have been renamed. I'm not sure if anything else is incorrect, but I would consider this dump to be highly suspect at this point.

Edited: Awkwardly, Juicy's is also incorrect. I suppose the problem is CCP then. Dammit!
Desmont McCallock
#4 - 2012-03-18 08:35:58 UTC
Blame it on the buggy (SDE).
Golden Gnu
The Golden Gnu Corp
#5 - 2012-03-18 10:25:11 UTC
Desmont McCallock wrote:
Blame it on the buggy (SDE).

Guess we'll have to wait for Jercy Fravowitz v2 or CCP Sad

Thank you for compiling the list, though...

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-03-18 17:41:09 UTC
Golden Gnu wrote:
Desmont McCallock wrote:
Blame it on the buggy (SDE).

Guess we'll have to wait for Jercy Fravowitz v2 or CCP Sad

Thank you for compiling the list, though...



I'll be converting the next release too, now that I've ironed out the process. (It's for my own use, so so I don't need to wait for someone else Big smile)

Differences in typenames/ids are here:
http://www.fuzzwork.co.uk/resources/crucible11to15patch.txt

I've not done any other comparisons.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Golden Gnu
The Golden Gnu Corp
#7 - 2012-03-20 21:15:57 UTC
@Steve Ronuken
That is a long list Sad

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2012-03-21 09:52:14 UTC
Golden Gnu wrote:
@Steve Ronuken
That is a long list Sad



Well, they did rename all the implants Blink

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#9 - 2012-03-21 11:08:26 UTC
Offtopic: I liked the previous outfit. This T-Shirt looks good only on Karbowiak.