GoldenAge_Buildings_Expansion_IndustrialZone.sql

-- GoldenAge_Buildings_Expansion
-- Author: Administrator
-- DateCreated: 5/30/2021 11:24:15 PM
--------------------------------------------------------------
INSERT OR REPLACE INTO Types
(Type,						Kind)	VALUES
('BUILDING_STONEMASON',		'KIND_BUILDING'),
('BUILDING_SMELTERY',		'KIND_BUILDING'),
('BUILDING_RAWMATERIAL',	'KIND_BUILDING'),
('BUILDING_FABRICATION',	'KIND_BUILDING'),
('BUILDING_ASSEMBLYLINE',   'KIND_BUILDING'),
('BUILDING_AUTOMATED',      'KIND_BUILDING'),
('BUILDING_JNR_RENEWABLE_COLLECTION',	'KIND_BUILDING'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'KIND_BUILDING');

--Districts
INSERT OR REPLACE INTO Buildings
(BuildingType,							Name,											PrereqTech,					PrereqCivic,		Cost,		PrereqDistrict,					Description,											PurChaseYield,			Maintenance,	CitizenSlots,	RegionalRange, AdvisorType)		VALUES
('BUILDING_STONEMASON',					'LOC_BUILDING_STONEMASON_NAME',					'TECH_MACHINERY',			NULL,				240,		'DISTRICT_INDUSTRIAL_ZONE',		'LOC_BUILDING_STONEMASON_DESCRIPTION',					'YIELD_GOLD',			2,				1,				3,				'ADVISOR_GENERIC'),
('BUILDING_SMELTERY',					'LOC_BUILDING_SMELTERY_NAME',					'TECH_APPRENTICESHIP',		NULL,				240,		'DISTRICT_INDUSTRIAL_ZONE',		'LOC_BUILDING_SMELTERY_DESCRIPTION',					'YIELD_GOLD',			2,				1,				3,				'ADVISOR_GENERIC'),
('BUILDING_RAWMATERIAL',				'LOC_BUILDING_RAWMATERIAL_NAME',				'TECH_INDUSTRIALIZATION',	NULL,				600,		'DISTRICT_INDUSTRIAL_ZONE',		'LOC_BUILDING_RAWMATERIAL_DESCRIPTION',					'YIELD_GOLD',			3,				1,				4,				'ADVISOR_GENERIC'),
('BUILDING_FABRICATION',				'LOC_BUILDING_FABRICATION_NAME',				'TECH_RIFLING',				NULL,				600,		'DISTRICT_INDUSTRIAL_ZONE',		'LOC_BUILDING_FABRICATION_DESCRIPTION',					'YIELD_GOLD',			3,				1,				4,				'ADVISOR_GENERIC'),
('BUILDING_ASSEMBLYLINE',           	'LOC_BUILDING_ASSEMBLYLINE_NAME',           	'TECH_SYNTHETIC_MATERIALS', NULL,               1600,       'DISTRICT_INDUSTRIAL_ZONE',     'LOC_BUILDING_ASSEMBLYLINE_DESCRIPTION',            	'YIELD_GOLD',           5,              1,              6,				'ADVISOR_GENERIC'),
('BUILDING_AUTOMATED',              	'LOC_BUILDING_AUTOMATED_NAME',              	'TECH_ROBOTICS',            NULL,               1600,       'DISTRICT_INDUSTRIAL_ZONE',     'LOC_BUILDING_AUTOMATED_DESCRIPTION',            		'YIELD_GOLD',           5,              1,              6,				'ADVISOR_GENERIC'),
('BUILDING_JNR_RENEWABLE_COLLECTION',	'LOC_BUILDING_JNR_RENEWABLE_COLLECTION_NAME', 	'TECH_NANOTECHNOLOGY',		NULL,				1600,		'DISTRICT_INDUSTRIAL_ZONE',		'LOC_BUILDING_JNR_RENEWABLE_COLLECTION_DESCRIPTION',	'YIELD_GOLD',			5,				1,				6,				'ADVISOR_GENERIC'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'LOC_BUILDING_JNR_RENEWABLE_DISTRIBUTION_NAME',	'TECH_NANOTECHNOLOGY',		NULL,				1000,		'DISTRICT_INDUSTRIAL_ZONE',		'LOC_BUILDING_JNR_RENEWABLE_DISTRIBUTION_DESCRIPTION',	'YIELD_GOLD',			4,				1,				5,				'ADVISOR_GENERIC');

UPDATE Buildings SET PrereqTech = 'TECH_CASTLES', Cost = 240, Maintenance = 2, CitizenSlots = 1, RegionalRange = 3, Description = 'LOC_BUILDING_WORKSHOP_DESCRIPTION'
WHERE BuildingType = 'BUILDING_WORKSHOP';
UPDATE Buildings SET PrereqTech = 'TECH_SCIENTIFIC_THEORY',	Cost = 600,	Maintenance = 3, CitizenSlots = 1,	RegionalRange = 4, Description = 'LOC_GAEXP_BUILDING_FACTORY_DESCRIPTION'
WHERE BuildingType = 'BUILDING_FACTORY';
UPDATE Buildings SET RegionalRange = 4, Description = 'LOC_GAEXP_BUILDING_ELECTRONICS_FACTORY_DESCRIPTION'
WHERE BuildingType = 'BUILDING_ELECTRONICS_FACTORY';
UPDATE Buildings SET Cost=1000,	Maintenance=4 ,	RegionalRange=5, PrereqTech = 'TECH_STEAM_POWER' 
WHERE BuildingType='BUILDING_COAL_POWER_PLANT';
UPDATE Buildings SET Cost=1000,	Maintenance=4 ,	RegionalRange=5 
WHERE BuildingType='BUILDING_FOSSIL_FUEL_POWER_PLANT';
UPDATE Buildings SET Cost=1000,	Maintenance=4 ,	RegionalRange=5 
WHERE BuildingType='BUILDING_POWER_PLANT';

INSERT OR REPLACE INTO MutuallyExclusiveBuildings
(Building,								MutuallyExclusiveBuilding)		VALUES
('BUILDING_WORKSHOP',					'BUILDING_STONEMASON'),
('BUILDING_WORKSHOP',					'BUILDING_SMELTERY'),
('BUILDING_STONEMASON',					'BUILDING_SMELTERY'),
('BUILDING_STONEMASON',					'BUILDING_WORKSHOP'),
('BUILDING_SMELTERY',					'BUILDING_STONEMASON'),
('BUILDING_SMELTERY',					'BUILDING_WORKSHOP'),

