Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
SabuMaru ICE
DLM Enterprises Coalition of the Unfortunate
6
|
Posted - 2015.04.23 13:02:51 -
[1] - Quote
Hi All,
I am trying to create a database with all the items and the relations between the tables i notice that a lot of tables are hard or almost impossible to find / create
fuzzyworks has helped me a lot so far, but i am still missing a lot of the tables and their content
is there any way someone has a full BAK of the complete database
thanx in advance, |
salacious necrosis
Federal Defense Union Gallente Federation
13
|
Posted - 2015.04.23 13:26:49 -
[2] - Quote
SabuMaru ICE wrote:Hi All,
I am trying to create a database with all the items and the relations between the tables i notice that a lot of tables are hard or almost impossible to find / create
fuzzyworks has helped me a lot so far, but i am still missing a lot of the tables and their content
is there any way someone has a full BAK of the complete database
thanx in advance,
Steve should comment here, but I don't believe he's deleting any foreign key relations that already exist in the raw SDE dump. So if it's not in Steve's version, it's not in the original, which means you'd have to add it yourself.
A year or so ago I implemented most of these in a Hibernate layer. I can dig that up if you're interested. I didn't spend a lot of time optimizing by adding the appropriate foreign keys in the DB, so some of the joins may perform poorly.
For example, here's what the header of my InvTypes class looks like:
Quote:@Entity @Table(name = "invtypes") public class InvTypes implements IInvTypes { @Id private int typeID; private Integer groupID; private String typeName; private String description; private double mass; private double volume; private double capacity; private int portionSize; private Integer raceID; private double basePrice; private boolean published; private Integer marketGroupID; private double chanceOfDuplicating; private Integer graphicID; private Double radius; private Integer iconID; private Integer soundID; private Integer factionID; private String sofDnaAddition; private String sofFactionName;
// Referrals to other tables @ManyToOne(optional = true, targetEntity = InvGroups.class) @JoinColumn(name = "groupID", insertable = false, updatable = false) private InvGroups groupIDObject; @ManyToOne(optional = true, targetEntity = EveGraphics.class) @JoinColumn(name = "graphicID", insertable = false, updatable = false) private EveGraphics graphicIDObject; @ManyToOne(optional = true, targetEntity = InvMarketGroups.class) @JoinColumn(name = "marketGroupID", insertable = false, updatable = false) private InvMarketGroups marketGroupIDObject; @ManyToOne(optional = true, targetEntity = EveIcons.class) @JoinColumn(name = "iconID", insertable = false, updatable = false) private EveIcons iconIDObject;
...
Not sure if this is what you're looking for.
EveKit - your EVE data on the web!
|
SabuMaru ICE
DLM Enterprises Coalition of the Unfortunate
6
|
Posted - 2015.04.23 13:53:02 -
[3] - Quote
Thanks for the quick response
bellow a list of the tables i have so far... missing invBlueprintTypes forinstance and can't figure out how to get it
Quote: TABLE NAME# Records agtAgentTypes12 agtAgents10975 agtResearchAgents797 chrAncestries42 chrAttributes5 chrBloodlines15 chrFactions20 chrRaces8 crpActivities20 crpNPCCorporationDivisions380 crpNPCCorporationResearchFields48 crpNPCCorporationTrades17923 crpNPCCorporations234 crpNPCDivisions29 dgmAttributeCategories27 dgmAttributeTypes1799 dgmEffects3580 dgmExpressions17235 dgmTypeAttributes156071 dgmTypeEffects36515 eveUnits57 industryActivity13428 industryActivityMaterials22280 industryActivityProbabilities1034 industryActivityProducts4163 industryActivitySkills16314 industryBlueprints3219 invCategories39 invContrabandTypes426 invControlTowerResourcePurposes4 invControlTowerResources339 invFlags133 invGroups998 invItems531412 invMarketGroups1774 invMetaGroups14 invMetaTypes4171 invNames519863 invPositions508331 invTypeMaterials33364 invTypeReactions372 invTypes22531 invUniqueNames365405 mapRegions99 mapSolarSystems0 mapUniverse2 planetSchematics68 planetSchematicsPinMap496 planetSchematicsTypeMap203 ramActivities9 ramAssemblyLineStations4393 ramAssemblyLineTypeDetailPerCategory666 ramAssemblyLineTypeDetailPerGroup1844 ramAssemblyLineTypes134 ramInstallationTypeContents362 staOperationServices795 staOperations55 staServices27 staStationTypes69 staStations5185 translationTables32 trnTranslationColumns32 trnTranslationLanguages8 trnTranslations293088 warCombatZoneSystems171 warCombatZones4
|
Mr Mac
Dark Goliath
50
|
Posted - 2015.04.23 14:08:24 -
[4] - Quote
SabuMaru ICE wrote:Thanks for the quick response
bellow a list of the tables i have so far... missing invBlueprintTypes forinstance and can't figure out how to get it
No such table in Scylla SDE but there is blueprints.yaml |
SabuMaru ICE
DLM Enterprises Coalition of the Unfortunate
6
|
Posted - 2015.04.23 14:22:57 -
[5] - Quote
/Mr Mac wrote:SabuMaru ICE wrote:Thanks for the quick response
bellow a list of the tables i have so far... missing invBlueprintTypes forinstance and can't figure out how to get it
No such table in Scylla SDE but there is blueprints.yaml
indeed..but i have no experience in changing into an MS-SQL acceptable format noone have a link to the converted YAML files so i can just use it ? |
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1629
|
Posted - 2015.04.24 11:25:30 -
[6] - Quote
SabuMaru ICE wrote:/ Mr Mac wrote:SabuMaru ICE wrote:Thanks for the quick response
bellow a list of the tables i have so far... missing invBlueprintTypes forinstance and can't figure out how to get it
No such table in Scylla SDE but there is blueprints.yaml indeed..but i have no experience in changing into an MS-SQL acceptable format noone have a link to the converted YAML files so i can just use it ? Steve does all of these conversions. I built my own importer. Desmont McCallock has built a tool to build the full ms-sql version from the SDE files if you want that.
Also, the universe tables are in the SQLite file that comes with the SDE download. Again, Steve/Desmont has those in their conversions as well.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5194
|
Posted - 2015.04.24 12:01:45 -
[7] - Quote
First:
CCP don't have the foreign key relationships. They don't actually use them on static data. (after all, they're there for consistency. On static data, that's not a concern. There's no benefit to having them, and they just take up space(minimal, but still some))
The database exports from my site do not have anything removed from them. The process is: Convert the sqlite universe data to mysql convert the MS-SQL data to mysql create a few new tables and import some of the data from the yaml into them. (Not all, because the importing requires me to write a script to manage each bit (and possibly new tables. I prefer not to change the ones from CCP themselves). If I haven't written one yet, I've not needed it, and I've not been specifically asked for that data yet)
invBlueprintTypes, for example, is an old table. It no longer exists, as CCP have dropped it. However, all the blueprint data has been loaded into the industry* tables.
If there are specific things you're looking for, feel free to ask here, or send me an evemail.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Hel O'Ween
Men On A Mission
115
|
Posted - 2015.04.24 16:24:44 -
[8] - Quote
Zifrian wrote: Desmont McCallock has built a tool to build the full ms-sql version from the SDE files if you want that.
Here's the link to Desmont's much appreciated tool: https://forums.eveonline.com/default.aspx?g=posts&t=324435
EVEWalletAware - an offline wallet manager.
|
SabuMaru ICE
DLM Enterprises Coalition of the Unfortunate
6
|
Posted - 2015.04.29 09:53:01 -
[9] - Quote
Thanx All
some of the info out there is outdated.. especially the "landscape" picture of how the relations are |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |