-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathStarField.sql
263 lines (256 loc) · 13 KB
/
StarField.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
CREATE TABLE families (
ID INT PRIMARY KEY,
family VARCHAR(30),
common VARCHAR(20),
uncommon VARCHAR(20),
rare VARCHAR(20),
exotic VARCHAR(20),
`unique` VARCHAR(20)
);
INSERT INTO families (ID, family, common, uncommon, rare, exotic, `unique`) VALUES
(0, 'Aluminum family', 'Aluminum', 'Beryllium', 'Neodymium', 'Europium', 'Indicite'),
(1, 'Argon family', 'Argon', 'Benzenes', 'Carboxylic Acids', 'Neon', 'Veryl'),
(2, 'Chlorine, Caesium subfamily', 'Chlorine', 'Chlorosilanes', 'Lithium', 'Caesium', NULL),
(3, 'Chlorine, Xenon subfamily', 'Chlorine', 'Chlorosilanes', 'Lithium', 'Xenon', 'Aldumite'),
(4, 'Copper, Fluorine subfamily', 'Copper', 'Fluorine', 'Tetrafluorides', 'Ionic Liquids', NULL),
(5, 'Copper, Gold subfamily', 'Copper', 'Fluorine', 'Gold', 'Antimony', NULL),
(6, 'Iron family', 'Iron', 'Alkanes', 'Tantalum', 'Ytterbium', 'Rothicite'),
(7, 'Lead, Silver subfamily', 'Lead', 'Silver', 'Mercury', NULL, NULL),
(8, 'Lead, Tungsten subfamily', 'Lead', 'Tungsten', 'Titanium', 'Dysprosium', NULL),
(9, 'Nickel family', 'Nickel', 'Cobalt', 'Platinum', 'Palladium', 'Tasine'),
(10, 'Uranium family', 'Uranium', 'Iridium', 'Vanadium', 'Plutonium', 'Vytinium');
CREATE TABLE inorganic (
Name VARCHAR(50),
Weight DECIMAL(5, 2),
Cost INTEGER,
Symbol VARCHAR(10),
Rarity INTEGER,
State VARCHAR(10),
RefID VARCHAR(10) PRIMARY KEY
);
INSERT INTO inorganic (Name, Weight, Cost, Symbol, Rarity, State, RefID)
VALUES ('Aldumite', 1.9, 84, 'Ad', 4, 'Solid', '0x00005DEC'),
('Alkanes', 0.6, 13, 'HnCn', 1, 'Gas', '0x00005570'),
('Aluminum', 0.5, 7, 'Al', 0, 'Solid', '0x0000557D'),
('Antimony', 0.8, 30, 'Sb', 3, 'Solid', '0x0000557B'),
('Aqueous Hematite', NULL, NULL, NULL, NULL, 'Solid', NULL),
('Argon', 0.5, 5, 'Ar', 0, 'Gas', '0x00005588'),
('Benzene', 0.6, 19, 'C6H6', 1, 'Gas', '0x00005585'),
('Beryllium', 0.5, 12, 'Be', 1, 'Solid', '0x000057D9'),
('Caelumite', 0.3, 264, 'Ct', 3, 'Solid', '0x000788D6'),
('Caesium', 0.8, 25, 'Cs', 3, 'Liquid', '0x000057DF'),
('Carboxylic Acids', 0.8, 12, 'R-COOH', 2, 'Liquid', '0x00005586'),
('Chlorine', 0.5, 6, 'Cl', 0, 'Gas', '0x0000557C'),
('Chlorosilanes', 0.6, 14, 'SiH3Cl', 1, 'Liquid', '0x0000557E'),
('Cobalt', 0.6, 12, 'Co', 1, 'Solid', '0x00005575'),
('Copper', 0.6, 10, 'Cu', 0, 'Solid', '0x00005576'),
('Dysprosium', 1.4, 56, 'Dy', 3, 'Solid', '0x00005569'),
('Europium', 1.0, 40, 'Eu', 3, 'Solid', '0x000057E1'),
('Fluorine', 0.5, 12, 'F', 1, 'Gas', '0x00005577'),
('Gold', 0.8, 24, 'Au', 2, 'Solid', '0x00005579'),
('Helium-3', 0.5, 5, 'He-3', 0, 'Gas', '0x0000558E'),
('Indicite', 2.3, 108, 'Ie', 4, 'Solid', '0x0004BA37'),
('Ionic Liquids', 0.8, 23, 'IL', 3, 'Liquid', '0x0000557A'),
('Iridium', 0.7, 14, 'Ir', 1, 'Solid', '0x0000558A'),
('Iron', 0.6, 8, 'Fe', 0, 'Solid', '0x0000556E'),
('Lead', 0.7, 10, 'Pb', 0, 'Solid', '0x00005568'),
('Lithium', 0.5, 14, 'Li', 2, 'Solid', '0x0000557F'),
('Mercury', 0.8, 22, 'Hg', 2, 'Liquid', '0x0027C4A1'),
('Neodymium', 0.8, 20, 'Nd', 2, 'Solid', '0x00005580'),
('Neon', 0.5, 16, 'Ne', 3, 'Gas', '0x00005587'),
('Nickel', 0.6, 10, 'Ni', 0, 'Solid', '0x00005572'),
('Palladium', 0.7, 25, 'Pd', 3, 'Solid', '0x00005574'),
('Platinum', 0.8, 24, 'Pt', 2, 'Solid', '0x00005573'),
('Plutonium', 1.6, 64, 'Pu', 3, 'Solid', '0x0000558C'),
('Rothicite', 2.2, 106, 'Rc', 4, 'Solid', '0x000028DF'),
('Silver', 0.6, 20, 'Ag', 1, 'Solid', '0x0000556A'),
('Tantalum', 0.9, 23, 'Ta', 2, 'Solid', '0x0000556F'),
('Tasine', 1.2, 52, 'Tsn', 4, 'Liquid', '0x00005DED'),
('Tetrafluorides', 0.7, 18, 'xF4', 2, 'Gas', '0x00005578'),
('Titanium', 0.5, 12, 'Ti', 2, 'Solid', '0x0000556D'),
('Tungsten', 0.7, 16, 'W', 1, 'Solid', '0x0000556B'),
('Uranium', 0.7, 14, 'U', 0, 'Solid', '0x00005589'),
('Vanadium', 0.7, 24, 'V', 2, 'Solid', '0x0000558B'),
('Veryl', 0.9, 40, 'Vr', 4, 'Gas', '0x00005DEE'),
('Vytinium', 2.5, 116, 'Vy', 4, 'Solid', '0x00005DEF'),
('Water', 0.5, 4, 'H2O', 0, 'Liquid', '0x00005591'),
('Xenon', 0.8, 27, 'Xe', 3, 'Gas', '0x000057DD'),
('Ytterbium', 1.2, 38, 'Yb', 3, 'Solid', '0x00005571'),
('Aqueous Hematite', 1.3, 56, 'Aq', 4, 'Solid', '0x0029D022');
-- Create the OrganicItems table
CREATE TABLE organic (
Name VARCHAR(255),
Weight DECIMAL(5,2),
Cost INT,
Rarity INT,
RefID VARCHAR(10) PRIMARY KEY
);
-- Insert data into the OrganicItems table
INSERT INTO organic (Name, Weight, Cost, Rarity, RefID) VALUES
('Adhesive', 0.5, 12, 2, '0x000055B1'),
('Amino Acids', 0.5, 10, 2, '0x000055CD'),
('Analgesic', 0.5, 12, 2, '0x000055A9'),
('Antimicrobial', 0.5, 10, 1, '0x000055AB'),
('Aromatic', 0.5, 11, 2, '0x002612B3'),
('Biosuppressant', 0.5, 16, 3, '0x000055B2'),
('Cosmetic', 0.5, 8, 1, '0x000055A8'),
('Fiber', 0.5, 4, 0, '0x000055AF'),
('Gastronomic Delight', 1.5, 66, 4, '0x0000559D'),
('Hallucinogen', 0.5, 14, 2, '0x0029F405'),
('High-Tensile Spidroin', 1.3, 62, 4, '0x000055AA'),
('Immunostimulant', 1.3, 58, 4, '0x000055B3'),
('Lubricant', 0.5, 18, 3, '0x000055BA'),
('Luxury Textile', 1.5, 58, 4, '0x0000559E'),
('Membrane', 0.5, 9, 1, '0x000055B0'),
('Memory Substrate', 1.4, 65, 4, '0x0000559B'),
('Metabolic Agent', 0.5, 9, 0, '0x0029F3FC'),
('Neurologic', 1.4, 67, 4, '0x0029F409'),
('Nutrient', 0.5, 5, 0, '0x000777FD'),
('Ornamental Material', 0.5, 11, 1, '0x000055A7'),
('Pigment', 0.5, 10, 1, '0x0029F400'),
('Polymer', 0.5, 20, 3, '0x000055A6'),
('Sealant', 0.5, 6, 0, '0x000055CC'),
('Sedative', 0.5, 12, 2, '0x000055AD'),
('Solvent', 0.5, 19, 3, '0x000055CE'),
('Spice', 0.5, 11, 1, '0x000055AC'),
('Stimulant', 0.5, 20, 3, '0x000055AE'),
('Structural', 0.5, 7, 0, '0x000055B9'),
('Toxin', 0.5, 8, 0, '0x000055B7');
CREATE TABLE manufactured (
Name VARCHAR(50),
Weight DECIMAL(5, 2),
Cost INTEGER,
Rarity INTEGER,
RefID VARCHAR(10) PRIMARY KEY
);
INSERT INTO manufactured (Name, Weight, Cost, Rarity, RefID) VALUES
('Adaptive Frame', 1.60, 24, 0, '0x00246B6A'),
('Aldumite Drilling Rig', 7.00, 421, 4, '0x00202F5A'),
('Austenitic Manifold', 4.30, 79, 1, '0x00246B7C'),
('Comm Relay', 3.50, 117, 1, '0x00246B64'),
('Control Rod', 4.50, 180, 3, '0x00246B7B'),
('Drilling Rig', 5.00, 143, 2, '0x0020A02F'),
('Indicite Wafer', 4.00, 243, 4, '0x00203EB4'),
('Isocentered Magnet', 1.80, 36, 0, '0x00246B77'),
('Isotopic Coolant', 0.80, 25, 0, '0x00246B76'),
('Mag Pressure Tank', 1.50, 25, 1, '0x00246B70'),
('Microsecond Regulator', 4.30, 212, 3, '0x00246B5F'),
('Molecular Sieve', 3.00, 91, 2, '0x00246B75'),
('Monopropellant', 3.50, 76, 1, '0x00246B74'),
('Nuclear Fuel Rod', 5.00, 225, 3, '0x00246B79'),
('Paramagnon Conductor', 4.00, 153, 2, '0x00246B73'),
('Polytextile', 2.00, 25, 1, '0x00246B72'),
('Positron Battery', 3.00, 133, 2, '0x00246B71'),
('Power Circuit', 3.80, 195, 3, '0x00246B5C'),
('Reactive Gauge', 1.50, 25, 0, '0x00246B6F'),
('Rothicite Magnet', 4.60, 295, 4, '0x00203EB2'),
('Semimetal Wafer', 3.50, 149, 2, '0x00246B6D'),
('Sterile Nanotubes', 3.00, 130, 3, '0x00246B6C'),
('Substrate Molecular Sieve', 4.50, 274, 4, '0x00202782'),
('Supercooled Magnet', 3.20, 111, 2, '0x00246B69'),
('Tasine Superconductor', 5.00, 299, 4, '0x00203EAF'),
('Tau Grade Rheostat', 2.60, 82, 1, '0x00246B68'),
('Veryl-Treated Manifold', 5.40, 295, 4, '0x00203EB0'),
('Vytinium Fuel Rod', 11.00, 836, 4, '0x00203EB3'),
('Zero Wire', 1.70, 52, 0, '0x00246B65'),
('Zero-G Gimbal', 2.80, 93, 2, '0x00246B66');
CREATE TABLE recipes (
Output VARCHAR(50),
Fabricator VARCHAR(20),
Requirement1_Num INTEGER,
Requirement1_Desc VARCHAR(50),
Requirement2_Num INTEGER,
Requirement2_Desc VARCHAR(50),
Requirement3_Num INTEGER,
Requirement3_Desc VARCHAR(50),
Requirement4_Num INTEGER,
Requirement4_Desc VARCHAR(50)
);
INSERT INTO recipes (
Output, Fabricator,
Requirement1_Num, Requirement1_Desc,
Requirement2_Num, Requirement2_Desc,
Requirement3_Num, Requirement3_Desc,
Requirement4_Num, Requirement4_Desc
) VALUES
('Adaptive Frame', 'simple', 1, 'Iron', 1, 'Aluminum', NULL, NULL, NULL, NULL),
('Zero Wire', 'simple', 1, 'Silver', 1, 'Copper', NULL, NULL, NULL, NULL),
('Tau Grade Rheostat', 'simple', 1, 'Beryllium', 1, 'Copper', NULL, NULL, NULL, NULL),
('Reactive Gauge', 'simple', 1, 'Copper', 2, 'Aluminum', NULL, NULL, NULL, NULL),
('Polytextile', 'simple', 1, 'Cosmetic', 2, 'Fiber', NULL, NULL, NULL, NULL),
('Monopropellant', 'simple', 1, 'Reactive Gauge', 2, 'Alkanes', 1, 'Mag Pressure Tank', NULL, NULL),
('Mag Pressure Tank', 'simple', 1, 'Nickel', 2, 'Aluminum', NULL, NULL, NULL, NULL),
('Isotopic Coolant', 'simple', 1, 'Ionic Liquids', 1, 'Tetrafluorides', NULL, NULL, NULL, NULL),
('Isocentered Magnet', 'simple', 1, 'Cobalt', 1, 'Nickel', NULL, NULL, NULL, NULL),
('Comm Relay', 'simple', 1, 'Tau Grade Rheostat', 1, 'Isocentered Magnet', NULL, NULL, NULL, NULL),
('Austenitic Manifold', 'simple', 1, 'Iron', 1, 'Reactive Gauge', 1, 'Nickel', NULL, NULL),
('Control Rod', 'compound', 1, 'Isotopic Coolant', 3, 'Dysprosium', 1, 'Austenitic Manifold', NULL, NULL),
('Zero-G Gimbal', 'compound', 2, 'Lubricant', 1, 'Isocentered Magnet', 2, 'Tantalum', NULL, NULL),
('Supercooled Magnet', 'compound', 1, 'Isotopic Coolant', 1, 'Isocentered Magnet', 3, 'Neodymium', NULL, NULL),
('Sterile Nanotubes', 'compound', 2, 'Vanadium', 1, 'Molecular Sieve', 2, 'Solvent', NULL, NULL),
('Semimetal Wafer', 'compound', 2, 'Antimony', 1, 'Zero Wire', 2, 'Gold', NULL, NULL),
('Positron Battery', 'compound', 1, 'Tau Grade Rheostat', 2, 'Antimony', 2, 'Vanadium', NULL, NULL),
('Paramagnon Conductor', 'compound', 1, 'Neodymium', 3, 'Zero Wire', 1, 'Gold', NULL, NULL),
('Nuclear Fuel Rod', 'compound', 3, 'Uranium', 2, 'Solvent', 1, 'Semimetal Wafer', NULL, NULL),
('Molecular Sieve', 'compound', 2, 'Ionic Liquids', 2, 'Membrane', 1, 'Mag Pressure Tank', NULL, NULL),
('Drilling Rig', 'compound', 2, 'Lubricant', 1, 'Reactive Gauge', 3, 'Tungsten', NULL, NULL),
('Aldumite Drilling Rig', 'Multiplex', 1, 'Drilling Rig', 1, 'Microsecond Regulator', 2, 'Caesium', 4, 'Aldumite'),
('Vytinium Fuel Rod', 'Multiplex', 2, 'Plutonium', 4, 'Vytinium', 1, 'Indicite Wafer', 1, 'Nuclear Fuel Rod'),
('Veryl-Treated Manifold', 'Multiplex', 1, 'Austenitic Manifold', 4, 'Veryl', 2, 'Lubricant', 2, 'Ytterbium'),
('Tasine Superconductor', 'Multiplex', 2, 'Polymer', 2, 'Palladium', 4, 'Tasine', 1, 'Paramagnon Conductor'),
('Substrate Molecular Sieve', 'Multiplex', 2, 'Sterile Nanotubes', 1, 'Molecular Sieve', 3, 'Memory Substrate', 2, 'Biosuppressant'),
('Rothicite Magnet', 'Multiplex', 1, 'Semimetal Wafer', 2, 'Lithium', 1, 'Supercooled Magnet', 4, 'Rothicite'),
('Power Circuit', 'Multiplex', 1, 'Positron Battery', 2, 'Polymer', 4, 'Palladium', 1, 'Paramagnon Conductor'),
('Microsecond Regulator', 'Multiplex', 2, 'Lithium', 4, 'Europium', 1, 'Supercooled Magnet', 1, 'Tau Grade Rheostat'),
('Indicite Wafer', 'Multiplex', 1, 'Semimetal Wafer', 4, 'Indicite', 2, 'Caesium', 2, 'Solvent');
CREATE TABLE fabricators (
Output VARCHAR(50),
Fabricator VARCHAR(20),
Requirement1_Num INTEGER,
Requirement1_Desc VARCHAR(50),
Requirement2_Num INTEGER,
Requirement2_Desc VARCHAR(50),
Requirement3_Num INTEGER,
Requirement3_Desc VARCHAR(50),
Requirement4_Num INTEGER,
Requirement4_Desc VARCHAR(50)
);
INSERT INTO fabricators (
Output, Fabricator,
Requirement1_Num, Requirement1_Desc,
Requirement2_Num, Requirement2_Desc,
Requirement3_Num, Requirement3_Desc,
Requirement4_Num, Requirement4_Desc
) VALUES
('Simple Fabricator', '⚙️', 4, 'Tungsten', 2, 'Sealant', 3, 'Zero Wire', 8, 'Aluminum'),
('Compound Fabricator', '🤖', 4, 'Adhesive', 8, 'Tungsten', 2, 'Isotopic Coolant', 5, 'Zero Wire'),
('Multiplex Fabricator', '🦾', 8, 'Titanium', 8, 'Polymer', 6, 'Lubricant', 3, 'Positron Battery');
CREATE TABLE extractors (
Output VARCHAR(50),
Power INT,
State VARCHAR(10),
Requirement1_Num INTEGER,
Requirement1_Desc VARCHAR(50),
Requirement2_Num INTEGER,
Requirement2_Desc VARCHAR(50),
Requirement3_Num INTEGER,
Requirement3_Desc VARCHAR(50),
Requirement4_Num INTEGER,
Requirement4_Desc VARCHAR(50)
);
INSERT INTO extractors (
Output, Power, State,
Requirement1_Num, Requirement1_Desc,
Requirement2_Num, Requirement2_Desc,
Requirement3_Num, Requirement3_Desc,
Requirement4_Num, Requirement4_Desc
) VALUES
('Gas Extractor', 5, 'gas', 3, 'Copper', 4, 'Nickel', 5, 'Aluminum', NULL, NULL),
('Gas Extractor Commercial', 10, 'gas', 4, 'Vanadium', 3, 'Adaptive Frame', 2, 'Reactive Gauge', 2, 'Molecular Sieve'),
('Gas Extractor Industrial', 20, 'gas', 3, 'Reactive Gauge', 5, 'Adaptive Frame', 2, 'Substrate Molecular Sieve', 6, 'Vanadium'),
('Liquid Extractor', 5, 'Liquid', 4, 'Nickel', 3, 'Iron', 5, 'Aluminum', NULL, NULL),
('Liquid Extractor Commercial', 10, 'Liquid', 4, 'Titanium', 3, 'Austenitic', 3, 'Adaptive Frame', 4, 'Molecular Sieve'),
('Liquid Extractor Industrial', 20, 'Liquid', 6, 'Titanium', 5, 'Adaptive Frame', 2, 'Substrate Molecular Sieve', 3, 'Veryl-Treated Manifold'),
('Solid Extractor', 5, 'solid', 2, 'Tungsten', 4, 'Aluminum', 5, 'Iron', NULL, NULL),
('Solid Extractor Commercial', 10, 'solid', 1, 'Drilling Rig', 2, 'Isotopic Coolant', 3, 'Adaptive Frame', 4, 'Tungsten'),
('Solid Extractor Industrial', 20, 'solid', 4, 'Isotopic Coolant', 1, 'Aldumite Drilling Rig', 6, 'Tungsten', 5, 'Adaptive Frame');