('BUILDING_FACTORY',					'BUILDING_RAWMATERIAL'),
('BUILDING_FACTORY',					'BUILDING_FABRICATION'),
('BUILDING_RAWMATERIAL',				'BUILDING_FABRICATION'),
('BUILDING_RAWMATERIAL',				'BUILDING_FACTORY'),
('BUILDING_FABRICATION',				'BUILDING_RAWMATERIAL'),
('BUILDING_FABRICATION',				'BUILDING_FACTORY'),

('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BUILDING_COAL_POWER_PLANT'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BUILDING_FOSSIL_FUEL_POWER_PLANT'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BUILDING_POWER_PLANT'),
('BUILDING_COAL_POWER_PLANT',			'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
('BUILDING_FOSSIL_FUEL_POWER_PLANT',	'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
('BUILDING_POWER_PLANT',				'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
		
('BUILDING_ASSEMBLYLINE',           	'BUILDING_AUTOMATED'),
('BUILDING_ASSEMBLYLINE',           	'BUILDING_JNR_RENEWABLE_COLLECTION'),
('BUILDING_AUTOMATED',              	'BUILDING_ASSEMBLYLINE'),
('BUILDING_AUTOMATED',              	'BUILDING_JNR_RENEWABLE_COLLECTION'),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'BUILDING_ASSEMBLYLINE'),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'BUILDING_AUTOMATED');

INSERT OR REPLACE INTO BuildingPrereqs
(Building,							PrereqBuilding)		VALUES
('BUILDING_FACTORY',				'BUILDING_WORKSHOP'),
('BUILDING_FACTORY',				'BUILDING_SMELTERY'),
('BUILDING_FACTORY',				'BUILDING_STONEMASON'),
('BUILDING_RAWMATERIAL',			'BUILDING_WORKSHOP'),
('BUILDING_RAWMATERIAL',			'BUILDING_SMELTERY'),
('BUILDING_RAWMATERIAL',			'BUILDING_STONEMASON'),
('BUILDING_FABRICATION',			'BUILDING_WORKSHOP'),
('BUILDING_FABRICATION',			'BUILDING_SMELTERY'),
('BUILDING_FABRICATION',			'BUILDING_STONEMASON'),
('BUILDING_ELECTRONICS_FACTORY',    'BUILDING_WORKSHOP'),
('BUILDING_ELECTRONICS_FACTORY',    'BUILDING_SMELTERY'),
('BUILDING_ELECTRONICS_FACTORY',    'BUILDING_STONEMASON'),

('BUILDING_COAL_POWER_PLANT',		'BUILDING_RAWMATERIAL'),
('BUILDING_COAL_POWER_PLANT',       'BUILDING_FACTORY'),
('BUILDING_COAL_POWER_PLANT',		'BUILDING_FABRICATION'),
('BUILDING_COAL_POWER_PLANT',       'BUILDING_ELECTRONICS_FACTORY'),
('BUILDING_FOSSIL_FUEL_POWER_PLANT','BUILDING_RAWMATERIAL'),
('BUILDING_FOSSIL_FUEL_POWER_PLANT','BUILDING_FACTORY'),
('BUILDING_FOSSIL_FUEL_POWER_PLANT','BUILDING_FABRICATION'),
('BUILDING_FOSSIL_FUEL_POWER_PLANT','BUILDING_ELECTRONICS_FACTORY'),
('BUILDING_POWER_PLANT',			'BUILDING_FACTORY'),
('BUILDING_POWER_PLANT',			'BUILDING_RAWMATERIAL'),
('BUILDING_POWER_PLANT',			'BUILDING_FABRICATION'),
('BUILDING_POWER_PLANT',            'BUILDING_ELECTRONICS_FACTORY'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BUILDING_FACTORY'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BUILDING_RAWMATERIAL'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BUILDING_FABRICATION'),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION', 'BUILDING_ELECTRONICS_FACTORY'),

('BUILDING_ASSEMBLYLINE',           	'BUILDING_COAL_POWER_PLANT'),
('BUILDING_ASSEMBLYLINE',           	'BUILDING_FOSSIL_FUEL_POWER_PLANT'),
('BUILDING_ASSEMBLYLINE',           	'BUILDING_POWER_PLANT'),
('BUILDING_ASSEMBLYLINE',           	'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
('BUILDING_AUTOMATED',              	'BUILDING_COAL_POWER_PLANT'),
('BUILDING_AUTOMATED',              	'BUILDING_FOSSIL_FUEL_POWER_PLANT'),
('BUILDING_AUTOMATED',              	'BUILDING_POWER_PLANT'),
('BUILDING_AUTOMATED',              	'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'BUILDING_COAL_POWER_PLANT'),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'BUILDING_FOSSIL_FUEL_POWER_PLANT'),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'BUILDING_POWER_PLANT'),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'BUILDING_JNR_RENEWABLE_DISTRIBUTION');

INSERT OR REPLACE INTO District_CitizenGreatPersonPoints
(DistrictType,						GreatPersonClassType,				PointsPerTurn) VALUES
('DISTRICT_INDUSTRIAL_ZONE',		'GREAT_PERSON_CLASS_ENGINEER',		1);

INSERT OR REPLACE INTO Building_GreatPersonPoints
(BuildingType,						GreatPersonClassType,				PointsPerTurn)		SELECT
BuildingType,						'GREAT_PERSON_CLASS_ENGINEER',		1	FROM Buildings WHERE PrereqDistrict = 'DISTRICT_INDUSTRIAL_ZONE';

DELETE FROM Building_YieldChanges WHERE BuildingType = 'BUILDING_POWER_PLANT';
INSERT OR REPLACE INTO Building_YieldChanges
(BuildingType,							YieldType,			YieldChange)		VALUES
('BUILDING_WORKSHOP',					'YIELD_PRODUCTION',	2),
('BUILDING_STONEMASON',					'YIELD_PRODUCTION',	2),
('BUILDING_SMELTERY',					'YIELD_PRODUCTION',	2),

('BUILDING_FACTORY',					'YIELD_PRODUCTION',	4),
('BUILDING_RAWMATERIAL',				'YIELD_PRODUCTION',	4),
('BUILDING_FABRICATION',				'YIELD_PRODUCTION',	4),

('BUILDING_COAL_POWER_PLANT',       	'YIELD_PRODUCTION', 6),
('BUILDING_FOSSIL_FUEL_POWER_PLANT',	'YIELD_PRODUCTION', 6),
('BUILDING_POWER_PLANT',            	'YIELD_PRODUCTION', 6),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION', 'YIELD_PRODUCTION', 6),

('BUILDING_ASSEMBLYLINE',           	'YIELD_PRODUCTION', 8),
('BUILDING_AUTOMATED',              	'YIELD_PRODUCTION', 8),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'YIELD_PRODUCTION', 8);


INSERT OR REPLACE INTO Buildings_XP2
(BuildingType,						RequiredPower)		VALUES
('BUILDING_WORKSHOP',				1),
('BUILDING_STONEMASON',				1),
('BUILDING_SMELTERY',				1),

('BUILDING_RAWMATERIAL',			2),
('BUILDING_FABRICATION',			2),
('BUILDING_FACTORY',                2),

('BUILDING_ASSEMBLYLINE',           	4),
('BUILDING_AUTOMATED',              	4),
('BUILDING_JNR_RENEWABLE_COLLECTION',   4);


INSERT OR REPLACE INTO Building_YieldChangesBonusWithPower
(BuildingType,							YieldType,			YieldChange)		VALUES
('BUILDING_WORKSHOP',					'YIELD_PRODUCTION',	2),
('BUILDING_STONEMASON',					'YIELD_PRODUCTION',	2),
('BUILDING_SMELTERY',					'YIELD_PRODUCTION',	2),

('BUILDING_FACTORY',                	'YIELD_PRODUCTION', 4),
('BUILDING_RAWMATERIAL',            	'YIELD_PRODUCTION', 4),
('BUILDING_FABRICATION',            	'YIELD_PRODUCTION', 4),

('BUILDING_ASSEMBLYLINE',           	'YIELD_PRODUCTION', 8),
('BUILDING_AUTOMATED',              	'YIELD_PRODUCTION', 8),
('BUILDING_JNR_RENEWABLE_COLLECTION',	'YIELD_PRODUCTION', 8);

INSERT OR REPLACE INTO Building_CitizenYieldChanges
(BuildingType,							YieldType,			YieldChange)		VALUES
('BUILDING_WORKSHOP',					'YIELD_PRODUCTION',	1),
('BUILDING_STONEMASON',					'YIELD_PRODUCTION',	1),
('BUILDING_SMELTERY',					'YIELD_PRODUCTION',	1),

('BUILDING_FACTORY',					'YIELD_PRODUCTION',	1),
('BUILDING_RAWMATERIAL',				'YIELD_PRODUCTION',	1),
('BUILDING_FABRICATION',				'YIELD_PRODUCTION',	1),

('BUILDING_COAL_POWER_PLANT',   	 	'YIELD_PRODUCTION', 1),
('BUILDING_FOSSIL_FUEL_POWER_PLANT', 	'YIELD_PRODUCTION', 1),
('BUILDING_POWER_PLANT',    			'YIELD_PRODUCTION', 1),
('BUILDING_JNR_RENEWABLE_DISTRIBUTION', 'YIELD_PRODUCTION', 1),

('BUILDING_ASSEMBLYLINE',          		'YIELD_PRODUCTION', 1),
('BUILDING_AUTOMATED',              	'YIELD_PRODUCTION', 9),
('BUILDING_JNR_RENEWABLE_COLLECTION',   'YIELD_PRODUCTION', 1);

INSERT OR REPLACE INTO Types (Type,										Kind)
VALUES	('PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY',	'KIND_PROJECT');

INSERT OR REPLACE INTO Projects (ProjectType, Name, ShortName, Description, PrereqDistrict, PrereqTech, Cost, AdvisorType)
VALUES	('PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY', 'LOC_PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY', 'LOC_PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY_SHORT_NAME', 'LOC_PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY_DESCRIPTION', 'DISTRICT_INDUSTRIAL_ZONE', 'TECH_NANOTECHNOLOGY', 500, 'ADVISOR_GENERIC');

INSERT OR REPLACE INTO Projects_XP2 (ProjectType,								CreateBuilding)
VALUES	('PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY',	'BUILDING_JNR_RENEWABLE_DISTRIBUTION');

INSERT OR REPLACE INTO Project_BuildingCosts (ProjectType,								ConsumedBuildingType)
VALUES	('PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY',	'BUILDING_COAL_POWER_PLANT'),
		('PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY',	'BUILDING_FOSSIL_FUEL_POWER_PLANT'),
		('PROJECT_JNR_CONVERT_REACTOR_TO_BATTERY',	'BUILDING_POWER_PLANT'),
		('PROJECT_CONVERT_REACTOR_TO_COAL',			'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
		('PROJECT_CONVERT_REACTOR_TO_OIL',			'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
		('PROJECT_CONVERT_REACTOR_TO_URANIUM',		'BUILDING_JNR_RENEWABLE_DISTRIBUTION');

INSERT OR REPLACE INTO Buildings_XP2
		(BuildingType,							ResourceTypeConvertedToPower)
VALUES	('BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'RESOURCE_JNR_BATTERY_CHARGE');

INSERT OR REPLACE INTO Types (Type,							Kind)
VALUES	('RESOURCE_JNR_BATTERY_CHARGE',	'KIND_RESOURCE');

INSERT OR REPLACE INTO Resources (ResourceType, Name, ResourceClassType, Frequency, PrereqTech, RevealedEra)
VALUES	('RESOURCE_JNR_BATTERY_CHARGE', 'LOC_RESOURCE_JNR_BATTERY_CHARGE_NAME', 'RESOURCECLASS_STRATEGIC', 0, 'TECH_NANOTECHNOLOGY', 8);

INSERT OR REPLACE INTO Resource_Consumption (ResourceType, Accumulate, PowerProvided, BaseExtractionRate, ImprovedExtractionRate, StockpileCap)
VALUES	('RESOURCE_JNR_BATTERY_CHARGE', 				   1, 		   9, 			  0, 				  0, 					  200);
		
--T1 Buildings
INSERT OR REPLACE INTO ImprovementModifiers
(ImprovementType, 						ModifierId) VALUES 
('IMPROVEMENT_LUMBER_MILL', 		'GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION'),
('IMPROVEMENT_LUMBER_MILL', 		'GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION_EXTRA'),
('IMPROVEMENT_QUARRY', 				'GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION'),
('IMPROVEMENT_QUARRY', 				'GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION_EXTRA'),
('IMPROVEMENT_MINE', 				'GOLDEN_MINE_ADDSMELTERYPRODUCTION'),
('IMPROVEMENT_MINE', 				'GOLDEN_MINE_ADDSMELTERYPRODUCTION_EXTRA');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION', 		'MODIFIER_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, NULL),
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION_EXTRA', 	'MODIFIER_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, 'GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP_REQUIREMENTS'),
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION', 			'MODIFIER_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, NULL),
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION_EXTRA', 	'MODIFIER_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, 'GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON_REQUIREMENTS'),
('GOLDEN_MINE_ADDSMELTERYPRODUCTION', 				'MODIFIER_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, NULL),
('GOLDEN_MINE_ADDSMELTERYPRODUCTION_EXTRA', 		'MODIFIER_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, 'GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY_REQUIREMENTS');

INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION', 		'Amount', 			1), 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION', 		'BuildingType', 	'BUILDING_WORKSHOP'), 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION', 		'CityStatesOnly', 	0), 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION', 		'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION_EXTRA', 	'Amount', 			2), 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION_EXTRA', 	'BuildingType', 	'BUILDING_WORKSHOP'), 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION_EXTRA', 	'CityStatesOnly', 	0), 
('GOLDEN_LUMBER_MILL_ADDWORKSHOPPRODUCTION_EXTRA', 	'YieldType', 		'YIELD_PRODUCTION'),

