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.
 

"correct" "typeBuildReqs" denormalized table (for reference)
Author
Previous Topic Next Topic
Enst Smath
Smath and Balt Holding Corporation
#1 - 2013-09-18 00:43:33 UTC
Would some kind soul please post/link a copy of his/her "typeBuildReqs"* table for Odyssey 1.1-91288?

I'm not being lazy; quite the contrary. I'm trying to debug my SQL scripts, and I keep getting different results using MySQL versus SQL Server vs Microsoft Access, and now I have no idea which one is correct (the same query [corrected for SQL flavor] keeps giving different row counts).

I promise to post all three versions here or in a pastebin when I can get them to consistently agree.

* I use this table name because it seems to be pretty common for a lot of the example code that's out there. What I mean is the denormalized manufacturing requirements (and reprocessing) table for T1/T2 based on ramRequirements etc. And yes I'm aware of the implications of using a denormalized table.

Thanks.