Amani.sql

DELETE FROM GovernorPromotions WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_AMBASSADOR_FOREIGN_INVESTOR';
UPDATE GovernorPromotions SET Column = 2 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE';
UPDATE GovernorPromotions SET Column = 0 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_AMBASSADOR_EMISSARY';
UPDATE GovernorPromotions SET Column = 1 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_LOCAL_INFORMANTS';
UPDATE GovernorPromotions SET Column = 2 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_AMBASSADOR_PUPPETEER';

INSERT OR IGNORE INTO Types (Type, Kind) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID', 'KIND_GOVERNOR_PROMOTION'),
	('GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'KIND_GOVERNOR_PROMOTION');
INSERT OR IGNORE INTO GovernorPromotions (GovernorPromotionType, Name, Description, Level, Column, BaseAbility) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID', 'LOC_GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID_NAME', 'LOC_GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID_DESCRIPTION', 1, 4, 0),
	('GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'LOC_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE_NAME', 'LOC_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE_DESCRIPTION', 2, 3, 0);
INSERT OR IGNORE INTO GovernorPromotionSets (GovernorType, GovernorPromotion) VALUES
	('GOVERNOR_THE_AMBASSADOR', 'GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID'),
	('GOVERNOR_THE_AMBASSADOR', 'GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE');
INSERT OR IGNORE INTO GovernorPromotionPrereqs ( GovernorPromotionType, PrereqGovernorPromotion ) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID', 'GOVERNOR_PROMOTION_AMBASSADOR_MESSENGER'),
	('GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID'),
	('GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE'),
	('GOVERNOR_PROMOTION_LOCAL_INFORMANTS', 'GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE'),
	('GOVERNOR_PROMOTION_AMBASSADOR_PUPPETEER', 'GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE');
	
--шпионы
DELETE FROM GovernorPromotionModifiers WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_LOCAL_INFORMANTS';
INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
	('LOCAL_INFORMANTS_SPY_BONUS', 'MODIFIER_PLAYER_ADJUST_SPY_BONUS');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('LOCAL_INFORMANTS_SPY_BONUS', 'Amount', 1);
INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
	('GOVERNOR_PROMOTION_LOCAL_INFORMANTS', 'LOCAL_INFORMANTS_SPY_BONUS');

INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_EMISSARY', 'PRESTIGE_IDENTITY_PRESSURE_TO_DOMESTIC_CITIES');
UPDATE ModifierArguments SET Value=4 WHERE ModifierId='EMISSARY_IDENTITY_PRESSURE_TO_FOREIGN_CITIES' AND Name='Amount';

-- дипломатическая разведка
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_FAVOR', 'MODIFIER_PLAYER_ADJUST_EXTRA_FAVOR_PER_TURN');
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_FAVOR', 'Amount', 2);
-- DELETE FROM GovernorPromotionModifiers WHERE ModifierId = 'AFFLUENCE_COPY_LUXURIES_FOR_IMPORT';
-- INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
-- 	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_FAVOR');

INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
	('GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_SCIENCE', 'MODIFIER_PLAYER_ADJUST_YIELD_FROM_DELEGATIONS'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_CULTURE', 'MODIFIER_PLAYER_ADJUST_YIELD_FROM_DELEGATIONS'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_SCIENCE', 'MODIFIER_PLAYER_ADJUST_YIELD_FROM_EMBASSIES'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_CULTURE', 'MODIFIER_PLAYER_ADJUST_YIELD_FROM_EMBASSIES');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_SCIENCE', 'YieldType', 'YIELD_SCIENCE'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_SCIENCE', 'Amount', 2),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_CULTURE', 'YieldType', 'YIELD_CULTURE'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_CULTURE', 'Amount', 2),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_SCIENCE', 'YieldType', 'YIELD_SCIENCE'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_SCIENCE', 'Amount', 2),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_CULTURE', 'YieldType', 'YIELD_CULTURE'),
	('GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_CULTURE', 'Amount', 2);
INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_SCIENCE'),
	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_DELEGATION_CULTURE'),
	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_SCIENCE'),
	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_EMBASSY_CULTURE');

-- INSERT OR IGNORE INTO Requirements (RequirementId, RequirementType) VALUES
-- 	('REQUIRES_PLAYER_HAS_DIPLOMATIC_QUARTER', 'REQUIREMENT_PLAYER_HAS_DISTRICT'),
-- 	('REQUIRES_PLAYER_HAS_CONSULATE', 'REQUIREMENT_PLAYER_HAS_BUILDING'),
-- 	('REQUIRES_PLAYER_HAS_CHANCERY', 'REQUIREMENT_PLAYER_HAS_BUILDING');
-- INSERT OR IGNORE INTO RequirementArguments (RequirementId, Name, Value) VALUES
-- 	('REQUIRES_PLAYER_HAS_DIPLOMATIC_QUARTER', 'DistrictType', 'DISTRICT_DIPLOMATIC_QUARTER'),
-- 	('REQUIRES_PLAYER_HAS_CONSULATE', 'BuildingType', 'BUILDING_CONSULATE'),
-- 	('REQUIRES_PLAYER_HAS_CHANCERY', 'BuildingType', 'BUILDING_CHANCERY');
-- INSERT OR IGNORE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
-- 	('PLAYER_HAS_DIPLOMATIC_QUARTER_REQUIREMENTS', 'REQUIREMENTSET_TEST_ANY'),
-- 	('PLAYER_HAS_CONSULATE_REQUIREMENTS', 'REQUIREMENTSET_TEST_ANY'),
-- 	('PLAYER_HAS_CHANCERY_REQUIREMENTS', 'REQUIREMENTSET_TEST_ANY');
-- INSERT OR IGNORE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
-- 	('PLAYER_HAS_DIPLOMATIC_QUARTER_REQUIREMENTS', 'REQUIRES_PLAYER_HAS_DIPLOMATIC_QUARTER'),
-- 	('PLAYER_HAS_CONSULATE_REQUIREMENTS', 'REQUIRES_PLAYER_HAS_CONSULATE'),
-- 	('PLAYER_HAS_CHANCERY_REQUIREMENTS', 'REQUIRES_PLAYER_HAS_CHANCERY');
	
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId) VALUES
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_SCIENCE', 'MODIFIER_PLAYER_ADJUST_YIELD_CHANGE', 'PLAYER_HAS_CONSULATE_REQUIREMENTS'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_CULTURE', 'MODIFIER_PLAYER_ADJUST_YIELD_CHANGE', 'PLAYER_HAS_CONSULATE_REQUIREMENTS'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_SCIENCE', 'MODIFIER_PLAYER_ADJUST_YIELD_CHANGE', 'PLAYER_HAS_CHANCERY_REQUIREMENTS'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_CULTURE', 'MODIFIER_PLAYER_ADJUST_YIELD_CHANGE', 'PLAYER_HAS_CHANCERY_REQUIREMENTS');
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_SCIENCE', 'YieldType', 'YIELD_SCIENCE'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_SCIENCE', 'Amount', 4),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_CULTURE', 'YieldType', 'YIELD_CULTURE'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_CULTURE', 'Amount', 4),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_SCIENCE', 'YieldType', 'YIELD_SCIENCE'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_SCIENCE', 'Amount', 4),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_CULTURE', 'YieldType', 'YIELD_CULTURE'),
-- 	('GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_CULTURE', 'Amount', 4);
-- INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
-- 	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_SCIENCE'),
-- 	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_CONSULATE_CULTURE'),
-- 	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_SCIENCE'),
-- 	('GOVERNOR_PROMOTION_AMBASSADOR_AFFLUENCE', 'GOVERNOR_AMBASSADOR_AFFLUENCE_CHANCERY_CULTURE');

-- страт. ресы и защита города-гос-ва	
INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
	('GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE', 'MODIFIER_PLAYER_CITIES_ADJUST_INNER_DEFENSE');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE', 'Amount', 5);
INSERT OR IGNORE INTO ModifierStrings (ModifierId, Context, Text)
	VALUES ('GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE', 'Preview', 'LOC_GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID_DESCRIPTION');
INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID', 'GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE'),
	('GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID', 'FOREIGN_INVESTOR_COPY_STRATEGICS_FOR_IMPORT'),
	('GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID', 'AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS');

--боевая мощь дружественных войск
INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
	('AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS', 'MODIFIER_CITY_ADJUST_CITY_FRIENDLY_COMBAT_BONUS');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS', 'Amount', 5);
INSERT OR IGNORE INTO ModifierStrings (ModifierId, Context, Text)
	VALUES ('AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS', 'Preview', 'LOC_AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS_DESCRIPTION');

--убираем ненужные эффекты при назначении в свой город
INSERT OR IGNORE INTO Types (Type, Kind) VALUES
	('MODIFIER_PLAYER_ALL_CITIES_ADJUST_INNER_DEFENSE', 'KIND_MODIFIER'),
	('MODIFIER_PLAYER_ALL_CITIES_ADJUST_CITY_FRIENDLY_COMBAT_BONUS', 'KIND_MODIFIER');
INSERT OR IGNORE INTO DynamicModifiers (ModifierType, CollectionType, EffectType) VALUES
	('MODIFIER_PLAYER_ALL_CITIES_ADJUST_INNER_DEFENSE', 'COLLECTION_PLAYER_CITIES', 'EFFECT_ADJUST_CITY_INNER_DEFENSE'),
	('MODIFIER_PLAYER_ALL_CITIES_ADJUST_CITY_FRIENDLY_COMBAT_BONUS', 'COLLECTION_PLAYER_CITIES', 'EFFECT_ADJUST_CITY_FRIENDLY_COMBAT_BONUS');

INSERT OR IGNORE INTO Requirements (RequirementId, RequirementType) VALUES
	('REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID', 'REQUIREMENT_CITY_HAS_SPECIFIC_GOVERNOR_PROMOTION_TYPE');
INSERT OR IGNORE INTO RequirementArguments (RequirementId, Name, Value) VALUES
	('REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID', 'Established', 1),
	('REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID', 'GovernorPromotionType', 'GOVERNOR_PROMOTION_AMBASSADOR_MILITARY_AID');
INSERT OR IGNORE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
	('CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID', 'REQUIREMENTSET_TEST_ALL');
INSERT OR IGNORE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
	('CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID', 'REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID');

INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId) VALUES
	('GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE_NEGATIVE', 'MODIFIER_PLAYER_ALL_CITIES_ADJUST_INNER_DEFENSE', 'CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID'),
	('AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS_NEGATIVE', 'MODIFIER_PLAYER_ALL_CITIES_ADJUST_CITY_FRIENDLY_COMBAT_BONUS', 'CITY_HAS_GOVERNOR_PROMOTION_MILITARY_AID');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE_NEGATIVE', 'Amount', -5),
	('AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS_NEGATIVE', 'Amount', -5);
INSERT OR IGNORE INTO TraitModifiers (TraitType, ModifierId) VALUES
	('TRAIT_LEADER_MAJOR_CIV', 'GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE_NEGATIVE'),
	('TRAIT_LEADER_MAJOR_CIV', 'AMBASSADOR_CITY_FRIENDLY_COMBAT_BONUS_NEGATIVE');
	--('MINOR_CIV_DEFAULT_TRAIT', 'GOVERNOR_AMBASSADOR_MILITARY_AID_CITY_DEFENSE_NEGATIVE');



-- Сателлит
INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
	('GOVERNOR_AMBASSADOR_SATELLITE_INFLUENCE', 'MODIFIER_PLAYER_ADJUST_INFLUENCE_POINTS_PER_TURN');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('GOVERNOR_AMBASSADOR_SATELLITE_INFLUENCE', 'Amount', 4);
INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
	('GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'GOVERNOR_AMBASSADOR_SATELLITE_INFLUENCE');


-- -- ...GOVERNOR_PROMOTION Modifier
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_MODIFIER', 'MODIFIER_SINGLE_CITY_GRANT_LOYALTY');
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_MODIFIER', 'Amount', 0);
-- INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
-- 	('GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'GOVERNOR_AMBASSADOR_SATELLITE_MODIFIER');

-- INSERT INTO Types (Type, Kind) VALUES
-- 	('PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE_B', 'KIND_BUILDING');
-- INSERT INTO Buildings (BuildingType, Name, Cost, InternalOnly) VALUES
-- 	('PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE_B', 'LOC_PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE_B_NAME', 0, 1);

-- INSERT OR IGNORE INTO Requirements (RequirementId, RequirementType, Reverse) VALUES
-- 	('PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'REQUIREMENT_PLAYER_HAS_BUILDING', 0);
-- INSERT OR IGNORE INTO RequirementArguments (RequirementId, Name, Value) VALUES
-- 	('PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'BuildingType', 'PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE_B');
-- INSERT OR IGNORE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
-- 	('PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'REQUIREMENTSET_TEST_ALL');
-- INSERT OR IGNORE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
-- 	('PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE', 'PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE');




-- -- ...Requirements
-- INSERT OR IGNORE INTO Requirements (RequirementId, RequirementType)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'PLAYER_HAS_' || x || '_ENVOYS', 'REQUIREMENT_PLAYER_HAS_GIVEN_INFLUENCE_TOKENS' FROM cnt;
	
-- INSERT OR IGNORE INTO RequirementArguments (RequirementId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'PLAYER_HAS_' || x || '_ENVOYS', 'MinimumTokens', x FROM cnt;

-- INSERT OR IGNORE INTO RequirementSets (RequirementSetId, RequirementSetType)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'PLAYER_HAS_' || x || '_ENVOYS', 'REQUIREMENTSET_TEST_ANY' FROM cnt;

-- INSERT OR IGNORE INTO RequirementSetRequirements (RequirementSetId, RequirementId)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'PLAYER_HAS_' || x || '_ENVOYS', 'PLAYER_HAS_' || x || '_ENVOYS' FROM cnt;

-- -- ...SCIENCE
-- -- INSERT OR IGNORE INTO Requirements (RequirementId, RequirementType)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'PLAYER_HAS_CAMPUS_AND_SCIENTIFIC_SATELLITE_' || x, 'REQUIREMENT_REQUIREMENTSET_IS_MET' FROM cnt;

-- -- INSERT OR IGNORE INTO RequirementArguments (RequirementId, Name, Value)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'PLAYER_HAS_CAMPUS_AND_SCIENTIFIC_SATELLITE_' || x, 'RequirementSetId', 'PLAYER_HAS_SCIENTIFIC_SATELLITE_WITH_MIN_' || x || '_ENVOYS' FROM cnt;

-- -- INSERT OR IGNORE INTO RequirementSets (RequirementSetId, RequirementSetType)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'PLAYER_HAS_CAMPUS_AND_SCIENTIFIC_SATELLITE_' || x, 'REQUIREMENTSET_TEST_ALL' FROM cnt;

-- -- INSERT OR IGNORE INTO RequirementSetRequirements (RequirementSetId, RequirementId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'PLAYER_HAS_CAMPUS_AND_SCIENTIFIC_SATELLITE_' || x, 'PLAYER_HAS_CAMPUS_AND_SCIENTIFIC_SATELLITE_' || x FROM cnt UNION
-- -- 	SELECT 'PLAYER_HAS_CAMPUS_AND_SCIENTIFIC_SATELLITE_' || x, 'REQUIRES_DISTRICT_IS_CAMPUS' FROM cnt;

-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType) VALUES
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_LIBRARY', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_UNIVERSITY', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_LABORATORY', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE'),

-- 	('GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_WRITER', 'MODIFIER_PLAYER_CITIES_ADJUST_GREAT_PERSON_POINT'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_ARTIST', 'MODIFIER_PLAYER_CITIES_ADJUST_GREAT_PERSON_POINT'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_MUSICIAN', 'MODIFIER_PLAYER_CITIES_ADJUST_GREAT_PERSON_POINT'),

-- 	('GOVERNOR_AMBASSADOR_SATELLITE_FAITH', 'MODIFIER_PLAYER_ADJUST_YIELD_CHANGE'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_GOLD', 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_YIELD'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_COMBAT', 'MODIFIER_PLAYER_UNITS_ADJUST_COMBAT_STRENGTH');

-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId) VALUES
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_LIBRARY_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_UNIVERSITY_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_LABORATORY_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),

-- 	('GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_WRITER_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_ARTIST_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_MUSICIAN_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),

-- 	('GOVERNOR_AMBASSADOR_SATELLITE_FAITH_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_GOLD_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER'),
-- 	('GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_ATTACH', 'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER');

-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_' || x, 'YieldType', 'YIELD_SCIENCE' FROM cnt UNION
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_' || x, 'Amount', 100 FROM cnt; --A

-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId, SubjectRequirementSetId)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- 	SELECT
-- 		'GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_ATTACH_' || x,
-- 		'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',
-- 		'PLAYER_HAS_GOVERNOR_PROMOTION_AMBASSADOR_SATELLITE',
-- 		'PLAYER_HAS_' || x || '_ENVOYS'
-- 	FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_ATTACH_' || x, 'ModifierId', 'GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_' || x FROM cnt;

-- -- INSERT OR IGNORE INTO TraitModifiers (TraitType, ModifierId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'MINOR_CIV_SCIENTIFIC_TRAIT', 'GOVERNOR_AMBASSADOR_SATELLITE_SCIENCE_ATTACH_' || x FROM cnt;

-- -- -- ...CULTURE
-- -- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId, SubjectRequirementSetId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 5 UNION ALL SELECT x+5 FROM cnt LIMIT 8)
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_WRITER_' || x, 'MODIFIER_PLAYER_CITIES_ADJUST_GREAT_PERSON_POINT', 'PLAYER_HAS_CULTURAL_SATELLITE_WITH_MIN_' || x || '_ENVOYS', 'BUILDING_IS_AMPHITHEATER' FROM cnt UNION
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_ARTIST_' || x, 'MODIFIER_PLAYER_CITIES_ADJUST_GREAT_PERSON_POINT', 'PLAYER_HAS_CULTURAL_SATELLITE_WITH_MIN_' || x || '_ENVOYS', 'BUILDING_IS_MUSEUM_ART' FROM cnt UNION
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_MUSICIAN_' || x, 'MODIFIER_PLAYER_CITIES_ADJUST_GREAT_PERSON_POINT', 'PLAYER_HAS_CULTURAL_SATELLITE_WITH_MIN_' || x || '_ENVOYS', 'BUILDING_IS_BROADCAST_CENTER' FROM cnt;

-- -- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 5 UNION ALL SELECT x+5 FROM cnt LIMIT 8)
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_WRITER_' || x, 'GreatPersonClassType', 'GREAT_PERSON_CLASS_WRITER' FROM cnt UNION
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_WRITER_' || x, 'Amount', 10 FROM cnt UNION  --A
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_ARTIST_' || x, 'GreatPersonClassType', 'GREAT_PERSON_CLASS_ARTIST' FROM cnt UNION
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_ARTIST_' || x, 'Amount', 10 FROM cnt UNION  --A
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_MUSICIAN_' || x, 'GreatPersonClassType', 'GREAT_PERSON_CLASS_MUSICIAN' FROM cnt UNION
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_CULTURE_MUSICIAN_' || x, 'Amount', 10 FROM cnt;  --A


-- -- ...FAITH
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 30)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x, 'MODIFIER_PLAYER_ADJUST_YIELD_CHANGE' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 30)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x, 'YieldType', 'YIELD_FAITH' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 30)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x, 'Amount', 2 FROM cnt;

