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.
123Next pageLast page
 

Crucible database dump

First post
Author
Previous Topic Next Topic
mancert
Federal Navy Academy
Gallente Federation
#1 - 2011-11-30 07:03:35 UTC
Anyone know when a dump of the database will be availeble?
TorTorden
Tors shibari party
#2 - 2011-11-30 10:59:53 UTC
It's out but only from ccp direct so no mysql version yet :S

http://www.eveonline.com/community/toolkit.asp
Desmont McCallock
#3 - 2011-11-30 11:47:37 UTC  |  Edited by: Desmont McCallock
Would be nice if it included the SQL script file.

Edit: The fact that the size of the SDD is half of any previous ones concerns me though.

Changes (possible breaking) found:
- agtConfig -> empty table ??? (edit: related data have been inserted in agtAgents table, which was about time)
- dgmAttributeTypes -> some attributeName values are NULL (intended?)
- eveNames -> renamed to invNames
- eveLocations -> removed
- eveOwners -> removed
- invPositions -> added
- invUniqueNames -> added
- translationLaguages -> added (typo error on table name - contains no data, should be removed)
- translationTables -> added
- trnTranslationLanguages -> added
- warCombatZoneSystems -> added
- warCombatZones -> added

Edit 2: cruc10-sqlite3-v.1.db.7z
Notice: Not compatible with EAM
Kekkekir
Order of the Domain
New Eden Foundation.
#4 - 2011-11-30 12:56:10 UTC
The dump seems to be available now here: http://www.eveonline.com/community/toolkit.asp
Just need someone to convert it to SQL now :Big smile
Arskaff
Perkone
Caldari State
#5 - 2011-11-30 18:46:08 UTC
Desmont McCallock wrote:

Changes (possible breaking) found:
- eveNames -> renamed to invNames
- eveLocations -> removed
- eveOwners -> removed
Edit 2: cruc10-sqlite3-v.1.db.7z


Thanx for the SQLite version.
About eveLocations and eveOwners: weren't those simply subsets of tables such as eveNames and invItems ?
mancert
Federal Navy Academy
Gallente Federation
#6 - 2011-11-30 19:07:54 UTC
Sweet, 'im currently uploading a mysql version to eve-files! I'll post again when it's there
KillMinusNine
Imperial Shipment
Amarr Empire
#7 - 2011-11-30 19:27:50 UTC
mancert
Federal Navy Academy
Gallente Federation
#8 - 2011-11-30 19:34:07 UTC  |  Edited by: mancert
Haha... i need has faster internet!

well here is the db i converted anyways!

New link soon, uploaded wrong db *blush*
Here is the correct one!
http://go-dl.eve-files.com/media/1112/crucible-1_0_57975.zip

Have fun!
Desmont McCallock
#9 - 2011-11-30 19:37:20 UTC
Arskaff wrote:
Desmont McCallock wrote:

Changes (possible breaking) found:
- eveNames -> renamed to invNames
- eveLocations -> removed
- eveOwners -> removed
Edit 2: cruc10-sqlite3-v.1.db.7z


Thanx for the SQLite version.
About eveLocations and eveOwners: weren't those simply subsets of tables such as eveNames and invItems ?


Yes and having them in SDD was doubling the file size. Praise they got rid of those tables.
Scrapyard Bob
EVE University
Ivy League
#10 - 2011-11-30 20:23:11 UTC
Crossing my fingers for a pgsql version.
TorTorden
Tors shibari party
#11 - 2011-11-30 20:26:32 UTC
Just as a warning been quick looking at the two conversions now and they are both with extended inserts, not a problem for me, since I don't bother with bigdump etc.
Luminocity
The Dark Revenants
PLEASE NOT VIOLENCE OUR BOATS
#12 - 2011-11-30 22:34:41 UTC  |  Edited by: Luminocity
I have not checked any other MySQL conversions at this point so they might be completely valid. But here is a version I created using the same approach as the one I did for the last Incarna dump. (among other things no extended inserts):

MySQL singlefile:
crucible1.0.57975-mysql5-v1.zip
Ruziel
Twilight Military Industrial Complex
#13 - 2011-12-01 02:50:08 UTC
One more mysql conversion for the pile:
cru100-mysql5-v1.zip

Used the same scripts that Jercy used for all his previous conversions.
CCP Prism X
C C P
C C P Alliance
#14 - 2011-12-01 08:50:33 UTC
There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay.

Terribly sorry, will get the ball rolling on this ASAP.

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Cyerus
University of Caille
Gallente Federation
#15 - 2011-12-02 01:34:52 UTC
CCP Prims X:
Once these issues are fixed, would you mind making a sticky topic will all the conversions?
Zifrian
The Frog Pond
Ribbit.
#16 - 2011-12-02 02:27:22 UTC
CCP Prism X wrote:
There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay.

Terribly sorry, will get the ball rolling on this ASAP.

So the current download has errors? Or am I misreading?

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
CCP Prism X
C C P
C C P Alliance
#17 - 2011-12-02 08:46:02 UTC
It currently has errors.

SELECT *
FROM dbo.agtAgents
WHERE locationID < 60000000

Will show you that all agents in space have locationIDs of stations (Because we all know that the only valid locations for agents are stations and solar systems so that anything below 60Mils must be located in systems!). It's because of a change in our internal processes with how we treat NPC Characters VS Player Characters and how that static data is copied around our servers. It has been fixed internally and I'm tryingto push for its (SDEs) regeneration and deployment but people are just very busy these post-expansion-deployment-days.

P.S. I am very disappointed in these forums forcing me to break our SQL coding standards! Evil

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Pizzutz
Aliastra
Gallente Federation
#18 - 2011-12-02 11:39:01 UTC
Will we be getting an updated invControlTowerResources table when the fuel block switchover happens, or will the fuel resources be managed a different way?
Celebrain
Aliastra
Gallente Federation
#19 - 2011-12-02 20:37:44 UTC  |  Edited by: Celebrain
I've been using the eveOwners table to detect and display the bloodline (and therefore race too) of each individual agent. You can see an example here: http://www.eveiverse.com/agents/akinoma_nimpalius

Another side effect of losing bloodline info is that I can no longer generate IGB eve info popup urls for these agents any longer... since they are all encoded, both for player characters and npc characters with a typeID that represents each bloodline. So that will be very frustrating too, and potentially a really big functionality problem. :(

Please, if you are able, either restore that table, or add a new column with this info to the agtAgents table, just like you did for the isLocator column when you removed the agtConfig table. Otherwise my site will have to lose data and functionality that some people may have found interesting and/or useful.

Of course adding gender and ancestry would be cool too, but losing data is more painful than not adding new cool stuff.

Cele
TorTorden
Tors shibari party
#20 - 2011-12-03 16:46:28 UTC
Any ETA on the non bugged datadump or is it out already ?
123Next pageLast page