EVE Technology Lab

We've got a new SDE up guys, get it while it's hot!

IMPORTANT NOTICE:
READ THIS OR YOU'LL GET ANGRY WHEN I MAKE FUN OF YOU FOR NOT HAVING READ THIS!
Now that I got your attention, reading this will also make you angry.
There is no iconID or graphicID in invTypes anymore. You will never find it there again. It has been moved into the types.YAML file we ship with the SDE zip file.
If you're using a third party conversion that does not include this data in one form or another that's your converter doing something wrong.
If you are doing a conversion and want this data back into a relationial database, you're going to have to get it from the YAML file.

Changelog:
invTypes:
Problem: table is missing the iconID column.
Solution: Get them, along with the graphicIDs, from types.YAML. They will not be found in the official backup.

eveUnits:
Problem: unitID 103, 122, 129 is missing.
Solution: These units do not have a display name, do include units without a display name.


dogmaTypeAttributes, dogmaAttributeTypes:
Problem: Missing slot attributes
Solution: Fixing eve units to include the units will retain the slot data rathre than sanitizing it out as a broken relation.

invMarketGroups, invTypes
Problem: Missing records.
Solution: These are unreleased DUST records which do not belong in the SDE.


ramTypeRequirements
Problem: Data Interfaces for invention have a damage per job of 1.
Solution: This is how the data is authored and always has been. Checked the history. I can't fix things that are by design.
Interfaces are special cased in our code. Maybe one day I get to rewrite the clusterintimacy that the S&I backend is.


invMarketGroups
Problem: Market groups exist with hasTypes = 0, but still have types. Market groups exist with hasTypes = 1 but have no types.
Solution: Check these relations and sanitize out bad data. I have no clue when GD will actually fix the data but at least I can fix your SDE