Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Althalus Stenory
Flying Blacksmiths
0
|
Posted - 2012.09.06 18:39:00 -
[1] - Quote
Hello there !
Do anyone know where I will able to find the whole relationships from the static data dump (inferno 1.2) ?
I'd like to use that data with an ORM (Doctrine 2 in my case), but my problem is that i can't find those relationships... I already used this one http://zofu.no-ip.de/inf12/work/update-innodb.sql but, as far as I can see when i'm looking into some tables, there are many and many relationships missing...
Of course, i'd be able to find them into the dump provided by CCP.. but i'm on a mac, so it's not possible...
Any ideas ?
Thanks !
Regards, Althalus
PS: sorry for my bad english :p |
Steve Ronuken
Fuzzwork Enterprises
619
|
Posted - 2012.09.06 19:19:00 -
[2] - Quote
Actually, the dump provided by CCP is pretty lacking in foreign key constraints.
The file you have is likely the work of someone determining the relationships by hand, and them implementing them.
As I despise ORMs (I'm a DBA. They might make a programmer's life easier, but they divorce them from having to understand how the DB fits together. and lead to bad designs/SQL), and it's a read only datasource, It's never bothered me. which is why you won't find the relationships added into my own conversions (I'm not leaving them out. They're not there in the first place)
You're going to have to put them together as you go, I'm afraid. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Althalus Stenory
Flying Blacksmiths
0
|
Posted - 2012.09.06 19:45:00 -
[3] - Quote
ow... well, let's go and try to fill at least the tables i need... thanks for your answer :) |
Vogue
RAND Punch and Judy Show
1
|
Posted - 2012.09.07 02:44:00 -
[4] - Quote
I found this pdf file that shows foreign keys for Tyrannis version data dump. I don't know how accurate it is.
http://www.filefactory.com/file/1o3p9swqfxg9/n/Tyrannis_SDD_FKs_pdf |
Althalus Stenory
Flying Blacksmiths
0
|
Posted - 2012.09.07 16:55:00 -
[5] - Quote
Thx.
I'm using this one too : http://wiki.eve-id.net/Category:CCP_DB_Tables which is not fully accurate, but at least, it gives me an idea x) |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |