MapSolarSystemOreBySecurityClass

From EVEDev
Jump to: navigation, search

A direct listing of the ore in each solar system security class. Can JOIN to mapSolarSystems.securityClass or Minerals distribution per solar systems .

Thanks to the author(s) of the SQL script from Minerals distribution per solar systems and to DPSLogistics Mike. Forum thread.


 
-- Example: lists all solar systems in the Heimatar region that contain Kernite, sorted by Solar System name.
 
SELECT solarSystemName, regionName, [security], securityClass, Kernite
FROM dbo.mapSolarSystems
LEFT JOIN dbo.mapSolarSystemOreBySecurityClass   
   ON dbo.mapSolarSystems.securityClass = dbo.mapSolarSystemOreBySecurityClass.systemSecurityClass
LEFT JOIN dbo.mapRegions 
   ON dbo.mapSolarSystems.regionID = dbo.mapRegions.regionID
WHERE regionName = 'Heimatar' AND Kernite = 1
ORDER BY solarSystemName ASC
 
 
 
==Results==
Solar System  Region    Security          SecurityClass Kernite
Amamake	      Heimatar	0.438761248111324	E  	1
Aralgrund     Heimatar	0.32155892279011	E	1
Auga	      Heimatar	0.385483820575927	E	1
Auren	      Heimatar	0.417912735957386	E	1
Bogelek	      Heimatar	0.366370106635096	E	1
Bosboger      Heimatar	0.324581804745487	E	1
Bundindus     Heimatar	0.428685119677998	E	1
Dal	      Heimatar	0.411359588988721	E	1
Ebodold	      Heimatar	0.444631549618515	E	1
Eifer	      Heimatar	0.444525116010234	E	1
Gulmorogod    Heimatar	0.37679403765006	E	1
Gultratren    Heimatar	0.309275657216791	E	1
Gusandall     Heimatar	0.3765845900301	        E	1
Hedgiviter    Heimatar	0.415673344457106	E	1
Hrondedir     Heimatar	0.317423558183467	E	1
Hrondmund     Heimatar	0.358803899742933	E	1
Ingunn	      Heimatar	0.276795663484686	E	1
Katugumur     Heimatar	0.171291398171212	E1	1
Lantorn	      Heimatar	0.33948597391556	E	1
Lulm	      Heimatar	0.34397383105912	E	1
Olfeim	      Heimatar	0.438684256330258	E	1
Siseide	      Heimatar	0.338351102747753	E	1
Sotrenzur     Heimatar	0.275969978954567	E	1
Vard	      Heimatar	0.379095938438127	E	1
Wiskeber      Heimatar	0.40443614610229	E	1
 


 
 
-- Define True / False value for each ore type in each Solar System security Class
 
CREATE TABLE dbo.mapSolarSystemOreBySecurityClass(
systemSecurityClass CHAR(2), 
Veldspar BIT, 
Scordite BIT, 
Pyroxeres BIT, 
Plagioclase BIT, 
Omber BIT, 
Kernite BIT, 
Jaspet BIT, 
Hemorphite BIT, 
Hedbergite BIT, 
Gneiss BIT, 
DarkOchre BIT, 
Spodumain BIT, 
Crokite BIT, 
Bistot BIT, 
Arkanor BIT, 
Mercoxit BIT
);
 
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('A',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('B',1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('B1',1,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('B2',1,1,1,0,0,1,1,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('B3',1,1,1,0,0,1,1,1,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('C',1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
('C1',1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'C2',1,1,1,1,0,1,0,0,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'D',1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'D1',1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'D2',1,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'D3',1,1,0,1,1,0,1,1,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'E',1,1,0,1,1,1,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'E1',1,1,0,1,1,1,0,0,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F',1,1,0,0,1,0,0,1,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F1',1,1,0,0,1,0,0,1,1,0,0,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F2',1,1,0,0,1,0,0,1,1,1,0,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F3',1,1,0,0,1,0,0,1,1,1,0,1,0,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F4',1,1,0,0,1,0,0,1,1,1,0,1,0,1,1,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F5',1,1,1,0,1,0,0,1,1,1,0,1,0,1,1,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F6',1,1,1,0,1,0,0,1,1,1,0,1,0,1,1,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'F7',1,1,1,1,1,0,0,1,1,1,0,1,0,1,1,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G',1,1,0,1,1,1,0,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G1',1,1,0,1,1,1,0,0,0,1,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G2',1,1,1,1,1,1,0,0,0,1,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G3',1,1,1,1,1,1,0,0,0,1,0,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G4',1,1,1,1,1,1,0,0,0,1,0,1,0,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G5',1,1,1,1,1,1,0,0,0,1,0,1,1,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G6',1,1,1,1,1,1,0,0,0,1,0,1,1,1,0,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'G7',1,1,1,1,1,1,0,0,0,1,1,1,1,1,0,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H',1,1,1,0,0,0,1,1,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H1',1,1,1,0,0,0,1,1,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H2',1,1,1,0,0,0,1,1,1,0,1,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H3',1,1,1,0,0,1,1,1,1,0,1,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H4',1,1,1,0,0,1,1,1,1,0,1,0,1,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H5',1,1,1,0,0,1,1,1,1,0,1,1,1,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H6',1,1,1,0,0,1,1,1,1,0,1,1,1,0,0,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'H7',1,1,1,0,0,1,1,1,1,0,1,1,1,0,1,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I',1,1,0,0,1,0,0,1,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I1',1,1,0,0,1,0,1,1,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I2',1,1,0,0,1,0,1,1,1,0,0,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I3',1,1,0,0,1,0,1,1,1,1,0,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I4',1,1,0,0,1,0,1,1,1,1,1,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I5',1,1,0,0,1,0,1,1,1,1,1,1,0,0,1,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I6',1,1,0,0,1,0,1,1,1,1,1,1,0,0,1,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'I7',1,1,0,0,1,1,1,1,1,1,1,1,0,0,1,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J',1,1,1,1,0,0,1,0,0,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J1',1,1,1,1,0,0,1,0,0,0,1,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J2',1,1,1,1,0,0,1,0,0,0,1,0,1,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J3',1,1,1,1,0,0,1,0,0,0,1,0,1,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J4',1,1,1,1,0,0,1,1,0,0,1,0,1,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J5',1,1,1,1,0,0,1,1,1,0,1,0,1,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J6',1,1,1,1,0,0,1,1,1,0,1,0,1,1,0,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'J7',1,1,1,1,0,0,1,1,1,0,1,0,1,1,0,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K',1,1,0,0,1,0,0,1,1,0,0,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K1',1,1,0,0,1,0,0,1,1,0,1,0,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K2',1,1,0,0,1,0,0,1,1,0,1,1,0,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K3',1,1,0,0,1,0,0,1,1,0,1,1,1,0,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K4',1,1,0,0,1,0,0,1,1,0,1,1,1,1,0,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K5',1,1,0,0,1,0,0,1,1,0,1,1,1,1,1,0 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K6',1,1,0,0,1,0,0,1,1,0,1,1,1,1,1,1 );
 
INSERT INTO mapSolarSystemOreBySecurityClass( systemSecurityClass, Veldspar, Scordite, 
Pyroxeres, Plagioclase, Omber, Kernite, Jaspet, Hemorphite, Hedbergite, Gneiss, DarkOchre, 
Spodumain, Crokite, Bistot, Arkanor, Mercoxit ) VALUES 
( 'K7',1,1,0,0,1,0,0,1,1,1,1,1,1,1,1,1 );
 
 
Personal tools