-- -- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId, SubjectRequirementSetId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 30)
-- -- 	SELECT
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x || '_ATTACH_MODIFIER',
-- -- 		'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',
-- -- 		'PLAYER_HAS_GOVERNOR_PROMOTION_SATELLITE',
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_' || x || '_REQUIREMENTS'
-- -- 	FROM cnt;
-- -- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 30)
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x || '_ATTACH_MODIFIER', 'ModifierId', 'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x FROM cnt;

-- -- INSERT OR IGNORE INTO TraitModifiers (TraitType, ModifierId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 30)
-- -- 	SELECT 'MINOR_CIV_RELIGIOUS_TRAIT', 'GOVERNOR_AMBASSADOR_SATELLITE_FAITH_' || x || '_ATTACH_MODIFIER' FROM cnt;

-- -- ...GOLD
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 2 UNION ALL SELECT x+2 FROM cnt LIMIT 20)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x, 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_YIELD' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 2 UNION ALL SELECT x+2 FROM cnt LIMIT 20)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x, 'YieldType', 'YIELD_GOLD' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 2 UNION ALL SELECT x+2 FROM cnt LIMIT 20)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x, 'Amount', 100 FROM cnt; --A

-- -- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId, SubjectRequirementSetId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 2 UNION ALL SELECT x+2 FROM cnt LIMIT 20)
-- -- 	SELECT
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x || '_ATTACH_MODIFIER',
-- -- 		'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',
-- -- 		'PLAYER_HAS_GOVERNOR_PROMOTION_SATELLITE',
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_' || x || '_REQUIREMENTS'
-- -- 	FROM cnt;
-- -- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 2 UNION ALL SELECT x+2 FROM cnt LIMIT 20)
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x || '_ATTACH_MODIFIER', 'ModifierId', 'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x FROM cnt;

-- -- INSERT OR IGNORE INTO TraitModifiers (TraitType, ModifierId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 2 UNION ALL SELECT x+2 FROM cnt LIMIT 20)
-- -- 	SELECT 'MINOR_CIV_TRADE_TRAIT', 'GOVERNOR_AMBASSADOR_SATELLITE_GOLD_' || x || '_ATTACH_MODIFIER' FROM cnt;

-- -- ...PRODUCTION
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x, 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x, 'YieldType', 'YIELD_PRODUCTION' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x, 'Amount', 100 FROM cnt; --A

-- -- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId, SubjectRequirementSetId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- -- 	SELECT
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x || '_ATTACH_MODIFIER',
-- -- 		'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',
-- -- 		'PLAYER_HAS_GOVERNOR_PROMOTION_SATELLITE',
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_' || x || '_REQUIREMENTS'
-- -- 	FROM cnt;
-- -- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x || '_ATTACH_MODIFIER', 'ModifierId', 'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x FROM cnt;

-- -- INSERT OR IGNORE INTO TraitModifiers (TraitType, ModifierId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 1 UNION ALL SELECT x+1 FROM cnt LIMIT 40)
-- -- 	SELECT 'MINOR_CIV_INDUSTRIAL_TRAIT', 'GOVERNOR_AMBASSADOR_SATELLITE_PRODUCTION_' || x || '_ATTACH_MODIFIER' FROM cnt;

-- -- ...MILITARY
-- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x, 'MODIFIER_PLAYER_UNITS_ADJUST_COMBAT_STRENGTH' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x, 'YieldType', 'YIELD_PRODUCTION' FROM cnt;
-- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x, 'Amount', 10 FROM cnt; --A

-- -- INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId, SubjectRequirementSetId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x || '_ATTACH_MODIFIER',
-- -- 		'MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',
-- -- 		'PLAYER_HAS_GOVERNOR_PROMOTION_SATELLITE',
-- -- 		'GOVERNOR_AMBASSADOR_SATELLITE_' || x || '_REQUIREMENTS'
-- -- 	FROM cnt;
-- -- INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x || '_ATTACH_MODIFIER', 'ModifierId', 'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x FROM cnt;

-- -- INSERT OR IGNORE INTO TraitModifiers (TraitType, ModifierId)
-- -- 	WITH RECURSIVE cnt(x) AS (SELECT 4 UNION ALL SELECT x+4 FROM cnt LIMIT 10)
-- -- 	SELECT 'MINOR_CIV_MILITARISTIC_TRAIT', 'GOVERNOR_AMBASSADOR_SATELLITE_COMBAT_' || x || '_ATTACH_MODIFIER' FROM cnt;

-- INSERT OR IGNORE INTO ModifierStrings (ModifierId, Context, Text)
-- 	VALUES ('GOVERNOR_AMBASSADOR_SATELLITE_COMBAT', 'Preview', 'LOC_AMBASSADOR_SATELLITE_COMBAT_BONUS_DESCRIPTION');