INSERT OR REPLACE INTO Types
(Type, Kind)
VALUES ('GOVERNOR_AQUAFARMER', 'KIND_GOVERNOR'),
('GOVERNOR_AQUA_PROMOTION_BASE', 'KIND_GOVERNOR_PROMOTION'),
('GOVERNOR_AQUA_PROMOTION_FISH', 'KIND_GOVERNOR_PROMOTION'),
('GOVERNOR_AQUA_PROMOTION_CRABS', 'KIND_GOVERNOR_PROMOTION'),
('GOVERNOR_AQUA_PROMOTION_WHALES', 'KIND_GOVERNOR_PROMOTION'),
('GOVERNOR_AQUA_PROMOTION_TURTLES', 'KIND_GOVERNOR_PROMOTION'),
('GOVERNOR_AQUA_PROMOTION_REEFS', 'KIND_GOVERNOR_PROMOTION');
INSERT OR REPLACE INTO Governors
(GovernorType, Image, Name, Title, ShortTitle, Description, IdentityPressure, TransitionStrength, PortraitImage, PortraitImageSelected)
VALUES ('GOVERNOR_AQUAFARMER', 'GOVERNOR_CITY_DEFENDER', 'LOC_GOVERNOR_AQUA_NAME', 'LOC_GOVERNOR_AQUA_TITLE', 'LOC_GOVERNOR_AQUA_TITLE', 'LOC_GOVERNOR_AQUA_DESC', -5, 100, 'GovernorNormal_Defender', 'GovernorSelected_Defender');
INSERT OR REPLACE INTO GovernorPromotions
(GovernorPromotionType, Name, Description, Level,Column, BaseAbility)
VALUES ('GOVERNOR_AQUA_PROMOTION_BASE', 'LOC_GOV_AQUA_PROMO_BASE_NAME', 'LOC_GOV_AQUA_PROMO_BASE_DESC', 0, 1, 1),
('GOVERNOR_AQUA_PROMOTION_FISH', 'LOC_GOV_AQUA_PROMO_FISH_NAME', 'LOC_GOV_AQUA_PROMO_FISH_DESC', 1, 0, 0),
('GOVERNOR_AQUA_PROMOTION_CRABS', 'LOC_GOV_AQUA_PROMO_CRABS_NAME', 'LOC_GOV_AQUA_PROMO_CRABS_DESC', 1, 2, 0),
('GOVERNOR_AQUA_PROMOTION_WHALES', 'LOC_GOV_AQUA_PROMO_WHALES_NAME', 'LOC_GOV_AQUA_PROMO_WHALES_DESC', 2, 0, 0),
('GOVERNOR_AQUA_PROMOTION_TURTLES', 'LOC_GOV_AQUA_PROMO_TURTLES_NAME', 'LOC_GOV_AQUA_PROMO_TURTLES_DESC', 2, 2, 0),
('GOVERNOR_AQUA_PROMOTION_REEFS', 'LOC_GOV_AQUA_PROMO_REEFS_NAME', 'LOC_GOV_AQUA_PROMO_REEFS_DESC', 3, 1, 0);
INSERT OR REPLACE INTO GovernorPromotionSets
(GovernorType, GovernorPromotion)
VALUES ('GOVERNOR_AQUAFARMER', 'GOVERNOR_AQUA_PROMOTION_BASE'),
('GOVERNOR_AQUAFARMER', 'GOVERNOR_AQUA_PROMOTION_FISH'),
('GOVERNOR_AQUAFARMER', 'GOVERNOR_AQUA_PROMOTION_CRABS'),
('GOVERNOR_AQUAFARMER', 'GOVERNOR_AQUA_PROMOTION_WHALES'),
('GOVERNOR_AQUAFARMER', 'GOVERNOR_AQUA_PROMOTION_TURTLES'),
('GOVERNOR_AQUAFARMER', 'GOVERNOR_AQUA_PROMOTION_REEFS');
INSERT OR REPLACE INTO GovernorPromotionPrereqs
(GovernorPromotionType, PrereqGovernorPromotion)
VALUES ('GOVERNOR_AQUA_PROMOTION_FISH', 'GOVERNOR_AQUA_PROMOTION_BASE'),
('GOVERNOR_AQUA_PROMOTION_CRABS', 'GOVERNOR_AQUA_PROMOTION_BASE'),
('GOVERNOR_AQUA_PROMOTION_WHALES', 'GOVERNOR_AQUA_PROMOTION_BASE'),
('GOVERNOR_AQUA_PROMOTION_TURTLES', 'GOVERNOR_AQUA_PROMOTION_BASE'),
('GOVERNOR_AQUA_PROMOTION_REEFS', 'GOVERNOR_AQUA_PROMOTION_BASE');
INSERT OR REPLACE INTO GovernorPromotionModifiers
(GovernorPromotionType, ModifierId)
VALUES ('GOVERNOR_AQUA_PROMOTION_BASE', 'AQUA_PROMO_BASE'),
('GOVERNOR_AQUA_PROMOTION_BASE', 'AQUA_PROMO_BASETWO'),
('GOVERNOR_AQUA_PROMOTION_FISH', 'AQUA_PROMO_FISHIDENTITY'),
('GOVERNOR_AQUA_PROMOTION_FISH', 'AQUA_PROMO_FISHBONUS'),
('GOVERNOR_AQUA_PROMOTION_FISH', 'AQUA_PROMO_FISHBONUSTWO'),
('GOVERNOR_AQUA_PROMOTION_CRABS', 'AQUA_PROMO_CRABSIDENTITY'),
('GOVERNOR_AQUA_PROMOTION_CRABS', 'AQUA_PROMO_CRABSBONUS'),
('GOVERNOR_AQUA_PROMOTION_CRABS', 'AQUA_PROMO_CRABSBONUSTWO'),
('GOVERNOR_AQUA_PROMOTION_WHALES', 'AQUA_PROMO_WHALESIDENTITY'),
('GOVERNOR_AQUA_PROMOTION_WHALES', 'AQUA_PROMO_WHALESBONUS'),
('GOVERNOR_AQUA_PROMOTION_WHALES', 'AQUA_PROMO_WHALESBONUSTWO'),
('GOVERNOR_AQUA_PROMOTION_TURTLES', 'AQUA_PROMO_TURTLESIDENTITY'),
('GOVERNOR_AQUA_PROMOTION_TURTLES', 'AQUA_PROMO_TURTLESBONUS'),
('GOVERNOR_AQUA_PROMOTION_TURTLES', 'AQUA_PROMO_TURTLESBONUSTWO'),
('GOVERNOR_AQUA_PROMOTION_REEFS', 'AQUA_PROMO_REEFSIDENTITY'),
('GOVERNOR_AQUA_PROMOTION_REEFS', 'AQUA_PROMO_REEFSBONUS'),
('GOVERNOR_AQUA_PROMOTION_REEFS', 'AQUA_PROMO_REEFSBONUSTWO');
INSERT OR REPLACE INTO Requirements
(RequirementId, RequirementType)
VALUES ('REQUIRES_RESOURCE_IS_FISH', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'),
('REQUIRES_RESOURCE_IS_SHARK', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'), -- Sukritact's Resources
('REQUIRES_RESOURCE_IS_CRABS', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'),
('REQUIRES_RESOURCE_IS_TORTOISE', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'), -- Terra Mirabilis
('REQUIRES_RESOURCE_IS_WHALES', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'),
('REQUIRES_RESOURCE_IS_TURTLES', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'),
('REQUIRES_RESOURCE_IS_REEFS', 'REQUIREMENT_PLOT_RESOURCE_TYPE_MATCHES'),
('REQUIRES_CITY_HAS_LIGHTHOUSE', 'REQUIREMENT_CITY_HAS_BUILDING'),
('REQUIRES_CITY_HAS_SHIPYARD', 'REQUIREMENT_CITY_HAS_BUILDING'),
('REQUIRES_CITY_HAS_SEAPORT', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT OR REPLACE INTO RequirementArguments
(RequirementId, Name, Value)
VALUES ('REQUIRES_RESOURCE_IS_FISH', 'ResourceType', 'RESOURCE_FISH'),
('REQUIRES_RESOURCE_IS_SHARK', 'ResourceType', 'RESOURCE_SUK_SHARK'),
('REQUIRES_RESOURCE_IS_CRABS', 'ResourceType', 'RESOURCE_CRABS'),
('REQUIRES_RESOURCE_IS_TORTOISE', 'ResourceType', 'RESOURCE_TM_TORTOISE'),
('REQUIRES_RESOURCE_IS_WHALES', 'ResourceType', 'RESOURCE_WHALES'),
('REQUIRES_RESOURCE_IS_TURTLES', 'ResourceType', 'RESOURCE_TURTLES'),
('REQUIRES_RESOURCE_IS_REEFS', 'FeatureType', 'FEATURE_REEF'),
('REQUIRES_CITY_HAS_LIGHTHOUSE', 'BuildingType', 'BUILDING_LIGHTHOUSE'),
('REQUIRES_CITY_HAS_SHIPYARD', 'BuildingType', 'BUILDING_SHIPYARD'),
('REQUIRES_CITY_HAS_SEAPORT', 'BuildingType', 'BUILDING_SEAPORT');
INSERT OR REPLACE INTO RequirementSets
(RequirementSetId, RequirementSetType)
VALUES ('RACHA_PLOT_IS_FISH', 'REQUIREMENTSET_TEST_ANY'),
('RACHA_PLOT_IS_CRABS', 'REQUIREMENTSET_TEST_ANY'),
('RACHA_PLOT_IS_WHALES', 'REQUIREMENTSET_TEST_ALL'),
('RACHA_PLOT_IS_TURTLES', 'REQUIREMENTSET_TEST_ALL'),
('RACHA_PLOT_IS_REEFS', 'REQUIREMENTSET_TEST_ALL'),
('RACHA_HARBOUR_BUILDINGS', 'REQUIREMENTSET_TEST_ANY');
INSERT OR REPLACE INTO RequirementSetRequirements
(RequirementSetId, RequirementId)
VALUES ('RACHA_PLOT_IS_FISH', 'REQUIRES_RESOURCE_IS_FISH'),
('RACHA_PLOT_IS_CRABS', 'REQUIRES_RESOURCE_IS_CRABS'),
('RACHA_PLOT_IS_WHALES', 'REQUIRES_RESOURCE_IS_WHALES'),
('RACHA_PLOT_IS_TURTLES', 'REQUIRES_RESOURCE_IS_TURTLES'),
('RACHA_PLOT_IS_REEFS', 'REQUIRES_RESOURCE_IS_REEFS'),
('RACHA_HARBOUR_BUILDINGS', 'REQUIRES_CITY_HAS_LIGHTHOUSE'),
('RACHA_HARBOUR_BUILDINGS', 'REQUIRES_CITY_HAS_SHIPYARD'),
('RACHA_HARBOUR_BUILDINGS', 'REQUIRES_CITY_HAS_SEAPORT');
INSERT OR REPLACE INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementSetId)
VALUES ('AQUA_PROMO_BASE', 'MODIFIER_SINGLE_CITY_CULTURE_BORDER_EXPANSION', NULL),
('AQUA_PROMO_BASETWO', 'MODIFIER_BUILDING_YIELD_CHANGE', NULL),
('AQUA_PROMO_FISHIDENTITY', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL),
('AQUA_PROMO_FISHBONUS', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_FISH'),
('AQUA_PROMO_FISHBONUSTWO', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_FISH'),
('AQUA_PROMO_CRABSIDENTITY', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL),
('AQUA_PROMO_CRABSBONUS', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_CRABS'),
('AQUA_PROMO_CRABSBONUSTWO', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_CRABS'),
('AQUA_PROMO_WHALESIDENTITY', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL),
('AQUA_PROMO_WHALESBONUS', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_WHALES'),
('AQUA_PROMO_WHALESBONUSTWO', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_WHALES'),
('AQUA_PROMO_TURTLESIDENTITY', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL),
('AQUA_PROMO_TURTLESBONUS', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_TURTLES'),
('AQUA_PROMO_TURTLESBONUSTWO', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_TURTLES'),
('AQUA_PROMO_REEFSIDENTITY', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL),
('AQUA_PROMO_REEFSBONUS', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_REEFS'),
('AQUA_PROMO_REEFSBONUSTWO', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'RACHA_PLOT_IS_REEFS');
INSERT OR REPLACE INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('AQUA_PROMO_BASE', 'YieldType', 'MODIFIER_SINGLE_CITY_ADJUST_CITY_GROWTH'), -- +15% growth in this city
('AQUA_PROMO_BASE', 'Amount', 15),
('AQUA_PROMO_BASETWO', 'YieldType', 'YIELD_FOOD'), -- +2 food from lighthouses, shipyards and seaports
('AQUA_PROMO_BASETWO', 'Amount', 2),
('AQUA_PROMO_FISHIDENTITY', 'Amount', -2),
('AQUA_PROMO_FISHBONUS', 'YieldType', 'YIELD_FOOD'),
('AQUA_PROMO_FISHBONUS', 'Amount', 2),
('AQUA_PROMO_FISHBONUSTWO', 'YieldType', 'YIELD_FAITH'),
('AQUA_PROMO_FISHBONUSTWO', 'Amount', 1),
('AQUA_PROMO_CRABSIDENTITY', 'Amount', -2),
('AQUA_PROMO_CRABSBONUS', 'YieldType', 'YIELD_FOOD'),
('AQUA_PROMO_CRABSBONUS', 'Amount', 2),
('AQUA_PROMO_CRABSBONUSTWO', 'YieldType', 'YIELD_GOLD'),
('AQUA_PROMO_CRABSBONUSTWO', 'Amount', 1),
('AQUA_PROMO_WHALESIDENTITY', 'Amount', -2),
('AQUA_PROMO_WHALESBONUS', 'YieldType', 'YIELD_FOOD'),
('AQUA_PROMO_WHALESBONUS', 'Amount', 2),
('AQUA_PROMO_WHALESBONUSTWO', 'YieldType', 'YIELD_SCIENCE'),
('AQUA_PROMO_WHALESBONUSTWO', 'Amount', 1),
('AQUA_PROMO_TURTLESIDENTITY', 'Amount', -2),
('AQUA_PROMO_TURTLESBONUS', 'YieldType', 'YIELD_FOOD'),
('AQUA_PROMO_TURTLESBONUS', 'Amount', 2),
('AQUA_PROMO_TURTLESBONUSTWO', 'YieldType', 'YIELD_SCIENCE'),
('AQUA_PROMO_TURTLESBONUSTWO', 'Amount', 1),
('AQUA_PROMO_REEFSIDENTITY', 'Amount', -2),
('AQUA_PROMO_REEFSBONUS', 'YieldType', 'YIELD_SCIENCE'),
('AQUA_PROMO_REEFSBONUS', 'Amount', 2),
('AQUA_PROMO_REEFSBONUSTWO', 'YieldType', 'YIELD_CULTURE'),
('AQUA_PROMO_REEFSBONUSTWO', 'Amount', 1);