('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION', 			'Amount', 			1), 
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION', 			'BuildingType', 	'BUILDING_STONEMASON'), 
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION_EXTRA', 	'Amount', 			2), 
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION_EXTRA', 	'BuildingType', 	'BUILDING_STONEMASON'), 
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION_EXTRA', 	'CityStatesOnly', 	0), 
('GOLDEN_QUARRY_ADDSTONEMASONPRODUCTION_EXTRA', 	'YieldType', 		'YIELD_PRODUCTION'),

('GOLDEN_MINE_ADDSMELTERYPRODUCTION', 				'Amount', 			1), 
('GOLDEN_MINE_ADDSMELTERYPRODUCTION', 				'BuildingType', 	'BUILDING_SMELTERY'), 
('GOLDEN_MINE_ADDSMELTERYPRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_MINE_ADDSMELTERYPRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_MINE_ADDSMELTERYPRODUCTION_EXTRA', 		'Amount', 			2), 
('GOLDEN_MINE_ADDSMELTERYPRODUCTION_EXTRA', 		'BuildingType', 	'BUILDING_SMELTERY'), 
('GOLDEN_MINE_ADDSMELTERYPRODUCTION_EXTRA', 		'CityStatesOnly', 	0), 
('GOLDEN_MINE_ADDSMELTERYPRODUCTION_EXTRA', 		'YieldType', 		'YIELD_PRODUCTION');

