--==========================================================================================================================
-- JFD'S MERCENARIES
--==========================================================================================================================
-- Free Company
UPDATE Units
SET JFD_OnlyMercenary = 1, MoveAfterPurchase = 0, Help = 'TXT_KEY_UNIT_MERC_HELP_FREE_COMAPANY', Strategy = 'TXT_KEY_UNIT_MERC_FREE_COMAPANY_STRATEGY'
WHERE Type = 'UNIT_FREE_COMAPANY'
AND EXISTS (SELECT * FROM Technologies WHERE Type = 'TECH_JFD_MERCENARIES');
INSERT OR REPLACE INTO UnitPromotions
(Type, AdjacentMod, AdjacentTileHealChange, AlwaysHeal, Amphib, AttackFortifiedMod, AttackMod, AttackWoundedMod, CanMoveAfterAttacking, CapitalDefenseModifier, CapitalDefenseFalloff, CaptureDefeatedEnemy, CityAttack, CityDefense, CityAttackPlunderModifier, DefenseMod, ExtraAttacks, ExtraNavalMovement, EmbarkExtraVisibility, FlankAttackModifier, FreePillageMoves, HeavyCharge, HillsDoubleMove, HealOutsideFriendly, FriendlyHealChange, NeutralHealChange, EnemyHealChange, GreatGeneralModifier, GoldenAgeValueFromKills, HPHealedIfDestroyEnemy, IgnoreTerrainCost, IgnoreZOC, InterceptionDefenseDamageModifier, MovesChange, NumInterceptionChange, RangeAttackIgnoreLOS, NearbyEnemyCombatMod, NearbyEnemyCombatRange, OpenAttack, RoughAttack, OutsideFriendlyLandsModifier, FriendlyLandsModifier, DropRange, RangeChange, RangedDefenseMod, RivalTerritory, VisibilityChange, Description, Help, JFD_Mercenary, ExperiencePercent, IgnoreGreatGeneralBenefit, CannotBeChosen, Sound, PortraitIndex, IconAtlas, PediaType, PediaEntry)
VALUES ('PROMOTION_JFD_FREE_COMPANY', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'TXT_KEY_CONTRACT_JFD_FREE_COMPANY_DESC', 'TXT_KEY_PROMOTION_JFD_FREE_COMPANY_HELP', 0, -100, 0, 1, null, 58, 'ABILITY_ATLAS', 'PEDIA_ATTRIBUTES', 'TXT_KEY_CONTRACT_JFD_FREE_COMPANY_DESC');
INSERT INTO JFD_Contracts
(Type, Category, PrereqEra, ObsoleteEra, IsSlavery, Rating, Turns, YieldCost, Description, Adjective, Civilopedia, PromotionType)
VALUES ('CONTRACT_JFD_FREE_COMPANY', 'CONTRACT_JFD_MERCENARY', 'ERA_MEDIEVAL', 'ERA_INDUSTRIAL', 0, 3, 25, '[ICON_GOLD]', 'TXT_KEY_CONTRACT_JFD_FREE_COMPANY_DESC', 'TXT_KEY_CONTRACT_JFD_FREE_COMPANY_ADJ', 'TXT_KEY_CONTRACT_JFD_FREE_COMPANY_TEXT', 'PROMOTION_JFD_FREE_COMPANY');
INSERT INTO JFD_Contract_Units
(ContractType, UnitType, UseUniqueIfAvailable)
VALUES ('CONTRACT_JFD_FREE_COMPANY', 'UNIT_FREE_COMAPANY', 0);