X6bjqNLM

1CREATE TABLE IF NOT EXISTS
2	District_TLA_INCONTROL_UA_DistrictPairings (
3		District TEXT,
4		YieldType TEXT,
5		Amount TEXT );
6
7INSERT INTO District_TLA_INCONTROL_UA_DistrictPairings
8		( District,						YieldType,				Amount )
9VALUES	('CITY_CENTER',					'YIELD_FOOD',			'2' ),
10		('AQUEDUCT',					'YIELD_FOOD',			'2' ),
11		('HOLY_SITE',					'YIELD_FAITH',			'2' ),
12		('CAMPUS',						'YIELD_SCIENCE',		'2' ),
13
14		('HARBOR',						'YIELD_GOLD',			'2' ),
15		('COMMERCIAL_HUB',				'YIELD_GOLD',			'2' ),
16
17		('INDUSTRIAL_ZONE',				'YIELD_PRODUCTION',		'2' ),
18		('THEATER',						'YIELD_CULTURE',		'2' );
19
20		
21		
22INSERT INTO	TraitModifiers	
23		(TraitType,								ModifierId)
24SELECT	'TRAIT_CIVILIZATION_TLA_INCONTROL_UA',	'MODIFIER_TLA_INCONTROL_UA_PASTURES_'||District
25		FROM District_TLA_INCONTROL_UA_DistrictPairings;
26		
27		
28INSERT INTO ModifierArguments
29		(ModifierId,										Name,				Value)
30SELECT	'MODIFIER_TLA_INCONTROL_UA_PASTURES_'||District,	'Amount',			Amount
31		FROM District_TLA_INCONTROL_UA_DistrictPairings ;
32		
33		
34INSERT INTO ModifierArguments
35		(ModifierId,										Name,				Value)
36SELECT	'MODIFIER_TLA_INCONTROL_UA_PASTURES_'||District,	'YieldType',		YieldType
37		FROM District_TLA_INCONTROL_UA_DistrictPairings ;		
38		
39DROP TABLE District_TLA_INCONTROL_UA_DistrictPairings;