INSERT OR REPLACE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES 
('GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP_REQUIREMENTS', 	'REQUIREMENTSET_TEST_ALL'),
('GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL'),
('GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY_REQUIREMENTS', 	'REQUIREMENTSET_TEST_ALL');

INSERT OR REPLACE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES 
('GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP_REQUIREMENTS', 	'GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP'),
('GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON_REQUIREMENTS', 'GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON'),
('GOLDEN_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY_REQUIREMENTS', 	'GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY');

INSERT OR REPLACE INTO Requirements (RequirementId, RequirementType) VALUES 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP', 	'REQUIREMENT_PLOT_ADJACENT_BUILDING_TYPE_MATCHES'),
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON', 'REQUIREMENT_PLOT_ADJACENT_BUILDING_TYPE_MATCHES'),
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY', 	'REQUIREMENT_PLOT_ADJACENT_BUILDING_TYPE_MATCHES');

INSERT OR REPLACE INTO RequirementArguments (RequirementId, Name, Value) VALUES 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP', 'BuildingType', 'BUILDING_WORKSHOP'), 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP', 'MaxRange', 1), 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_WORKSHOP', 'MinRange', 1),
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON', 'BuildingType', 'BUILDING_STONEMASON'), 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON', 'MaxRange', 1), 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_STONEMASON', 'MinRange', 1),
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY', 'BuildingType', 'BUILDING_SMELTERY'), 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY', 'MaxRange', 1), 
('GOLDEN_REQUIRES_PLOT_IS_ADJACENT_TO_BUILDING_SMELTERY', 'MinRange', 1);

--T2 Factory
INSERT OR REPLACE INTO ImprovementModifiers
(ImprovementType, 						ModifierId) VALUES 
('IMPROVEMENT_QUARRY', 					'GOLDEN_LUXURY_QUARRY_FACTORY_PRODUCTION'),
('IMPROVEMENT_MINE', 					'GOLDEN_LUXURY_MINE_FACTORY_PRODUCTION'),
('IMPROVEMENT_PLANTATION', 				'GOLDEN_LUXURY_PLANTATION_FACTORY_PRODUCTION'),
('IMPROVEMENT_CAMP', 					'GOLDEN_LUXURY_CAMP_FACTORY_PRODUCTION'),
('IMPROVEMENT_FISHING_BOATS', 			'GOLDEN_LUXURY_FISHING_BOATS_FACTORY_PRODUCTION');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_LUXURY_QUARRY_FACTORY_PRODUCTION', 				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_MINE_FACTORY_PRODUCTION', 					'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_FISHING_BOATS_FACTORY_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_CAMP_FACTORY_PRODUCTION', 					'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_PLANTATION_FACTORY_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL);

INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_LUXURY_QUARRY_FACTORY_PRODUCTION', 				'Amount', 			1), 
('GOLDEN_LUXURY_QUARRY_FACTORY_PRODUCTION', 				'BuildingType', 	'BUILDING_FACTORY'), 
('GOLDEN_LUXURY_QUARRY_FACTORY_PRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_QUARRY_FACTORY_PRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_MINE_FACTORY_PRODUCTION', 					'Amount', 			1), 
('GOLDEN_LUXURY_MINE_FACTORY_PRODUCTION', 					'BuildingType', 	'BUILDING_FACTORY'), 
('GOLDEN_LUXURY_MINE_FACTORY_PRODUCTION', 					'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_MINE_FACTORY_PRODUCTION', 					'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_PLANTATION_FACTORY_PRODUCTION', 			'Amount', 			1), 
('GOLDEN_LUXURY_PLANTATION_FACTORY_PRODUCTION', 			'BuildingType', 	'BUILDING_FACTORY'), 
('GOLDEN_LUXURY_PLANTATION_FACTORY_PRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_PLANTATION_FACTORY_PRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_CAMP_FACTORY_PRODUCTION', 					'Amount', 			1), 
('GOLDEN_LUXURY_CAMP_FACTORY_PRODUCTION', 					'BuildingType', 	'BUILDING_FACTORY'), 
('GOLDEN_LUXURY_CAMP_FACTORY_PRODUCTION', 					'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_CAMP_FACTORY_PRODUCTION', 					'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_FISHING_BOATS_FACTORY_PRODUCTION', 			'Amount', 			1), 
('GOLDEN_LUXURY_FISHING_BOATS_FACTORY_PRODUCTION', 			'BuildingType', 	'BUILDING_FACTORY'), 
('GOLDEN_LUXURY_FISHING_BOATS_FACTORY_PRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_FISHING_BOATS_FACTORY_PRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION');

