· 7 years ago · Nov 04, 2018, 07:48 PM
1
2--==========================================================================================================================
3-- GEDEMON YNAEMP
4--==========================================================================================================================
5-- Civilizations_YnAEMP
6--------------------------------------------------------------------------------------------------------------------------
7CREATE TABLE IF NOT EXISTS Civilizations_YnAEMP(CivilizationType, MapPrefix, X, Y, CapitalName, AltX, AltY, AltCapitalName);
8INSERT INTO Civilizations_YnAEMP
9 (CivilizationType, MapPrefix, X, Y, AltX, AltY, AltCapitalName)
10VALUES ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'AmericasGiant', 90, 50, 84, 55, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
11 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'Americas', 52, 26, 50, 27, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
12 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'AtlanticGiant', 38, 26, 44, 27, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
13 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'Cordiform', 17, 12, 15, 13, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
14 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'EarthMk3', 156, 26, 153, 28, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
15 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'GreatestEarth', 27, 15, 26, 16, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
16 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'SouthAmericaCentralGiant', 81, 70, 74, 77, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
17 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'SouthAmericaCentralHuge', 64, 53, 56, 57, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
18 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'SouthAmericaGiant', 65, 85, 57, 92, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
19 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'SouthAmericaLarge', 48, 50, 42, 55, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
20 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'Yagem', 161, 23, 159, 26, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02'),
21 ('CIVILIZATION_LEU_BOLIVIA_BELZU', 'Yahem', 37, 24, 35, 26, 'TXT_KEY_CITY_NAME_LEU_BOLIVIA_BELZU_02');
22--------------------------------------------------------------------------------------------------------------------------
23-- Civilizations_CordiformStartPosition
24--------------------------------------------------------------------------------------------------------------------------
25CREATE TABLE IF NOT EXISTS Civilizations_CordiformStartPosition(Type, X, Y, AltX, AltY);
26INSERT INTO Civilizations_CordiformStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
27FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Cordiform';
28--------------------------------------------------------------------------------------------------------------------------
29-- Civilizations_GreatestEarthStartPosition
30--------------------------------------------------------------------------------------------------------------------------
31CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthStartPosition(Type, X, Y, AltX, AltY);
32INSERT INTO Civilizations_GreatestEarthStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
33FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'GreatestEarth';
34--------------------------------------------------------------------------------------------------------------------------
35-- Civilizations_EuroLargeStartPosition
36--------------------------------------------------------------------------------------------------------------------------
37CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeStartPosition(Type, X, Y, AltX, AltY);
38INSERT INTO Civilizations_EuroLargeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
39FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroLarge';
40--------------------------------------------------------------------------------------------------------------------------
41-- Civilizations_YagemStartPosition
42--------------------------------------------------------------------------------------------------------------------------
43CREATE TABLE IF NOT EXISTS Civilizations_YagemStartPosition(Type, X, Y, AltX, AltY);
44INSERT INTO Civilizations_YagemStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
45FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Yagem';
46--------------------------------------------------------------------------------------------------------------------------
47-- Civilizations_YahemStartPosition
48--------------------------------------------------------------------------------------------------------------------------
49CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
50INSERT INTO Civilizations_YahemStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
51FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Yahem';
52--------------------------------------------------------------------------------------------------------------------------
53-- Civilizations_AegeanStartPosition
54--------------------------------------------------------------------------------------------------------------------------
55CREATE TABLE IF NOT EXISTS Civilizations_AegeanStartPosition(Type, X, Y, AltX, AltY);
56INSERT INTO Civilizations_AegeanStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
57FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Aegean';
58--------------------------------------------------------------------------------------------------------------------------
59-- Civilizations_AfricaLargeStartPosition
60--------------------------------------------------------------------------------------------------------------------------
61CREATE TABLE IF NOT EXISTS Civilizations_AfricaLargeStartPosition(Type, X, Y, AltX, AltY);
62INSERT INTO Civilizations_AfricaLargeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
63FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfricaLarge';
64--------------------------------------------------------------------------------------------------------------------------
65-- Civilizations_AmericasStartPosition
66--------------------------------------------------------------------------------------------------------------------------
67CREATE TABLE IF NOT EXISTS Civilizations_AmericasStartPosition(Type, X, Y, AltX, AltY);
68INSERT INTO Civilizations_AmericasStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
69FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Americas';
70--------------------------------------------------------------------------------------------------------------------------
71-- Civilizations_ApennineStartPosition
72--------------------------------------------------------------------------------------------------------------------------
73CREATE TABLE IF NOT EXISTS Civilizations_ApennineStartPosition(Type, X, Y, AltX, AltY);
74INSERT INTO Civilizations_ApennineStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
75FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Apennine';
76--------------------------------------------------------------------------------------------------------------------------
77-- Civilizations_AsiaStartPosition
78--------------------------------------------------------------------------------------------------------------------------
79CREATE TABLE IF NOT EXISTS Civilizations_AsiaStartPosition(Type, X, Y, AltX, AltY);
80INSERT INTO Civilizations_AsiaStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
81FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Asia';
82--------------------------------------------------------------------------------------------------------------------------
83-- Civilizations_CaribbeanStartPosition
84--------------------------------------------------------------------------------------------------------------------------
85CREATE TABLE IF NOT EXISTS Civilizations_CaribbeanStartPosition(Type, X, Y, AltX, AltY);
86INSERT INTO Civilizations_CaribbeanStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
87FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Caribbean';
88--------------------------------------------------------------------------------------------------------------------------
89-- Civilizations_BritishIslesStartPosition
90--------------------------------------------------------------------------------------------------------------------------
91CREATE TABLE IF NOT EXISTS Civilizations_BritishIslesStartPosition(Type, X, Y, AltX, AltY);
92INSERT INTO Civilizations_BritishIslesStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
93FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'BritishIsles';
94--------------------------------------------------------------------------------------------------------------------------
95-- Civilizations_EastAsiaStartPosition
96--------------------------------------------------------------------------------------------------------------------------
97CREATE TABLE IF NOT EXISTS Civilizations_EastAsiaStartPosition(Type, X, Y, AltX, AltY);
98INSERT INTO Civilizations_EastAsiaStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
99FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EastAsia';
100--------------------------------------------------------------------------------------------------------------------------
101-- Civilizations_EuroGiantStartPosition
102--------------------------------------------------------------------------------------------------------------------------
103CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantStartPosition(Type, X, Y, AltX, AltY);
104INSERT INTO Civilizations_EuroGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
105FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroGiant';
106--------------------------------------------------------------------------------------------------------------------------
107-- Civilizations_MediterraneanStartPosition
108--------------------------------------------------------------------------------------------------------------------------
109CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanStartPosition(Type, X, Y, AltX, AltY);
110INSERT INTO Civilizations_MediterraneanStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
111FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Mediterranean';
112--------------------------------------------------------------------------------------------------------------------------
113-- Civilizations_MesopotamiaStartPosition
114--------------------------------------------------------------------------------------------------------------------------
115CREATE TABLE IF NOT EXISTS Civilizations_MesopotamiaStartPosition(Type, X, Y, AltX, AltY);
116INSERT INTO Civilizations_MesopotamiaStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
117FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Mesopotamia';
118--------------------------------------------------------------------------------------------------------------------------
119-- Civilizations_NileValleyStartPosition
120--------------------------------------------------------------------------------------------------------------------------
121CREATE TABLE IF NOT EXISTS Civilizations_NileValleyStartPosition(Type, X, Y, AltX, AltY);
122INSERT INTO Civilizations_NileValleyStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
123FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NileValley';
124--------------------------------------------------------------------------------------------------------------------------
125-- Civilizations_NorthAtlanticStartPosition
126--------------------------------------------------------------------------------------------------------------------------
127CREATE TABLE IF NOT EXISTS Civilizations_NorthAtlanticStartPosition(Type, X, Y, AltX, AltY);
128INSERT INTO Civilizations_NorthAtlanticStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
129FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthAtlantic';
130--------------------------------------------------------------------------------------------------------------------------
131-- Civilizations_NorthEastAsiaStartPosition
132--------------------------------------------------------------------------------------------------------------------------
133CREATE TABLE IF NOT EXISTS Civilizations_NorthEastAsiaStartPosition(Type, X, Y, AltX, AltY);
134INSERT INTO Civilizations_NorthEastAsiaStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
135FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthEastAsia';
136--------------------------------------------------------------------------------------------------------------------------
137-- Civilizations_NorthWestEuropeStartPosition
138--------------------------------------------------------------------------------------------------------------------------
139CREATE TABLE IF NOT EXISTS Civilizations_NorthWestEuropeStartPosition(Type, X, Y, AltX, AltY);
140INSERT INTO Civilizations_NorthWestEuropeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
141FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthWestEurope';
142--------------------------------------------------------------------------------------------------------------------------
143-- Civilizations_PacificStartPosition
144--------------------------------------------------------------------------------------------------------------------------
145CREATE TABLE IF NOT EXISTS Civilizations_PacificStartPosition(Type, X, Y, AltX, AltY);
146INSERT INTO Civilizations_PacificStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
147FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Pacific';
148--------------------------------------------------------------------------------------------------------------------------
149-- Civilizations_SouthPacificStartPosition
150--------------------------------------------------------------------------------------------------------------------------
151CREATE TABLE IF NOT EXISTS Civilizations_SouthPacificStartPosition(Type, X, Y, AltX, AltY);
152INSERT INTO Civilizations_SouthPacificStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
153FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthPacific';
154--------------------------------------------------------------------------------------------------------------------------
155-- Civilizations_AdriaticStartPosition
156--------------------------------------------------------------------------------------------------------------------------
157CREATE TABLE IF NOT EXISTS Civilizations_AdriaticStartPosition(Type, X, Y, AltX, AltY);
158INSERT INTO Civilizations_AdriaticStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
159FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Adriatic';
160--------------------------------------------------------------------------------------------------------------------------
161-- Civilizations_AfriAsiaAustStartPosition
162--------------------------------------------------------------------------------------------------------------------------
163CREATE TABLE IF NOT EXISTS Civilizations_AfriAsiaAustStartPosition(Type, X, Y, AltX, AltY);
164INSERT INTO Civilizations_AfriAsiaAustStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
165FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfriAsiaAust';
166--------------------------------------------------------------------------------------------------------------------------
167-- Civilizations_AfriGiantStartPosition
168--------------------------------------------------------------------------------------------------------------------------
169CREATE TABLE IF NOT EXISTS Civilizations_AfriGiantStartPosition(Type, X, Y, AltX, AltY);
170INSERT INTO Civilizations_AfriGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
171FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfriGiant';
172--------------------------------------------------------------------------------------------------------------------------
173-- Civilizations_AfriSouthEuroStartPosition
174--------------------------------------------------------------------------------------------------------------------------
175CREATE TABLE IF NOT EXISTS Civilizations_AfriSouthEuroStartPosition(Type, X, Y, AltX, AltY);
176INSERT INTO Civilizations_AfriSouthEuroStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
177FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfriSouthEuro';
178--------------------------------------------------------------------------------------------------------------------------
179-- Civilizations_AmericasGiantStartPosition
180--------------------------------------------------------------------------------------------------------------------------
181CREATE TABLE IF NOT EXISTS Civilizations_AmericasGiantStartPosition(Type, X, Y, AltX, AltY);
182INSERT INTO Civilizations_AmericasGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
183FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AmericasGiant';
184--------------------------------------------------------------------------------------------------------------------------
185-- Civilizations_AsiaSmallStartPosition
186--------------------------------------------------------------------------------------------------------------------------
187CREATE TABLE IF NOT EXISTS Civilizations_AsiaSmallStartPosition(Type, X, Y, AltX, AltY);
188INSERT INTO Civilizations_AsiaSmallStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
189FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AsiaSmall';
190--------------------------------------------------------------------------------------------------------------------------
191-- Civilizations_AsiaSteppeGiantStartPosition
192--------------------------------------------------------------------------------------------------------------------------
193CREATE TABLE IF NOT EXISTS Civilizations_AsiaSteppeGiantStartPosition(Type, X, Y, AltX, AltY);
194INSERT INTO Civilizations_AsiaSteppeGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
195FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AsiaSteppeGiant';
196--------------------------------------------------------------------------------------------------------------------------
197-- Civilizations_AustralasiaGiantStartPosition
198--------------------------------------------------------------------------------------------------------------------------
199CREATE TABLE IF NOT EXISTS Civilizations_AustralasiaGiantStartPosition(Type, X, Y, AltX, AltY);
200INSERT INTO Civilizations_AustralasiaGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
201FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AustralasiaGiant';
202--------------------------------------------------------------------------------------------------------------------------
203-- Civilizations_CaucasusStartPosition
204--------------------------------------------------------------------------------------------------------------------------
205CREATE TABLE IF NOT EXISTS Civilizations_CaucasusStartPosition(Type, X, Y, AltX, AltY);
206INSERT INTO Civilizations_CaucasusStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
207FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Caucasus';
208--------------------------------------------------------------------------------------------------------------------------
209-- Civilizations_CentralAsiaStartPosition
210--------------------------------------------------------------------------------------------------------------------------
211CREATE TABLE IF NOT EXISTS Civilizations_CentralAsiaStartPosition(Type, X, Y, AltX, AltY);
212INSERT INTO Civilizations_CentralAsiaStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
213FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'CentralAsia';
214--------------------------------------------------------------------------------------------------------------------------
215-- Civilizations_EuroEasternStartPosition
216--------------------------------------------------------------------------------------------------------------------------
217CREATE TABLE IF NOT EXISTS Civilizations_EuroEasternStartPosition(Type, X, Y, AltX, AltY);
218INSERT INTO Civilizations_EuroEasternStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
219FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroEastern';
220--------------------------------------------------------------------------------------------------------------------------
221-- Civilizations_EuroLargeNewStartPosition
222--------------------------------------------------------------------------------------------------------------------------
223CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeNewStartPosition(Type, X, Y, AltX, AltY);
224INSERT INTO Civilizations_EuroLargeNewStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
225FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroLargeNew';
226--------------------------------------------------------------------------------------------------------------------------
227-- Civilizations_IndiaGiantStartPosition
228--------------------------------------------------------------------------------------------------------------------------
229CREATE TABLE IF NOT EXISTS Civilizations_IndiaGiantStartPosition(Type, X, Y, AltX, AltY);
230INSERT INTO Civilizations_IndiaGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
231FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'IndiaGiant';
232--------------------------------------------------------------------------------------------------------------------------
233-- Civilizations_MesopotamiaGiantStartPosition
234--------------------------------------------------------------------------------------------------------------------------
235CREATE TABLE IF NOT EXISTS Civilizations_MesopotamiaGiantStartPosition(Type, X, Y, AltX, AltY);
236INSERT INTO Civilizations_MesopotamiaGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
237FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'MesopotamiaGiant';
238--------------------------------------------------------------------------------------------------------------------------
239-- Civilizations_NorthAmericaGiantStartPosition
240--------------------------------------------------------------------------------------------------------------------------
241CREATE TABLE IF NOT EXISTS Civilizations_NorthAmericaGiantStartPosition(Type, X, Y, AltX, AltY);
242INSERT INTO Civilizations_NorthAmericaGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
243FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthAmericaGiant';
244--------------------------------------------------------------------------------------------------------------------------
245-- Civilizations_NorthAmericaHugeStartPosition
246--------------------------------------------------------------------------------------------------------------------------
247CREATE TABLE IF NOT EXISTS Civilizations_NorthAmericaHugeStartPosition(Type, X, Y, AltX, AltY);
248INSERT INTO Civilizations_NorthAmericaHugeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
249FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthAmericaHuge';
250--------------------------------------------------------------------------------------------------------------------------
251-- Civilizations_NorthSeaEuropeStartPosition
252--------------------------------------------------------------------------------------------------------------------------
253CREATE TABLE IF NOT EXISTS Civilizations_NorthSeaEuropeStartPosition(Type, X, Y, AltX, AltY);
254INSERT INTO Civilizations_NorthSeaEuropeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
255FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthSeaEurope';
256--------------------------------------------------------------------------------------------------------------------------
257-- Civilizations_ScotlandIrelandHugeStartPosition
258--------------------------------------------------------------------------------------------------------------------------
259CREATE TABLE IF NOT EXISTS Civilizations_ScotlandIrelandHugeStartPosition(Type, X, Y, AltX, AltY);
260INSERT INTO Civilizations_ScotlandIrelandHugeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
261FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'ScotlandIrelandHuge';
262--------------------------------------------------------------------------------------------------------------------------
263-- Civilizations_SouthAmericaGiantStartPosition
264--------------------------------------------------------------------------------------------------------------------------
265CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaGiantStartPosition(Type, X, Y, AltX, AltY);
266INSERT INTO Civilizations_SouthAmericaGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
267FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaGiant';
268--------------------------------------------------------------------------------------------------------------------------
269-- Civilizations_SouthAmericaLargeStartPosition
270--------------------------------------------------------------------------------------------------------------------------
271CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaLargeStartPosition(Type, X, Y, AltX, AltY);
272INSERT INTO Civilizations_SouthAmericaLargeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
273FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaLarge';
274--------------------------------------------------------------------------------------------------------------------------
275-- Civilizations_SouthAmericaCentralHugeStartPosition
276--------------------------------------------------------------------------------------------------------------------------
277CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaCentralHugeStartPosition(Type, X, Y, AltX, AltY);
278INSERT INTO Civilizations_SouthAmericaCentralHugeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
279FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaCentralHuge';
280--------------------------------------------------------------------------------------------------------------------------
281-- Civilizations_SouthAmericaCentralGiantStartPosition
282--------------------------------------------------------------------------------------------------------------------------
283CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaCentralGiantStartPosition(Type, X, Y, AltX, AltY);
284INSERT INTO Civilizations_SouthAmericaCentralGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
285FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaCentralGiant';
286--------------------------------------------------------------------------------------------------------------------------
287-- Civilizations_SouthAsiaHugeStartPosition
288--------------------------------------------------------------------------------------------------------------------------
289CREATE TABLE IF NOT EXISTS Civilizations_SouthAsiaHugeStartPosition(Type, X, Y, AltX, AltY);
290INSERT INTO Civilizations_SouthAsiaHugeStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
291FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAsiaHuge';
292--------------------------------------------------------------------------------------------------------------------------
293-- Civilizations_SouthPacificGiantStartPosition
294--------------------------------------------------------------------------------------------------------------------------
295CREATE TABLE IF NOT EXISTS Civilizations_SouthPacificGiantStartPosition(Type, X, Y, AltX, AltY);
296INSERT INTO Civilizations_SouthPacificGiantStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
297FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthPacificGiant';
298--------------------------------------------------------------------------------------------------------------------------
299-- Civilizations_WestAfricaStartPosition
300--------------------------------------------------------------------------------------------------------------------------
301CREATE TABLE IF NOT EXISTS Civilizations_WestAfricaStartPosition(Type, X, Y, AltX, AltY);
302INSERT INTO Civilizations_WestAfricaStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
303FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'WestAfrica';
304--------------------------------------------------------------------------------------------------------------------------
305-- Civilizations_IndianOceanStartPosition
306--------------------------------------------------------------------------------------------------------------------------
307CREATE TABLE IF NOT EXISTS Civilizations_IndianOceanStartPosition(Type, X, Y, AltX, AltY);
308INSERT INTO Civilizations_IndianOceanStartPosition (Type, X, Y) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', X, Y
309FROM Civilizations_YnAEMP WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'IndianOcean';
310--------------------------------------------------------------------------------------------------------------------------
311-- Civilizations_YnAEMPRequestedResources
312--------------------------------------------------------------------------------------------------------------------------
313CREATE TABLE IF NOT EXISTS Civilizations_YnAEMPRequestedResources(CivilizationType, MapPrefix, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4, Req5, Yield5, Req6, Yield6);
314INSERT INTO Civilizations_YnAEMPRequestedResources
315 (CivilizationType, MapPrefix, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4, Req5, Yield5, Req6, Yield6)
316SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', MapPrefix, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4, Req5, Yield5, Req6, Yield6
317FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_BRAZIL';
318--------------------------------------------------------------------------------------------------------------------------
319-- Civilizations_CordiformRequestedResource
320--------------------------------------------------------------------------------------------------------------------------
321CREATE TABLE IF NOT EXISTS Civilizations_CordiformRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
322INSERT INTO Civilizations_CordiformRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
323FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Cordiform';
324--------------------------------------------------------------------------------------------------------------------------
325-- Civilizations_GreatestEarthRequestedResource
326--------------------------------------------------------------------------------------------------------------------------
327CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
328INSERT INTO Civilizations_GreatestEarthRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
329FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'GreatestEarth';
330--------------------------------------------------------------------------------------------------------------------------
331-- Civilizations_EuroLargeRequestedResource
332--------------------------------------------------------------------------------------------------------------------------
333CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
334INSERT INTO Civilizations_EuroLargeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
335FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroLarge';
336--------------------------------------------------------------------------------------------------------------------------
337-- Civilizations_YagemRequestedResource
338--------------------------------------------------------------------------------------------------------------------------
339CREATE TABLE IF NOT EXISTS Civilizations_YagemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
340INSERT INTO Civilizations_YagemRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
341FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Yagem';
342--------------------------------------------------------------------------------------------------------------------------
343-- Civilizations_YahemRequestedResource
344--------------------------------------------------------------------------------------------------------------------------
345CREATE TABLE IF NOT EXISTS Civilizations_YahemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
346INSERT INTO Civilizations_YahemRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
347FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Yahem';
348--------------------------------------------------------------------------------------------------------------------------
349-- Civilizations_AegeanRequestedResource
350--------------------------------------------------------------------------------------------------------------------------
351CREATE TABLE IF NOT EXISTS Civilizations_AegeanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
352INSERT INTO Civilizations_AegeanRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
353FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Aegean';
354--------------------------------------------------------------------------------------------------------------------------
355-- Civilizations_AfricaLargeRequestedResource
356--------------------------------------------------------------------------------------------------------------------------
357CREATE TABLE IF NOT EXISTS Civilizations_AfricaLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
358INSERT INTO Civilizations_AfricaLargeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
359FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfricaLarge';
360--------------------------------------------------------------------------------------------------------------------------
361-- Civilizations_AmericasRequestedResource
362--------------------------------------------------------------------------------------------------------------------------
363CREATE TABLE IF NOT EXISTS Civilizations_AmericasRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
364INSERT INTO Civilizations_AmericasRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
365FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Americas';
366--------------------------------------------------------------------------------------------------------------------------
367-- Civilizations_ApennineRequestedResource
368--------------------------------------------------------------------------------------------------------------------------
369CREATE TABLE IF NOT EXISTS Civilizations_ApennineRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
370INSERT INTO Civilizations_ApennineRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
371FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Apennine';
372--------------------------------------------------------------------------------------------------------------------------
373-- Civilizations_AsiaRequestedResource
374--------------------------------------------------------------------------------------------------------------------------
375CREATE TABLE IF NOT EXISTS Civilizations_AsiaRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
376INSERT INTO Civilizations_AsiaRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
377FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Asia';
378--------------------------------------------------------------------------------------------------------------------------
379-- Civilizations_CaribbeanRequestedResource
380--------------------------------------------------------------------------------------------------------------------------
381CREATE TABLE IF NOT EXISTS Civilizations_CaribbeanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
382INSERT INTO Civilizations_CaribbeanRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
383FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Caribbean';
384--------------------------------------------------------------------------------------------------------------------------
385-- Civilizations_BritishIslesRequestedResource
386--------------------------------------------------------------------------------------------------------------------------
387CREATE TABLE IF NOT EXISTS Civilizations_BritishIslesRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
388INSERT INTO Civilizations_BritishIslesRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
389FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'BritishIsles';
390--------------------------------------------------------------------------------------------------------------------------
391-- Civilizations_EastAsiaRequestedResource
392--------------------------------------------------------------------------------------------------------------------------
393CREATE TABLE IF NOT EXISTS Civilizations_EastAsiaRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
394INSERT INTO Civilizations_EastAsiaRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
395FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EastAsia';
396--------------------------------------------------------------------------------------------------------------------------
397-- Civilizations_EuroGiantRequestedResource
398--------------------------------------------------------------------------------------------------------------------------
399CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
400INSERT INTO Civilizations_EuroGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
401FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroGiant';
402--------------------------------------------------------------------------------------------------------------------------
403-- Civilizations_MediterraneanRequestedResource
404--------------------------------------------------------------------------------------------------------------------------
405CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
406INSERT INTO Civilizations_MediterraneanRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
407FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Mediterranean';
408--------------------------------------------------------------------------------------------------------------------------
409-- Civilizations_MesopotamiaRequestedResource
410--------------------------------------------------------------------------------------------------------------------------
411CREATE TABLE IF NOT EXISTS Civilizations_MesopotamiaRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
412INSERT INTO Civilizations_MesopotamiaRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
413FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Mesopotamia';
414--------------------------------------------------------------------------------------------------------------------------
415-- Civilizations_NileValleyRequestedResource
416--------------------------------------------------------------------------------------------------------------------------
417CREATE TABLE IF NOT EXISTS Civilizations_NileValleyRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
418INSERT INTO Civilizations_NileValleyRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
419FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NileValley';
420--------------------------------------------------------------------------------------------------------------------------
421-- Civilizations_NorthAtlanticRequestedResource
422--------------------------------------------------------------------------------------------------------------------------
423CREATE TABLE IF NOT EXISTS Civilizations_NorthAtlanticRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
424INSERT INTO Civilizations_NorthAtlanticRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
425FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthAtlantic';
426--------------------------------------------------------------------------------------------------------------------------
427-- Civilizations_NorthEastAsiaRequestedResource
428--------------------------------------------------------------------------------------------------------------------------
429CREATE TABLE IF NOT EXISTS Civilizations_NorthEastAsiaRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
430INSERT INTO Civilizations_NorthEastAsiaRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
431FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthEastAsia';
432--------------------------------------------------------------------------------------------------------------------------
433-- Civilizations_NorthWestEuropeRequestedResource
434--------------------------------------------------------------------------------------------------------------------------
435CREATE TABLE IF NOT EXISTS Civilizations_NorthWestEuropeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
436INSERT INTO Civilizations_NorthWestEuropeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
437FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthWestEurope';
438--------------------------------------------------------------------------------------------------------------------------
439-- Civilizations_PacificRequestedResource
440--------------------------------------------------------------------------------------------------------------------------
441CREATE TABLE IF NOT EXISTS Civilizations_PacificRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
442INSERT INTO Civilizations_PacificRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
443FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Pacific';
444--------------------------------------------------------------------------------------------------------------------------
445-- Civilizations_SouthPacificRequestedResource
446--------------------------------------------------------------------------------------------------------------------------
447CREATE TABLE IF NOT EXISTS Civilizations_SouthPacificRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
448INSERT INTO Civilizations_SouthPacificRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
449FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthPacific';
450--------------------------------------------------------------------------------------------------------------------------
451-- Civilizations_AdriaticRequestedResource
452--------------------------------------------------------------------------------------------------------------------------
453CREATE TABLE IF NOT EXISTS Civilizations_AdriaticRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
454INSERT INTO Civilizations_AdriaticRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
455FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Adriatic';
456--------------------------------------------------------------------------------------------------------------------------
457-- Civilizations_AfriAsiaAustRequestedResource
458--------------------------------------------------------------------------------------------------------------------------
459CREATE TABLE IF NOT EXISTS Civilizations_AfriAsiaAustRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
460INSERT INTO Civilizations_AfriAsiaAustRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
461FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfriAsiaAust';
462--------------------------------------------------------------------------------------------------------------------------
463-- Civilizations_AfriGiantRequestedResource
464--------------------------------------------------------------------------------------------------------------------------
465CREATE TABLE IF NOT EXISTS Civilizations_AfriGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
466INSERT INTO Civilizations_AfriGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
467FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfriGiant';
468--------------------------------------------------------------------------------------------------------------------------
469-- Civilizations_AfriSouthEuroRequestedResource
470--------------------------------------------------------------------------------------------------------------------------
471CREATE TABLE IF NOT EXISTS Civilizations_AfriSouthEuroRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
472INSERT INTO Civilizations_AfriSouthEuroRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
473FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AfriSouthEuro';
474--------------------------------------------------------------------------------------------------------------------------
475-- Civilizations_AmericasGiantRequestedResource
476--------------------------------------------------------------------------------------------------------------------------
477CREATE TABLE IF NOT EXISTS Civilizations_AmericasGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
478INSERT INTO Civilizations_AmericasGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
479FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AmericasGiant';
480--------------------------------------------------------------------------------------------------------------------------
481-- Civilizations_AsiaSmallRequestedResource
482--------------------------------------------------------------------------------------------------------------------------
483CREATE TABLE IF NOT EXISTS Civilizations_AsiaSmallRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
484INSERT INTO Civilizations_AsiaSmallRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
485FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AsiaSmall';
486--------------------------------------------------------------------------------------------------------------------------
487-- Civilizations_AsiaSteppeGiantRequestedResource
488--------------------------------------------------------------------------------------------------------------------------
489CREATE TABLE IF NOT EXISTS Civilizations_AsiaSteppeGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
490INSERT INTO Civilizations_AsiaSteppeGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
491FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AsiaSteppeGiant';
492--------------------------------------------------------------------------------------------------------------------------
493-- Civilizations_AustralasiaGiantRequestedResource
494--------------------------------------------------------------------------------------------------------------------------
495CREATE TABLE IF NOT EXISTS Civilizations_AustralasiaGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
496INSERT INTO Civilizations_AustralasiaGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
497FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'AustralasiaGiant';
498--------------------------------------------------------------------------------------------------------------------------
499-- Civilizations_CaucasusRequestedResource
500--------------------------------------------------------------------------------------------------------------------------
501CREATE TABLE IF NOT EXISTS Civilizations_CaucasusRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
502INSERT INTO Civilizations_CaucasusRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
503FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'Caucasus';
504--------------------------------------------------------------------------------------------------------------------------
505-- Civilizations_CentralAsiaRequestedResource
506--------------------------------------------------------------------------------------------------------------------------
507CREATE TABLE IF NOT EXISTS Civilizations_CentralAsiaRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
508INSERT INTO Civilizations_CentralAsiaRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
509FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'CentralAsia';
510--------------------------------------------------------------------------------------------------------------------------
511-- Civilizations_EuroEasternRequestedResource
512--------------------------------------------------------------------------------------------------------------------------
513CREATE TABLE IF NOT EXISTS Civilizations_EuroEasternRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
514INSERT INTO Civilizations_EuroEasternRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
515FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroEastern';
516--------------------------------------------------------------------------------------------------------------------------
517-- Civilizations_EuroLargeNewRequestedResource
518--------------------------------------------------------------------------------------------------------------------------
519CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeNewRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
520INSERT INTO Civilizations_EuroLargeNewRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
521FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'EuroLargeNew';
522--------------------------------------------------------------------------------------------------------------------------
523-- Civilizations_IndiaGiantRequestedResource
524--------------------------------------------------------------------------------------------------------------------------
525CREATE TABLE IF NOT EXISTS Civilizations_IndiaGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
526INSERT INTO Civilizations_IndiaGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
527FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'IndiaGiant';
528--------------------------------------------------------------------------------------------------------------------------
529-- Civilizations_MesopotamiaGiantRequestedResource
530--------------------------------------------------------------------------------------------------------------------------
531CREATE TABLE IF NOT EXISTS Civilizations_MesopotamiaGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
532INSERT INTO Civilizations_MesopotamiaGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
533FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'MesopotamiaGiant';
534--------------------------------------------------------------------------------------------------------------------------
535-- Civilizations_NorthAmericaGiantRequestedResource
536--------------------------------------------------------------------------------------------------------------------------
537CREATE TABLE IF NOT EXISTS Civilizations_NorthAmericaGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
538INSERT INTO Civilizations_NorthAmericaGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
539FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthAmericaGiant';
540--------------------------------------------------------------------------------------------------------------------------
541-- Civilizations_NorthAmericaHugeRequestedResource
542--------------------------------------------------------------------------------------------------------------------------
543CREATE TABLE IF NOT EXISTS Civilizations_NorthAmericaHugeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
544INSERT INTO Civilizations_NorthAmericaHugeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
545FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthAmericaHuge';
546--------------------------------------------------------------------------------------------------------------------------
547-- Civilizations_NorthSeaEuropeRequestedResource
548--------------------------------------------------------------------------------------------------------------------------
549CREATE TABLE IF NOT EXISTS Civilizations_NorthSeaEuropeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
550INSERT INTO Civilizations_NorthSeaEuropeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
551FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'NorthSeaEurope';
552--------------------------------------------------------------------------------------------------------------------------
553-- Civilizations_ScotlandIrelandHugeRequestedResource
554--------------------------------------------------------------------------------------------------------------------------
555CREATE TABLE IF NOT EXISTS Civilizations_ScotlandIrelandHugeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
556INSERT INTO Civilizations_ScotlandIrelandHugeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
557FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'ScotlandIrelandHuge';
558--------------------------------------------------------------------------------------------------------------------------
559-- Civilizations_SouthAmericaGiantRequestedResource
560--------------------------------------------------------------------------------------------------------------------------
561CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
562INSERT INTO Civilizations_SouthAmericaGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
563FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaGiant';
564--------------------------------------------------------------------------------------------------------------------------
565-- Civilizations_SouthAmericaLargeRequestedResource
566--------------------------------------------------------------------------------------------------------------------------
567CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
568INSERT INTO Civilizations_SouthAmericaLargeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
569FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaLarge';
570--------------------------------------------------------------------------------------------------------------------------
571-- Civilizations_SouthAmericaCentralHugeRequestedResource
572--------------------------------------------------------------------------------------------------------------------------
573CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaCentralHugeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
574INSERT INTO Civilizations_SouthAmericaCentralHugeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
575FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaCentralHuge';
576--------------------------------------------------------------------------------------------------------------------------
577-- Civilizations_SouthAmericaCentralGiantRequestedResource
578--------------------------------------------------------------------------------------------------------------------------
579CREATE TABLE IF NOT EXISTS Civilizations_SouthAmericaCentralGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
580INSERT INTO Civilizations_SouthAmericaCentralGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
581FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAmericaCentralGiant';
582--------------------------------------------------------------------------------------------------------------------------
583-- Civilizations_SouthAsiaHugeRequestedResource
584--------------------------------------------------------------------------------------------------------------------------
585CREATE TABLE IF NOT EXISTS Civilizations_SouthAsiaHugeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
586INSERT INTO Civilizations_SouthAsiaHugeRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
587FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthAsiaHuge';
588--------------------------------------------------------------------------------------------------------------------------
589-- Civilizations_SouthPacificGiantRequestedResource
590--------------------------------------------------------------------------------------------------------------------------
591CREATE TABLE IF NOT EXISTS Civilizations_SouthPacificGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
592INSERT INTO Civilizations_SouthPacificGiantRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
593FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'SouthPacificGiant';
594--------------------------------------------------------------------------------------------------------------------------
595-- Civilizations_WestAfricaRequestedResource
596--------------------------------------------------------------------------------------------------------------------------
597CREATE TABLE IF NOT EXISTS Civilizations_WestAfricaRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
598INSERT INTO Civilizations_WestAfricaRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
599FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'WestAfrica';
600--------------------------------------------------------------------------------------------------------------------------
601-- Civilizations_IndianOceanRequestedResource
602--------------------------------------------------------------------------------------------------------------------------
603CREATE TABLE IF NOT EXISTS Civilizations_IndianOceanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
604INSERT INTO Civilizations_IndianOceanRequestedResource (Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4) SELECT 'CIVILIZATION_LEU_BOLIVIA_BELZU', Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
605FROM Civilizations_YnAEMPRequestedResources WHERE CivilizationType = 'CIVILIZATION_LEU_BOLIVIA_BELZU' AND MapPrefix = 'IndianOcean';