InvOreReprocessing

From EVEDev

CREATE TABLE invOreReprocessing(
 oreTypeID INTEGER,             -- ore typeID
 mineralTypeID INTEGER,         -- mineral typeID
 amountPerBatch INTEGER         -- amount of minerals per batch (invTypes.portionSize) of ore
);

-- Veldspar
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1230, 34, 1000 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17470, 34, 1050 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17471, 34, 1100 );

-- Scordite
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1228, 34, 833 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1228, 35, 416 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17463, 34, 875 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17463, 35, 437 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17464, 34, 916 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17464, 35, 458 );

-- Pyroxeres
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1224, 34, 844 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1224, 35, 59 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1224, 36, 120 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1224, 38, 11 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17459, 34, 886 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17459, 35, 62 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17459, 36, 126 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17459, 38, 12 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17460, 34, 928 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17460, 35, 65 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17460, 36, 132 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17460, 38, 12 );

-- Plagioclase
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 18, 34, 256 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 18, 35, 512 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 18, 36, 256 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17455, 34, 269 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17455, 35, 538 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17455, 36, 269 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17456, 34, 282 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17456, 35, 563 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17456, 36, 282 );

-- Omber
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1227, 34, 307 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1227, 35, 123 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1227, 37, 307 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17867, 34, 322 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17867, 35, 129 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17867, 37, 322 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17868, 34, 338 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17868, 35, 135 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17868, 37, 338 );

-- Kernite
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 20, 34, 386 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 20, 36, 773 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 20, 37, 386 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17452, 34, 405 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17452, 36, 812 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17452, 37, 405 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17453, 34, 425 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17453, 36, 850 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17453, 37, 425 );

-- Jaspet
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1226, 34, 259 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1226, 35, 259 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1226, 36, 518 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1226, 38, 259 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1226, 39, 8 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17448, 34, 272 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17448, 35, 272 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17448, 36, 544 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17448, 38, 272 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17448, 39, 8 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17449, 34, 285 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17449, 35, 285 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17449, 36, 570 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17449, 38, 285 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17449, 39, 9 );

-- Hemorphite
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1231, 34, 212 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1231, 37, 212 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1231, 38, 424 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1231, 39, 28 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17444, 34, 223 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17444, 37, 223 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17444, 38, 445 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17444, 39, 29 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17445, 34, 233 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17445, 37, 233 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17445, 38, 466 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17445, 39, 31 );

-- Hedbergite
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 21, 37, 708 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 21, 38, 354 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 21, 39, 32 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17440, 37, 743 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17440, 38, 372 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17440, 39, 34 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17441, 37, 779 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17441, 38, 389 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17441, 39, 35 );

-- Gneiss
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1229, 34, 171 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1229, 36, 171 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1229, 37, 343 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1229, 39, 171 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17865, 34, 180 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17865, 36, 180 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17865, 37, 360 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17865, 39, 180 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17866, 34, 188 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17866, 36, 188 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17866, 37, 377 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17866, 39, 188 );

-- Dark Ochre
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1232, 34, 250 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1232, 38, 500 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1232, 39, 250 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17436, 34, 263 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17436, 38, 525 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17436, 39, 263 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17437, 34, 275 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17437, 38, 550 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17437, 39, 275 );

-- Crokite
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1225, 34, 331 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1225, 38, 331 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1225, 39, 663 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17432, 34, 348 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17432, 38, 348 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17432, 39, 696 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17433, 34, 364 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17433, 38, 364 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17433, 39, 729 );

-- Spodumain
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 19, 34, 700 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 19, 35, 140 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 19, 40, 140 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17466, 34, 700 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17466, 35, 140 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17466, 40, 140 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17467, 34, 700 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17467, 35, 140 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17467, 40, 140 );

-- Bistot
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1223, 35, 170 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1223, 39, 341 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 1223, 40, 170 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17428, 35, 179 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17428, 39, 358 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17428, 40, 179 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17429, 35, 187 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17429, 39, 375 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17429, 40, 187 );

-- Arkonor
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 22, 34, 300 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 22, 39, 166 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 22, 40, 333 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17425, 34, 315 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17425, 39, 174 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17425, 40, 350 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17426, 34, 330 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17426, 39, 183 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17426, 40, 366 );

-- Mercoxit
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 11396, 11399, 530 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17869, 11399, 530 );
insert into invOreReprocessing( oreTypeID, mineralTypeID, amountPerBatch ) values ( 17870, 11399, 530 );