INSERT OR REPLACE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES 
('GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', 	'REQUIREMENTSET_TEST_ALL');

INSERT OR REPLACE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES 
('GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', 	'GOLDEN_REQUIRES_PLOT_IS_WITHIN_TWO_TILES_TO_DISTRICT_INDUSTRIAL_ZONE'),
('GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', 	'REQUIRES_PLOT_HAS_LUXURY');


--T2 Rawmaterial
INSERT OR REPLACE INTO ImprovementModifiers
(ImprovementType, 						ModifierId) VALUES 
('IMPROVEMENT_QUARRY', 					'GOLDEN_STRATEGIC_QUARRY_RAWMATERIAL_PRODUCTION'),
('IMPROVEMENT_MINE', 					'GOLDEN_STRATEGIC_MINE_RAWMATERIAL_PRODUCTION'),
('IMPROVEMENT_PASTURE', 				'GOLDEN_STRATEGIC_PASTURE_RAWMATERIAL_PRODUCTION'),
('IMPROVEMENT_OIL_WELL', 				'GOLDEN_STRATEGIC_OIL_WELL_RAWMATERIAL_PRODUCTION'),
('IMPROVEMENT_OFFSHORE_OIL_RIG', 		'GOLDEN_STRATEGIC_OFFSHORE_OIL_RIG_RAWMATERIAL_PRODUCTION');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_STRATEGIC_QUARRY_RAWMATERIAL_PRODUCTION', 				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', NULL),
('GOLDEN_STRATEGIC_MINE_RAWMATERIAL_PRODUCTION', 				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', NULL),
('GOLDEN_STRATEGIC_PASTURE_RAWMATERIAL_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', NULL),
('GOLDEN_STRATEGIC_OIL_WELL_RAWMATERIAL_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', NULL),
('GOLDEN_STRATEGIC_OFFSHORE_OIL_RIG_RAWMATERIAL_PRODUCTION', 	'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', NULL);

INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_STRATEGIC_QUARRY_RAWMATERIAL_PRODUCTION', 				'Amount', 			2), 
('GOLDEN_STRATEGIC_QUARRY_RAWMATERIAL_PRODUCTION', 				'BuildingType', 	'BUILDING_RAWMATERIAL'), 
('GOLDEN_STRATEGIC_QUARRY_RAWMATERIAL_PRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_STRATEGIC_QUARRY_RAWMATERIAL_PRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_STRATEGIC_MINE_RAWMATERIAL_PRODUCTION', 				'Amount', 			2), 
('GOLDEN_STRATEGIC_MINE_RAWMATERIAL_PRODUCTION', 				'BuildingType', 	'BUILDING_RAWMATERIAL'), 
('GOLDEN_STRATEGIC_MINE_RAWMATERIAL_PRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_STRATEGIC_MINE_RAWMATERIAL_PRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_STRATEGIC_PASTURE_RAWMATERIAL_PRODUCTION', 			'Amount', 			2), 
('GOLDEN_STRATEGIC_PASTURE_RAWMATERIAL_PRODUCTION', 			'BuildingType', 	'BUILDING_RAWMATERIAL'), 
('GOLDEN_STRATEGIC_PASTURE_RAWMATERIAL_PRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_STRATEGIC_PASTURE_RAWMATERIAL_PRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_STRATEGIC_OIL_WELL_RAWMATERIAL_PRODUCTION', 			'Amount', 			2), 
('GOLDEN_STRATEGIC_OIL_WELL_RAWMATERIAL_PRODUCTION', 			'BuildingType', 	'BUILDING_RAWMATERIAL'), 
('GOLDEN_STRATEGIC_OIL_WELL_RAWMATERIAL_PRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_STRATEGIC_OIL_WELL_RAWMATERIAL_PRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_STRATEGIC_OFFSHORE_OIL_RIG_RAWMATERIAL_PRODUCTION', 	'Amount', 			2), 
('GOLDEN_STRATEGIC_OFFSHORE_OIL_RIG_RAWMATERIAL_PRODUCTION', 	'BuildingType', 	'BUILDING_RAWMATERIAL'), 
('GOLDEN_STRATEGIC_OFFSHORE_OIL_RIG_RAWMATERIAL_PRODUCTION', 	'CityStatesOnly', 	0), 
('GOLDEN_STRATEGIC_OFFSHORE_OIL_RIG_RAWMATERIAL_PRODUCTION', 	'YieldType', 		'YIELD_PRODUCTION');

INSERT OR REPLACE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES 
('GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', 	'REQUIREMENTSET_TEST_ALL');

INSERT OR REPLACE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES 
('GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', 	'GOLDEN_REQUIRES_PLOT_IS_WITHIN_TWO_TILES_TO_DISTRICT_INDUSTRIAL_ZONE'),
('GOLDEN_PLOT_HAS_STRATEGIC_IS_ADJACENT_TO_BUILDING_RAWMATERIAL_REQUIREMENTS', 	'REQUIRES_PLOT_HAS_STRATEGIC');

--T2 Fabrication
INSERT OR REPLACE INTO DistrictModifiers (DistrictType,					ModifierId) VALUES	
('DISTRICT_ENCAMPMENT',	'GOLDEN_ENCAMPMENT_FABRICATION_PRODUCTION'),
('DISTRICT_HARBOR',		'GOLDEN_HARBOR_FABRICATION_PRODUCTION'),
('DISTRICT_AERODROME',	'GOLDEN_AERODROME_FABRICATION_PRODUCTION');
INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_ENCAMPMENT_FABRICATION_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_IS_WITHIN_TWO_TILES_TO_DISTRICT_INDUSTRIAL_ZONE_REQUIREMENTS', NULL),
('GOLDEN_HARBOR_FABRICATION_PRODUCTION', 				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_IS_WITHIN_TWO_TILES_TO_DISTRICT_INDUSTRIAL_ZONE_REQUIREMENTS', NULL),
('GOLDEN_AERODROME_FABRICATION_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_IS_WITHIN_TWO_TILES_TO_DISTRICT_INDUSTRIAL_ZONE_REQUIREMENTS', NULL);
INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_ENCAMPMENT_FABRICATION_PRODUCTION', 				'Amount', 			1), 
('GOLDEN_ENCAMPMENT_FABRICATION_PRODUCTION', 				'BuildingType', 	'BUILDING_FABRICATION'), 
('GOLDEN_ENCAMPMENT_FABRICATION_PRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_ENCAMPMENT_FABRICATION_PRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_HARBOR_FABRICATION_PRODUCTION', 					'Amount', 			1), 
('GOLDEN_HARBOR_FABRICATION_PRODUCTION', 					'BuildingType', 	'BUILDING_FABRICATION'), 
('GOLDEN_HARBOR_FABRICATION_PRODUCTION', 					'CityStatesOnly', 	0), 
('GOLDEN_HARBOR_FABRICATION_PRODUCTION', 					'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_AERODROME_FABRICATION_PRODUCTION', 				'Amount', 			1), 
('GOLDEN_AERODROME_FABRICATION_PRODUCTION', 				'BuildingType', 	'BUILDING_FABRICATION'), 
('GOLDEN_AERODROME_FABRICATION_PRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_AERODROME_FABRICATION_PRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION');

--	Involution for T2
INSERT OR REPLACE INTO BuildingModifiers (BuildingType, ModifierId) VALUES 
('BUILDING_FACTORY', 		'GOLDEN_FACTORY_INVOLUTION'),
('BUILDING_FABRICATION', 	'GOLDEN_FABRICATION_INVOLUTION'),
('BUILDING_RAWMATERIAL', 	'GOLDEN_RAWMATERIAL_INVOLUTION');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_FACTORY_INVOLUTION', 		'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, NULL),
('GOLDEN_FABRICATION_INVOLUTION', 	'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, NULL),
('GOLDEN_RAWMATERIAL_INVOLUTION', 	'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, NULL, NULL);

INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_FACTORY_INVOLUTION', 		'Amount', 			-1), 
('GOLDEN_FACTORY_INVOLUTION', 		'BuildingType', 	'BUILDING_FACTORY'), 
('GOLDEN_FACTORY_INVOLUTION', 		'CityStatesOnly', 	0), 
('GOLDEN_FACTORY_INVOLUTION', 		'YieldType', 		'YIELD_GOLD'),
('GOLDEN_FABRICATION_INVOLUTION', 	'Amount', 			-1), 
('GOLDEN_FABRICATION_INVOLUTION', 	'BuildingType', 	'BUILDING_FABRICATION'), 
('GOLDEN_FABRICATION_INVOLUTION', 	'CityStatesOnly', 	0), 
('GOLDEN_FABRICATION_INVOLUTION', 	'YieldType', 		'YIELD_GOLD'),
('GOLDEN_RAWMATERIAL_INVOLUTION', 	'Amount', 			-1), 
('GOLDEN_RAWMATERIAL_INVOLUTION', 	'BuildingType', 	'BUILDING_RAWMATERIAL'), 
('GOLDEN_RAWMATERIAL_INVOLUTION', 	'CityStatesOnly', 	0), 
('GOLDEN_RAWMATERIAL_INVOLUTION', 	'YieldType', 		'YIELD_GOLD');

-- Electronics factory
INSERT OR REPLACE INTO ImprovementModifiers
(ImprovementType, 						ModifierId) VALUES 
('IMPROVEMENT_QUARRY', 					'GOLDEN_LUXURY_QUARRY_ELECTRONICS_FACTORY_PRODUCTION'),
('IMPROVEMENT_MINE', 					'GOLDEN_LUXURY_MINE_ELECTRONICS_FACTORY_PRODUCTION'),
('IMPROVEMENT_PLANTATION', 				'GOLDEN_LUXURY_PLANTATION_ELECTRONICS_FACTORY_PRODUCTION'),
('IMPROVEMENT_CAMP', 					'GOLDEN_LUXURY_CAMP_ELECTRONICS_FACTORY_PRODUCTION'),
('IMPROVEMENT_FISHING_BOATS', 			'GOLDEN_LUXURY_FISHING_BOATS_ELECTRONICS_FACTORY_PRODUCTION');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_LUXURY_QUARRY_ELECTRONICS_FACTORY_PRODUCTION', 				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_MINE_ELECTRONICS_FACTORY_PRODUCTION', 					'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_FISHING_BOATS_ELECTRONICS_FACTORY_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_CAMP_ELECTRONICS_FACTORY_PRODUCTION', 					'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL),
('GOLDEN_LUXURY_PLANTATION_ELECTRONICS_FACTORY_PRODUCTION', 			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', 0, 0, 0, 'GOLDEN_PLOT_HAS_LUXURY_IS_ADJACENT_TO_BUILDING_FACTORY_REQUIREMENTS', NULL);

INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_LUXURY_QUARRY_ELECTRONICS_FACTORY_PRODUCTION', 				'Amount', 			1), 
('GOLDEN_LUXURY_QUARRY_ELECTRONICS_FACTORY_PRODUCTION', 				'BuildingType', 	'BUILDING_ELECTRONICS_FACTORY'), 
('GOLDEN_LUXURY_QUARRY_ELECTRONICS_FACTORY_PRODUCTION', 				'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_QUARRY_ELECTRONICS_FACTORY_PRODUCTION', 				'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_MINE_ELECTRONICS_FACTORY_PRODUCTION', 					'Amount', 			1), 
('GOLDEN_LUXURY_MINE_ELECTRONICS_FACTORY_PRODUCTION', 					'BuildingType', 	'BUILDING_ELECTRONICS_FACTORY'), 
('GOLDEN_LUXURY_MINE_ELECTRONICS_FACTORY_PRODUCTION', 					'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_MINE_ELECTRONICS_FACTORY_PRODUCTION', 					'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_PLANTATION_ELECTRONICS_FACTORY_PRODUCTION', 			'Amount', 			1), 
('GOLDEN_LUXURY_PLANTATION_ELECTRONICS_FACTORY_PRODUCTION', 			'BuildingType', 	'BUILDING_ELECTRONICS_FACTORY'), 
('GOLDEN_LUXURY_PLANTATION_ELECTRONICS_FACTORY_PRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_PLANTATION_ELECTRONICS_FACTORY_PRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_CAMP_ELECTRONICS_FACTORY_PRODUCTION', 					'Amount', 			1), 
('GOLDEN_LUXURY_CAMP_ELECTRONICS_FACTORY_PRODUCTION', 					'BuildingType', 	'BUILDING_ELECTRONICS_FACTORY'), 
('GOLDEN_LUXURY_CAMP_ELECTRONICS_FACTORY_PRODUCTION', 					'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_CAMP_ELECTRONICS_FACTORY_PRODUCTION', 					'YieldType', 		'YIELD_PRODUCTION'),
('GOLDEN_LUXURY_FISHING_BOATS_ELECTRONICS_FACTORY_PRODUCTION', 			'Amount', 			1), 
('GOLDEN_LUXURY_FISHING_BOATS_ELECTRONICS_FACTORY_PRODUCTION', 			'BuildingType', 	'BUILDING_ELECTRONICS_FACTORY'), 
('GOLDEN_LUXURY_FISHING_BOATS_ELECTRONICS_FACTORY_PRODUCTION', 			'CityStatesOnly', 	0), 
('GOLDEN_LUXURY_FISHING_BOATS_ELECTRONICS_FACTORY_PRODUCTION', 			'YieldType', 		'YIELD_PRODUCTION');

--Assembly line
INSERT OR REPLACE INTO BuildingModifiers (BuildingType, ModifierId) VALUES 
('BUILDING_ASSEMBLYLINE', 'GOLDEN_ASSEMBLYLINE_POPULATION_PRODUCTION');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, NewOnly, OwnerRequirementSetId, SubjectRequirementSetId) VALUES 
('GOLDEN_ASSEMBLYLINE_POPULATION_PRODUCTION', 'MODIFIER_SINGLE_CITY_ADJUST_CITY_YIELD_PER_POPULATION', 0, 0, 0, NULL, NULL);

INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) VALUES 
('GOLDEN_ASSEMBLYLINE_POPULATION_PRODUCTION', 'Amount', 	1), 
('GOLDEN_ASSEMBLYLINE_POPULATION_PRODUCTION', 'YieldType', 'YIELD_PRODUCTION');



--JNR_RENEWABLE
INSERT OR REPLACE INTO RequirementSets
		(RequirementSetId,							RequirementSetType)
VALUES	('GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS',		'REQUIREMENTSET_TEST_ALL');

INSERT OR REPLACE INTO RequirementSetRequirements
		(RequirementSetId,						RequirementId)
VALUES	('GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS',	'REQUIRES_RENEWABLE_ENERGY_COLLECTION_ACTIVE_JNR');

INSERT OR REPLACE INTO Requirements (RequirementId,				RequirementType)
VALUES	('REQUIRES_RENEWABLE_ENERGY_COLLECTION_ACTIVE_JNR',		'REQUIREMENT_CITY_HAS_BUILDING');

INSERT OR REPLACE INTO RequirementArguments (RequirementId,											Name,			Value)
VALUES	('REQUIRES_RENEWABLE_ENERGY_COLLECTION_ACTIVE_JNR',		'BuildingType',	'BUILDING_JNR_RENEWABLE_COLLECTION');
		
INSERT OR REPLACE INTO ImprovementModifiers
		(ImprovementType,					ModifierId)
VALUES	('IMPROVEMENT_GEOTHERMAL_PLANT',	'JNR_RENEWABLE_ENERGY_LESS_POWER_GEOTHERMAL_FISSURE'),
		('IMPROVEMENT_WIND_FARM',			'JNR_RENEWABLE_ENERGY_LESS_POWER_WIND_FARM_COASTAL'),
		('IMPROVEMENT_OFFSHORE_WIND_FARM',	'JNR_RENEWABLE_ENERGY_LESS_POWER_OFFSHORE_WIND_FARM_OCEAN'),
		('IMPROVEMENT_SOLAR_FARM',			'JNR_RENEWABLE_ENERGY_LESS_POWER_SOLAR_FARM_GRASS_DEFAULT'),

		('IMPROVEMENT_GEOTHERMAL_PLANT',	'JNR_RENEWABLE_ENERGY_RESOURCE_GEOTHERMAL_FISSURE'),
		('IMPROVEMENT_WIND_FARM',			'JNR_RENEWABLE_ENERGY_RESOURCE_POWER_WIND_FARM_COASTAL'),
		('IMPROVEMENT_OFFSHORE_WIND_FARM',	'JNR_RENEWABLE_ENERGY_RESOURCE_POWER_OFFSHORE_WIND_FARM_OCEAN'),
		('IMPROVEMENT_SOLAR_FARM',			'JNR_RENEWABLE_ENERGY_RESOURCE_POWER_SOLAR_FARM_DESERT');	
		
INSERT OR REPLACE INTO Modifiers
		(ModifierId,																ModifierType,											SubjectRequirementSetId)
VALUES	('JNR_RENEWABLE_ENERGY_LESS_POWER_GEOTHERMAL_FISSURE',						'MODIFIER_SINGLE_CITY_ADJUST_FREE_POWER',				'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_WIND_FARM_COASTAL',						'MODIFIER_SINGLE_CITY_ADJUST_FREE_POWER',				'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_OFFSHORE_WIND_FARM_OCEAN',				'MODIFIER_SINGLE_CITY_ADJUST_FREE_POWER',				'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_SOLAR_FARM_GRASS_DEFAULT',				'MODIFIER_SINGLE_CITY_ADJUST_FREE_POWER',				'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),


		('JNR_RENEWABLE_ENERGY_RESOURCE_GEOTHERMAL_FISSURE',				'MODIFIER_SINGLE_CITY_ADJUST_FREE_RESOURCE_EXTRACTION',			'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_WIND_FARM_COASTAL',			'MODIFIER_SINGLE_CITY_ADJUST_FREE_RESOURCE_EXTRACTION',			'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_OFFSHORE_WIND_FARM_OCEAN',	'MODIFIER_SINGLE_CITY_ADJUST_FREE_RESOURCE_EXTRACTION',			'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_SOLAR_FARM_DESERT',			'MODIFIER_SINGLE_CITY_ADJUST_FREE_RESOURCE_EXTRACTION',			'GOLDEN_CITY_HAS_ENERGY_COLLECTION_REQUIREMENTS');

INSERT OR REPLACE INTO ModifierArguments
		(ModifierId,																Name,			Value)
VALUES	('JNR_RENEWABLE_ENERGY_LESS_POWER_GEOTHERMAL_FISSURE',						'SourceType',	'FREE_POWER_SOURCE_GEOTHERMAL'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_GEOTHERMAL_FISSURE',						'Amount',		-2),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_WIND_FARM_COASTAL',						'SourceType',	'FREE_POWER_SOURCE_WIND'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_WIND_FARM_COASTAL',						'Amount',		-2),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_OFFSHORE_WIND_FARM_OCEAN',				'SourceType',	'FREE_POWER_SOURCE_WIND'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_OFFSHORE_WIND_FARM_OCEAN',				'Amount',		-2),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_SOLAR_FARM_GRASS_DEFAULT',				'SourceType',	'FREE_POWER_SOURCE_SOLAR'),
		('JNR_RENEWABLE_ENERGY_LESS_POWER_SOLAR_FARM_GRASS_DEFAULT',				'Amount',		-2),

		('JNR_RENEWABLE_ENERGY_RESOURCE_GEOTHERMAL_FISSURE',						'ResourceType',	'RESOURCE_JNR_BATTERY_CHARGE'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_GEOTHERMAL_FISSURE',						'Amount',		1),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_WIND_FARM_COASTAL',					'ResourceType',	'RESOURCE_JNR_BATTERY_CHARGE'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_WIND_FARM_COASTAL',					'Amount',		1),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_OFFSHORE_WIND_FARM_OCEAN',			'ResourceType',	'RESOURCE_JNR_BATTERY_CHARGE'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_OFFSHORE_WIND_FARM_OCEAN',			'Amount',		1),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_SOLAR_FARM_DESERT',					'ResourceType',	'RESOURCE_JNR_BATTERY_CHARGE'),
		('JNR_RENEWABLE_ENERGY_RESOURCE_POWER_SOLAR_FARM_DESERT',					'Amount',		1);

--城邦兼容
--条件
INSERT OR REPLACE INTO RequirementSetRequirements   (RequirementSetId ,         RequirementId)  VALUES      
('GOLDEN_CITY_HAS_DISTRICT_INDUSTRIAL_ZONE_T1_BUILDING_REQUIREMENTS' ,          'GOLDEN_REQUIRES_CITY_HAS_BUILDING_STONEMASON'),
('GOLDEN_CITY_HAS_DISTRICT_INDUSTRIAL_ZONE_T1_BUILDING_REQUIREMENTS' ,          'GOLDEN_REQUIRES_CITY_HAS_BUILDING_SMELTERY'),
('GOLDEN_CITY_HAS_DISTRICT_INDUSTRIAL_ZONE_T2_BUILDING_REQUIREMENTS' ,          'GOLDEN_REQUIRES_CITY_HAS_BUILDING_RAWMATERIAL'),
('GOLDEN_CITY_HAS_DISTRICT_INDUSTRIAL_ZONE_T2_BUILDING_REQUIREMENTS' ,          'GOLDEN_REQUIRES_CITY_HAS_BUILDING_FABRICATION'),
('GOLDEN_CITY_HAS_DISTRICT_INDUSTRIAL_ZONE_T3_BUILDING_REQUIREMENTS' ,       	'GOLDEN_REQUIRES_CITY_HAS_BUILDING_JNR_RENEWABLE_DISTRIBUTION');

INSERT OR REPLACE INTO      Requirements (RequirementId,            RequirementType) VALUES                     
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_STONEMASON',                    'REQUIREMENT_CITY_HAS_BUILDING'),
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_SMELTERY',                      'REQUIREMENT_CITY_HAS_BUILDING'),
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_RAWMATERIAL',                   'REQUIREMENT_CITY_HAS_BUILDING'),
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_FABRICATION',                   'REQUIREMENT_CITY_HAS_BUILDING'),
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_JNR_RENEWABLE_DISTRIBUTION',    'REQUIREMENT_CITY_HAS_BUILDING');

INSERT OR REPLACE INTO      RequirementArguments (RequirementId,Name,               Value) VALUES                       
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_STONEMASON',                'BuildingType',     'BUILDING_STONEMASON'), 
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_SMELTERY',                  'BuildingType',     'BUILDING_SMELTERY'),   
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_RAWMATERIAL',               'BuildingType',     'BUILDING_RAWMATERIAL'),    
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_FABRICATION',               'BuildingType',     'BUILDING_FABRICATION'),
('GOLDEN_REQUIRES_CITY_HAS_BUILDING_JNR_RENEWABLE_DISTRIBUTION','BuildingType',     'BUILDING_JNR_RENEWABLE_DISTRIBUTION');

--GREAT ENGINEERS
INSERT OR REPLACE INTO GreatPersonIndividualActionModifiers (GreatPersonIndividualType, 			ModifierId, AttachmentTargetType) VALUES	
('GREAT_PERSON_INDIVIDUAL_LEONARDO_DA_VINCI',	            'GOLDEN_LEONARDO_DA_VINCI_BUILDING_STONEMASON',           	'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
('GREAT_PERSON_INDIVIDUAL_LEONARDO_DA_VINCI',	            'GOLDEN_LEONARDO_DA_VINCI_BUILDING_SMELTERY',           	'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
('GREAT_PERSON_INDIVIDUAL_JAMES_WATT',	                	'GOLDEN_JAMES_WATT_BUILDING_RAWMATERIAL',       			'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
('GREAT_PERSON_INDIVIDUAL_JAMES_WATT',	                	'GOLDEN_JAMES_WATT_BUILDING_FABRICATION',    				'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
('GREAT_PERSON_INDIVIDUAL_SERGEI_KOROLEV',	                'GOLDEN_SERGEI_KOROLEV_BUILDING_JNR_RENEWABLE_DISTRIBUTION','GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE');

INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES	
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_STONEMASON',      			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',  0, 1, NULL),
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_SMELTERY',      			'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',  0, 1, NULL),
('GOLDEN_JAMES_WATT_BUILDING_RAWMATERIAL',      				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',  0, 1, NULL),
('GOLDEN_JAMES_WATT_BUILDING_FABRICATION',       				'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',  0, 1, NULL),
('GOLDEN_SERGEI_KOROLEV_BUILDING_JNR_RENEWABLE_DISTRIBUTION',   'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE',  0, 1, NULL);

INSERT OR REPLACE INTO ModifierArguments (ModifierId,			Name,		        Value) VALUES
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_STONEMASON',			'BuildingType',	    'BUILDING_STONEMASON'),
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_STONEMASON',			'Amount',	    	3),
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_STONEMASON',			'YieldType',	    'YIELD_PRODUCTION'),
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_SMELTERY',				'BuildingType',	    'BUILDING_SMELTERY'),
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_SMELTERY',				'Amount',	    	3),
('GOLDEN_LEONARDO_DA_VINCI_BUILDING_SMELTERY',				'YieldType',	    'YIELD_PRODUCTION'),
('GOLDEN_JAMES_WATT_BUILDING_RAWMATERIAL',					'BuildingType',	    'BUILDING_RAWMATERIAL'),
('GOLDEN_JAMES_WATT_BUILDING_RAWMATERIAL',					'Amount',	    	4),
('GOLDEN_JAMES_WATT_BUILDING_RAWMATERIAL',					'YieldType',	    'YIELD_PRODUCTION'),
('GOLDEN_JAMES_WATT_BUILDING_FABRICATION',					'BuildingType',	    'BUILDING_FABRICATION'),
('GOLDEN_JAMES_WATT_BUILDING_FABRICATION',					'Amount',	    	4),
('GOLDEN_JAMES_WATT_BUILDING_FABRICATION',					'YieldType',	    'YIELD_PRODUCTION'),
('GOLDEN_SERGEI_KOROLEV_BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'BuildingType',	    'BUILDING_JNR_RENEWABLE_DISTRIBUTION'),
('GOLDEN_SERGEI_KOROLEV_BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'Amount',	    	5),
('GOLDEN_SERGEI_KOROLEV_BUILDING_JNR_RENEWABLE_DISTRIBUTION',	'YieldType',	    'YIELD_PRODUCTION');