--==========================================================================================================================
-- BUILDINGS
--==========================================================================================================================
-- Buildings (NEW)
------------------------------
INSERT INTO Buildings
(Type, BuildingClass, Cost, GoldMaintenance, PrereqTech, Description, Civilopedia, Help, Strategy, NeverCapture, TrainedFreePromotion, SpecialistType, SpecialistCount, ArtDefineTag, MinAreaSize, ConquestProb, HurryCostModifier, PortraitIndex, IconAtlas, CitySupplyFlat)
SELECT ('BUILDING_PRUSSIAN_KRIEGSSCHULE'), BuildingClass, Cost-250, GoldMaintenance, 'TECH_METALLURGY', ('TXT_KEY_BUILDING_PRUSSIAN_KRIEGSSCHULE'), ('TXT_KEY_CIV5_BUILDINGS_PRUSSIAN_KRIEGSSCHULE_TEXT'), ('TXT_KEY_BUILDING_PRUSSIAN_KRIEGSSCHULE_HELP'), ('TXT_KEY_BUILDING_PRUSSIAN_KRIEGSSCHULE_STRATEGY'), NeverCapture, 'PROMOTION_PRUSSIAN_DISCIPLINE', 'SPECIALIST_SCIENTIST', SpecialistCount+1, ArtDefineTag, MinAreaSize, ConquestProb, HurryCostModifier, 0, ('JFD_PRUSSIA_FOR_VP_ATLAS'), CitySupplyFlat
FROM Buildings WHERE (Type = 'BUILDING_MILITARY_ACADEMY');
------------------------------
-- Building_Flavors (NEW)
------------------------------
INSERT INTO Building_Flavors
(BuildingType, FlavorType, Flavor)
VALUES ('BUILDING_PRUSSIAN_KRIEGSSCHULE', 'FLAVOR_MILITARY_TRAINING', 25),
('BUILDING_PRUSSIAN_KRIEGSSCHULE', 'FLAVOR_CULTURE', 15);
------------------------------
-- Building_ClassesNeededInCity (NEW)
------------------------------
INSERT INTO Building_ClassesNeededInCity
(BuildingType, BuildingClassType)
SELECT ('BUILDING_PRUSSIAN_KRIEGSSCHULE'), BuildingClassType
FROM Building_ClassesNeededInCity WHERE (BuildingType = 'BUILDING_MILITARY_ACADEMY');
------------------------------
-- Building_YieldChanges (NEW)
------------------------------
INSERT INTO Building_YieldChanges
(BuildingType, YieldType, Yield)
VALUES ('BUILDING_PRUSSIAN_KRIEGSSCHULE', 'YIELD_SCIENCE', 5),
('BUILDING_PRUSSIAN_KRIEGSSCHULE', 'YIELD_CULTURE', 4);
------------------------------
-- Building_DomainFreeExperiences (NEW)
------------------------------
INSERT INTO Building_DomainFreeExperiences
(BuildingType, DomainType, Experience)
SELECT ('BUILDING_PRUSSIAN_KRIEGSSCHULE'), DomainType, Experience
FROM Building_DomainFreeExperiences WHERE (BuildingType = 'BUILDING_MILITARY_ACADEMY');
------------------------------
-- Building_DomainProductionModifiers (NEW)
------------------------------
INSERT INTO Building_DomainProductionModifiers
(BuildingType, DomainType, Modifier)
SELECT ('BUILDING_PRUSSIAN_KRIEGSSCHULE'), DomainType, Modifier
FROM Building_DomainProductionModifiers WHERE (BuildingType = 'BUILDING_MILITARY_ACADEMY');
------------------------------
-- Building_SpecialistYieldChangesLocal (NEW)
------------------------------
/*INSERT INTO Building_SpecialistYieldChangesLocal
(BuildingType, SpecialistType, YieldType, Yield)
VALUES ('BUILDING_PRUSSIAN_KRIEGSSCHULE', 'SPECIALIST_SCIENTIST', 'YIELD_GREAT_GENERAL_POINTS', 1);*/
--==========================================================================================================================
-- PROMOTIONS
--==========================================================================================================================
-- UnitPromotions
------------------------------
INSERT INTO UnitPromotions
(Type, Description, Help, Sound, CannotBeChosen, IgnoreZOC, LostWithUpgrade, NearbyEnemyCombatMod, NearbyEnemyCombatRange, MovesChange, AoEDamageOnMove, ExperiencePercent, GoldenAgeValueFromKills, PortraitIndex, IconAtlas, PediaType, PediaEntry)
VALUES ('PROMOTION_JFD_DEATHS_HEAD', 'TXT_KEY_PROMOTION_JFD_DEATHS_HEAD', 'TXT_KEY_PROMOTION_JFD_DEATHS_HEAD_HELP', 'AS2D_IF_LEVELUP', 1, 1, 0, -10, 2, 0, 2, 0, 0, 59, 'ABILITY_ATLAS', 'PEDIA_ATTRIBUTES', 'TXT_KEY_PROMOTION_JFD_DEATHS_HEAD'),
('PROMOTION_PRUSSIAN_DISCIPLINE', 'TXT_KEY_PROMOTION_PRUSSIAN_DISCIPLINE', 'TXT_KEY_PROMOTION_PRUSSIAN_DISCIPLINE_HELP', 'AS2D_IF_LEVELUP', 1, 0, 0, 0, 0, 1, 0, 0, 100, 59, 'ABILITY_ATLAS', 'PEDIA_MELEE', 'TXT_KEY_PROMOTION_PRUSSIAN_DISCIPLINE');
--------------------------------
-- UnitPromotions_UnitCombats
--------------------------------
INSERT INTO UnitPromotions_UnitCombats
(PromotionType, UnitCombatType)
VALUES ('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_MELEE'),
('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_GUN');
--------------------------------
-- UnitPromotions_CombatModPerAdjacentUnitCombat
--------------------------------
INSERT INTO UnitPromotions_CombatModPerAdjacentUnitCombat
(PromotionType, UnitCombatType, Modifier)
VALUES ('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_MELEE', 10),
('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_GUN', 10);
--==========================================================================================================================
-- UNITS
--==========================================================================================================================
-- Units
--------------------------------
-- Deaths Head Hussar is disabled and only gifted by city states, and is now based on the Cuirassier (ie is ranged)
INSERT INTO Units
(Type, Class, PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, GoodyHutUpgradeUnitClass, CombatLimit, ObsoleteTech, XPValueDefense, UnitArtInfo, UnitFlagIconOffset, UnitFlagAtlas, PortraitIndex, IconAtlas, MoveRate, PurchaseCooldown, MinorCivGift)
SELECT 'UNIT_JFD_DEATHS_HEAD', 'UNITCLASS_DEATHS_HEAD', PrereqTech, Combat+5, RangedCombat+5, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, 'TXT_KEY_UNIT_JFD_DEATHS_HEAD', 'TXT_KEY_CIV5_JFD_DEATHS_HEAD_TEXT', 'TXT_KEY_UNIT_JFD_DEATHS_HEAD_STRATEGY', 'TXT_KEY_UNIT_HELP_JFD_DEATHS_HEAD', MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, GoodyHutUpgradeUnitClass, CombatLimit, 'TECH_BALLISTICS', XPValueDefense, 'ART_DEF_UNIT_JFD_DEATHS_HEAD', 0, 'JFD_UNIT_FLAG_DEATHS_HEAD_ATLAS', 3, 'JFD_PRUSSIA_ATLAS', MoveRate, PurchaseCooldown, 1
FROM Units WHERE Type = 'UNIT_CUIRASSIER';
INSERT INTO Units
(Type, Class, PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, CombatLimit, ObsoleteTech, XPValueDefense, GoodyHutUpgradeUnitClass, UnitArtInfo, UnitFlagIconOffset, UnitFlagAtlas, PortraitIndex, IconAtlas, PurchaseCooldown)
SELECT 'UNIT_JFD_LANDWEHR', Class, PrereqTech, Combat+4, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, CombatClass, Domain, DefaultUnitAI, 'TXT_KEY_UNIT_JFD_LANDWEHR', 'TXT_KEY_CIV5_JFD_LANDWEHR_TEXT', 'TXT_KEY_UNIT_JFD_LANDWEHR_STRATEGY', 'TXT_KEY_UNIT_HELP_JFD_LANDWEHR', MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, CombatLimit, 'TECH_COMBINED_ARMS', XPValueDefense, GoodyHutUpgradeUnitClass, 'ART_DEF_UNIT_JFD_LANDWEHR', 0, 'JFD_UNIT_FLAG_LANDWEHR_ATLAS', 2, 'JFD_PRUSSIA_ATLAS', PurchaseCooldown
FROM Units WHERE Type = 'UNIT_RIFLEMAN';
--------------------------------
-- UnitGameplay2DScripts
--------------------------------
INSERT INTO UnitGameplay2DScripts
(UnitType, SelectionSound, FirstSelectionSound)
SELECT 'UNIT_JFD_DEATHS_HEAD', SelectionSound, FirstSelectionSound
FROM UnitGameplay2DScripts WHERE UnitType = 'UNIT_CUIRASSIER';
INSERT INTO UnitGameplay2DScripts
(UnitType, SelectionSound, FirstSelectionSound)
SELECT 'UNIT_JFD_LANDWEHR', SelectionSound, FirstSelectionSound
FROM UnitGameplay2DScripts WHERE UnitType = 'UNIT_RIFLEMAN';
--------------------------------
-- Unit_AITypes
--------------------------------
INSERT INTO Unit_AITypes
(UnitType, UnitAIType)
SELECT 'UNIT_JFD_DEATHS_HEAD', UnitAIType
FROM Unit_AITypes WHERE UnitType = 'UNIT_CUIRASSIER';
INSERT INTO Unit_AITypes
(UnitType, UnitAIType)
SELECT 'UNIT_JFD_LANDWEHR', UnitAIType
FROM Unit_AITypes WHERE UnitType = 'UNIT_RIFLEMAN';
--------------------------------
-- Unit_ClassUpgrades
--------------------------------
INSERT INTO Unit_ClassUpgrades
(UnitType, UnitClassType)
SELECT 'UNIT_JFD_DEATHS_HEAD', UnitClassType
FROM Unit_ClassUpgrades WHERE UnitType = 'UNIT_CUIRASSIER';
INSERT INTO Unit_ClassUpgrades
(UnitType, UnitClassType)
SELECT 'UNIT_JFD_LANDWEHR', UnitClassType
FROM Unit_ClassUpgrades WHERE UnitType = 'UNIT_RIFLEMAN';
--------------------------------
-- Unit_ResourceQuantityRequirements
--------------------------------
INSERT INTO Unit_ResourceQuantityRequirements
(UnitType, ResourceType)
SELECT 'UNIT_JFD_DEATHS_HEAD', ResourceType
FROM Unit_ResourceQuantityRequirements WHERE UnitType = 'UNIT_CUIRASSIER';
--------------------------------
-- Unit_Flavors
--------------------------------
INSERT INTO Unit_Flavors
(UnitType, FlavorType, Flavor)
SELECT 'UNIT_JFD_DEATHS_HEAD', FlavorType, Flavor+2
FROM Unit_Flavors WHERE UnitType = 'UNIT_CUIRASSIER';
INSERT INTO Unit_Flavors
(UnitType, FlavorType, Flavor)
SELECT 'UNIT_JFD_LANDWEHR', FlavorType, Flavor+2
FROM Unit_Flavors WHERE UnitType = 'UNIT_RIFLEMAN';
--------------------------------
-- Unit_FreePromotions
--------------------------------
INSERT INTO Unit_FreePromotions
(UnitType, PromotionType)
SELECT 'UNIT_JFD_DEATHS_HEAD', PromotionType
FROM Unit_FreePromotions WHERE UnitType = 'UNIT_CUIRASSIER';
INSERT INTO Unit_FreePromotions
(UnitType, PromotionType)
VALUES ('UNIT_JFD_DEATHS_HEAD', 'PROMOTION_JFD_DEATHS_HEAD');
INSERT INTO Unit_FreePromotions
(UnitType, PromotionType)
SELECT 'UNIT_JFD_LANDWEHR', PromotionType
FROM Unit_FreePromotions WHERE UnitType = 'UNIT_RIFLEMAN';
INSERT INTO Unit_FreePromotions -- Landwehr now gets Stalwart
(UnitType, PromotionType)
VALUES ('UNIT_JFD_LANDWEHR', 'PROMOTION_DRILL_4');
--==========================================================================================================================
-- UNIT CLASS
--==========================================================================================================================
-- UnitClasses
--------------------------------
INSERT INTO UnitClasses
(Type, Description, DefaultUnit)
VALUES ('UNITCLASS_DEATHS_HEAD', 'TXT_KEY_UNIT_JFD_DEATHS_HEAD', 'UNIT_JFD_DEATHS_HEAD');
--==========================================================================================================================
-- EVENTS
--==========================================================================================================================
-- Events (NEW)
--------------------------------
INSERT INTO Events
(Type, EventClass, Description, Help, EventArt, RandomChance, RandomChanceDelta, IsOneShot, NumChoices, RequiredCiv)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR', 'EVENT_CLASS_CIV_SPECIFIC', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_HELP', 'Event_Prussia_PotatoWar.dds', 15, 1, 0, 2, 'CIVILIZATION_JFD_PRUSSIA'),
('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'EVENT_CLASS_CIV_SPECIFIC', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_HELP', 'Event_Prussia_Clausewitz.dds', 5, 2, 1, 1, 'CIVILIZATION_JFD_PRUSSIA');
UPDATE Events SET EraScaling = 1, RequiredEra = 'ERA_RENAISSANCE', ObsoleteEra = 'ERA_MODERN', RequiresWar = 1, EventCooldown = 20 WHERE Type = 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR';
UPDATE Events SET RequiredEra = 'ERA_RENAISSANCE' WHERE Type = 'PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ';
--------------------------------
-- Event_MinimumStartYield (NEW)
--------------------------------
INSERT INTO Event_MinimumStartYield
(EventType, YieldType, Yield)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR', 'YIELD_GOLD', 40);
--------------------------------
-- EventChoices (NEW)
--------------------------------
INSERT INTO EventChoices
(Type, Description, Help, IsOneShot, EventDuration)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_1', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_1', 0, 15),
('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_2', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_2', 0, -1),
('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_HELP', 0, -1);
UPDATE EventChoices SET EraScaling = 1, YieldBonusAllCities = 1 WHERE Type = 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2';
--------------------------------
-- Event_ParentEvents (NEW)
--------------------------------
INSERT INTO Event_ParentEvents
(EventChoiceType, EventType)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR'),
('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR'),
('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ');
--------------------------------
-- EventChoice_InstantYield (NEW)
--------------------------------
INSERT INTO EventChoice_InstantYield
(EventChoiceType, YieldType, Yield)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'YIELD_FOOD', -10);
--------------------------------
-- EventChoice_EventCostYield (NEW)
--------------------------------
INSERT INTO EventChoice_EventCostYield
(EventChoiceType, YieldType, Yield)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'YIELD_GOLD', 40);
--------------------------------
-- EventChoice_MinimumStartYield (NEW)
--------------------------------
INSERT INTO EventChoice_MinimumStartYield
(EventChoiceType, YieldType, Yield)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'YIELD_GOLD', 40);
--------------------------------
-- EventChoice_Notification (NEW)
--------------------------------
INSERT INTO EventChoice_Notification
(EventChoiceType, NotificationType, Description, ShortDescription, IsWorldEvent)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'NOTIFICATION_GENERIC', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_1_NOTIFICATION', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_CHOICE_1_S', 0),
('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'NOTIFICATION_GENERIC', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_2_NOTIFICATION', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_CHOICE_2_S', 0),
('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'NOTIFICATION_GENERIC', 'TXT_KEY_WORLD_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 1);
--------------------------------
-- EventChoiceFlavors (NEW)
--------------------------------
INSERT INTO EventChoiceFlavors
(EventChoiceType, FlavorType, Flavor)
VALUES ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'FLAVOR_OFFENSE', -5),
('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'FLAVOR_DEFENSE', -5),
('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'FLAVOR_GROWTH', -5),
('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'FLAVOR_GOLD', -5),
('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'FLAVOR_MILITARY_TRAINING', 10);
--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Leaders
--------------------------------
INSERT INTO Leaders
(Type, Description, Civilopedia, CivilopediaTag, ArtDefineTag, VictoryCompetitiveness, WonderCompetitiveness, MinorCivCompetitiveness, Boldness, DiploBalance, WarmongerHate, DenounceWillingness, DoFWillingness, Loyalty, Neediness, Forgiveness, Chattiness, Meanness, IconAtlas, PortraitIndex)
VALUES ('LEADER_JFD_FREDERICK', 'TXT_KEY_LEADER_JFD_FREDERICK_DESC', 'TXT_KEY_LEADER_JFD_FREDERICK_PEDIA', 'TXT_KEY_CIVILOPEDIA_LEADERS_JFD_FREDERICK', 'Janboruta_Frederick_Scene.xml', 9, 8, 6, 7, 8, 6, 4, 7, 8, 5, 5, 4, 3, 'JFD_PRUSSIA_ATLAS', 1);
-- By-pass VP's leader compatibility trigger
UPDATE Leaders SET VictoryCompetitiveness = 9, WonderCompetitiveness = 8, MinorCivCompetitiveness = 6, Boldness = 7, DiploBalance = 8, WarmongerHate = 6, DenounceWillingness = 4, DoFWillingness = 7, Loyalty = 8, Neediness = 5, Forgiveness = 5, Chattiness = 4, Meanness = 3, Personality = 'PERSONALITY_EXPANSIONIST' WHERE Type = 'LEADER_JFD_FREDERICK';
--------------------------------
-- Leader_MajorCivApproachBiases
--------------------------------
INSERT INTO Leader_MajorCivApproachBiases
(LeaderType, MajorCivApproachType, Bias)
VALUES ('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_WAR', 4),
('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_HOSTILE', 4),
('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_DECEPTIVE', 4),
('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_GUARDED', 4),
('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_AFRAID', 3),
('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_FRIENDLY', 8),
('LEADER_JFD_FREDERICK', 'MAJOR_CIV_APPROACH_NEUTRAL', 8);
--------------------------------
-- Leader_MajorCivApproachBiases
--------------------------------
INSERT INTO Leader_MinorCivApproachBiases
(LeaderType, MinorCivApproachType, Bias)
VALUES ('LEADER_JFD_FREDERICK', 'MINOR_CIV_APPROACH_IGNORE', 6),
('LEADER_JFD_FREDERICK', 'MINOR_CIV_APPROACH_FRIENDLY', 6),
('LEADER_JFD_FREDERICK', 'MINOR_CIV_APPROACH_PROTECTIVE', 6),
('LEADER_JFD_FREDERICK', 'MINOR_CIV_APPROACH_CONQUEST', 5),
('LEADER_JFD_FREDERICK', 'MINOR_CIV_APPROACH_BULLY', 4);
--------------------------------
-- Leader_Flavors
--------------------------------
INSERT INTO Leader_Flavors
(LeaderType, FlavorType, Flavor)
VALUES ('LEADER_JFD_FREDERICK', 'FLAVOR_OFFENSE', 9),
('LEADER_JFD_FREDERICK', 'FLAVOR_DEFENSE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_CITY_DEFENSE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_MILITARY_TRAINING', 9),
('LEADER_JFD_FREDERICK', 'FLAVOR_RECON', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_RANGED', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_MOBILE', 7),
('LEADER_JFD_FREDERICK', 'FLAVOR_NAVAL', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_NAVAL_RECON', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_NAVAL_GROWTH', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_NAVAL_TILE_IMPROVEMENT', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_AIR', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_EXPANSION', 7),
('LEADER_JFD_FREDERICK', 'FLAVOR_GROWTH', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_TILE_IMPROVEMENT', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_INFRASTRUCTURE', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_PRODUCTION', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_GOLD', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_SCIENCE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_CULTURE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_HAPPINESS', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_GREAT_PEOPLE', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_WONDER', 6),
('LEADER_JFD_FREDERICK', 'FLAVOR_RELIGION', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_DIPLOMACY', 8),
('LEADER_JFD_FREDERICK', 'FLAVOR_SPACESHIP', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_WATER_CONNECTION', 4),
('LEADER_JFD_FREDERICK', 'FLAVOR_NUKE', 2),
('LEADER_JFD_FREDERICK', 'FLAVOR_USE_NUKE', 2),
('LEADER_JFD_FREDERICK', 'FLAVOR_ESPIONAGE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_AIRLIFT', 2),
('LEADER_JFD_FREDERICK', 'FLAVOR_I_TRADE_DESTINATION', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_I_TRADE_ORIGIN', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_I_SEA_TRADE_ROUTE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_I_LAND_TRADE_ROUTE', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_ARCHAEOLOGY', 5),
('LEADER_JFD_FREDERICK', 'FLAVOR_AIR_CARRIER', 5);
--------------------------------
-- Leader_Traits
--------------------------------
INSERT INTO Leader_Traits
(LeaderType, TraitType)
VALUES ('LEADER_JFD_FREDERICK', 'TRAIT_JFD_PRUSSIA');
--==========================================================================================================================
-- TRAITS
--==========================================================================================================================
-- Traits
--------------------------------
INSERT INTO Traits
(Type, Description, ShortDescription)
VALUES ('TRAIT_JFD_PRUSSIA', 'TXT_KEY_TRAIT_JFD_PRUSSIA', 'TXT_KEY_TRAIT_JFD_PRUSSIA_SHORT');
--------------------------------
-- Trait_GoldenAgeFromGreatPersonBirth (NEW)
--------------------------------
INSERT INTO Trait_GoldenAgeFromGreatPersonBirth
(TraitType, GreatPersonType, GoldenAgeTurns)
VALUES ('TRAIT_JFD_PRUSSIA', 'GREATPERSON_GENERAL', 5);
--------------------------------
-- Trait_DomainFreeExperienceModifier (NEW)
--------------------------------
INSERT INTO Trait_DomainFreeExperienceModifier
(TraitType, DomainType, Modifier)
VALUES ('TRAIT_JFD_PRUSSIA', 'DOMAIN_LAND', 100),
('TRAIT_JFD_PRUSSIA', 'DOMAIN_SEA', 100),
('TRAIT_JFD_PRUSSIA', 'DOMAIN_AIR', 100);
--------------------------------
-- Trait_BuildingClassYieldChanges (NEW)
--------------------------------
/*INSERT INTO Trait_BuildingClassYieldChanges
(TraitType, BuildingClassType, YieldType, YieldChange)
VALUES ('TRAIT_JFD_PRUSSIA', 'BUILDINGCLASS_BARRACKS', 'YIELD_GREAT_GENERAL_POINTS', 1),
('TRAIT_JFD_PRUSSIA', 'BUILDINGCLASS_ARMORY', 'YIELD_GREAT_GENERAL_POINTS', 1),
('TRAIT_JFD_PRUSSIA', 'BUILDINGCLASS_MILITARY_ACADEMY', 'YIELD_GREAT_GENERAL_POINTS', 1);*/
--------------------------------
-- Trait_CombatModifierOnWar (NEW) (Requires DLL changes, scrapped and stashed for another civ)
--------------------------------
/*INSERT INTO Trait_CombatModifierOnWar
(TraitType, Modifier, Turns)
VALUES ('TRAIT_JFD_PRUSSIA', 25, 5);*/
------------------------------
-- Policies (NEW)
------------------------------
INSERT INTO Policies
(Type, Description)
VALUES ('POLICY_JFD_PRUSSIA', 'TXT_KEY_TRAIT_JFD_PRUSSIA_SHORT');
------------------------------
-- Policy_BuildingClassProductionModifiers (NEW)
------------------------------
INSERT INTO Policy_BuildingClassProductionModifiers
(PolicyType, BuildingClassType, ProductionModifier)
VALUES ('POLICY_JFD_PRUSSIA', 'BUILDINGCLASS_BARRACKS', 50),
('POLICY_JFD_PRUSSIA', 'BUILDINGCLASS_ARMORY', 50),
('POLICY_JFD_PRUSSIA', 'BUILDINGCLASS_MILITARY_ACADEMY', 50);
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Civilizations
--------------------------------
INSERT INTO Civilizations
(Type, DerivativeCiv, Description, ShortDescription, Adjective, Civilopedia, CivilopediaTag, DefaultPlayerColor, ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, IconAtlas, PortraitIndex, AlphaIconAtlas, SoundtrackTag, MapImage, DawnOfManQuote, DawnOfManImage)
SELECT 'CIVILIZATION_JFD_PRUSSIA', 'CIVILIZATION_GERMANY', 'TXT_KEY_CIV_JFD_PRUSSIA_DESC', 'TXT_KEY_CIV_JFD_PRUSSIA_SHORT_DESC', 'TXT_KEY_CIV_JFD_PRUSSIA_ADJECTIVE', 'TXT_KEY_CIV5_JFD_PRUSSIA_TEXT_1', 'TXT_KEY_CIV5_JFD_PRUSSIA', 'PLAYERCOLOR_JFD_PRUSSIA', ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, 'JFD_PRUSSIA_ATLAS', 0, 'JFD_PRUSSIA_ALPHA_ATLAS', 'Germany', 'Janboruta_MapPrussia512.dds', 'TXT_KEY_CIV5_DOM_JFD_FREDERICK_TEXT', 'Janboruta_Frederick_DOM.dds'
FROM Civilizations WHERE Type = 'CIVILIZATION_GERMANY';
--------------------------------
-- Civilization_CityNames
--------------------------------
INSERT INTO Civilization_CityNames
(CivilizationType, CityName)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_01'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_02'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_03'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_04'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_05'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_06'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_07'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_08'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_09'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_10'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_11'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_12'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_13'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_14'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_15'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_16'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_17'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_18'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_19'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_20'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_21'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_22'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_23'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_24'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_25'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_26'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_27'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_28'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_29'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_30'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_31'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_32'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_CITY_NAME_JFD_PRUSSIA_33');
--------------------------------
-- Civilization_FreeBuildingClasses
--------------------------------
INSERT INTO Civilization_FreeBuildingClasses
(CivilizationType, BuildingClassType)
SELECT 'CIVILIZATION_JFD_PRUSSIA', BuildingClassType
FROM Civilization_FreeBuildingClasses WHERE CivilizationType = 'CIVILIZATION_GERMANY';
--------------------------------
-- Civilization_FreeTechs
--------------------------------
INSERT INTO Civilization_FreeTechs
(CivilizationType, TechType)
SELECT 'CIVILIZATION_JFD_PRUSSIA', TechType
FROM Civilization_FreeTechs WHERE CivilizationType = 'CIVILIZATION_GERMANY';
--------------------------------
-- Civilization_FreeUnits
--------------------------------
INSERT INTO Civilization_FreeUnits
(CivilizationType, UnitClassType, Count, UnitAIType)
SELECT 'CIVILIZATION_JFD_PRUSSIA', UnitClassType, Count, UnitAIType
FROM Civilization_FreeUnits WHERE CivilizationType = 'CIVILIZATION_GERMANY';
--------------------------------
-- Civilization_Leaders
--------------------------------
INSERT INTO Civilization_Leaders
(CivilizationType, LeaderheadType)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'LEADER_JFD_FREDERICK');
--------------------------------
-- Civilization_UnitClassOverrides
--------------------------------
INSERT INTO Civilization_UnitClassOverrides
(CivilizationType, UnitClassType, UnitType)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'UNITCLASS_RIFLEMAN', 'UNIT_JFD_LANDWEHR');
--------------------------------
-- Civilization_BuildingClassOverrides (NEW)
--------------------------------
INSERT INTO Civilization_BuildingClassOverrides
(CivilizationType, BuildingClassType, BuildingType)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'BUILDINGCLASS_MILITARY_ACADEMY', 'BUILDING_PRUSSIAN_KRIEGSSCHULE');
--------------------------------
-- Civilization_Religions
--------------------------------
INSERT INTO Civilization_Religions
(CivilizationType, ReligionType)
SELECT 'CIVILIZATION_JFD_PRUSSIA', ReligionType
FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_GERMANY';
--------------------------------
-- Civilization_SpyNames
--------------------------------
INSERT INTO Civilization_SpyNames
(CivilizationType, SpyName)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_0'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_1'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_2'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_3'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_4'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_5'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_6'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_7'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_8'),
('CIVILIZATION_JFD_PRUSSIA', 'TXT_KEY_SPY_NAME_JFD_PRUSSIA_9');
--==========================================================================================================================
--==========================================================================================================================
Combat Strength, 15% more when stacked with a 
Great General.
Ranged Combat Strength.
