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.
 

MySQL Datadump and Foreign Keys relationship
Author
Previous Topic Next Topic
Faith Sunstrider
#1 - 2011-10-27 22:52:13 UTC  |  Edited by: Faith Sunstrider
I'm working in migrating the data from the EVE static datadump to a MySQL database (for a small indy application that I'll begin to work in). Perfeccionist as I am, I got the foreign keys that came in the "ebs_DATADUMP.sql" file, added a few more that were missing (at least I thought that were missing) and got the following relationship:

create statements
image
(the image is kinda messed but at least is better than the one created by the Workbench)

The migration of data went without errors (no missing or invalid foreign keys or data in my small tests) but I'm asking to someone to see if the tables structure and relationships are OK (in my opinion they are, but a second opinion is always good).
So, any feedback on the table structure and relationship is appreciated. If anyone is interested I can upload the Insert statements as well (over 1gb decompressed and without extended inserts and a separated file for each table).
Tonto Auri
Vhero' Multipurpose Corp
#2 - 2011-10-28 14:25:47 UTC
Just grab MySQL version of SDD.
Foreign keys are not possible for many tables, because SDD is a slice of an actual EVE database.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison