SQL modding for dummies! (specially those that still use XML)

Chrisy15 · Oct 4, 2017

Troller0001 said:
What happens with units that originally had a range of 0? I.e. any melee (civilian) unit such as the Warrior, Spearman, Settler, etc.

Shhhhh

Equilin · Sep 17, 2018

Question: I made some modifications to JFD Roosevelt mod roughly using this guide but the civ disappeared from the selection screen (i replaced my code with JFD's original code and it works). Anyone can help with this? What did I do wrong?
allunique is the one i modded
original is the base version
bau is the source of what i added to allunique

Troller0001 · Sep 17, 2018

Equilin said:
Question: I made some modifications to JFD Roosevelt mod roughly using this guide but the civ disappeared from the selection screen (i replaced my code with JFD's original code and it works). Anyone can help with this? What did I do wrong?
allunique is the one i modded
original is the base version
bau is the source of what i added to allunique

This'll be your error (you're selecting from Improvements rather than from Resources). Problems like these can be found in Database.log

Code:

INSERT INTO Resources 
            (Type, CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas)
SELECT        ('RESOURCE_NUTMEG2'), CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas
FROM Improvements WHERE (Type = 'RESOURCE_NUTMEG');

INSERT INTO Resources 
            (Type, CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas)
SELECT        ('RESOURCE_CLOVES2'), CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas
FROM Improvements WHERE (Type = 'RESOURCE_CLOVES');

INSERT INTO Resources 
            (Type, CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas)
SELECT        ('RESOURCE_PEPPER2'), CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas
FROM Improvements WHERE (Type = 'RESOURCE_PEPPER');

On a completely different note, you're doing TONS of copying that isn't even necessary (or correct in some cases)?

Take the same snippet as above (but Improvements replaced by Resources). You're giving Indonesia (rather than Roosevelt) another set of spices. Even if you were to give the correct civilizationType (being CIVILIZATION_JFD_AMERICA_ROOSEVELT), your Trait would be set up incorrectly to use the set of spices.

Code:

INSERT INTO Units
            (Class,             Type,         PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex )
SELECT        ('UNITCLASS_ARCHER2_ATLATLIST'), ('UNIT_MAYAN_ATLATLIST2'), PrereqTech,  Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_MAYAN_ATLATLIST');

INSERT INTO Units
            (Class,             Type,         PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex )
SELECT        ('UNITCLASS_ARCHER3_SLINGER'), ('UNIT_INCAN_SLINGER2'), PrereqTech,  Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_INCAN_SLINGER');
<!--etc.-->

You're also inserting all these copies of unique units (and unitclasses), whereas just setting a unitclassOverride for the original unit would be enough.

Equilin · Sep 17, 2018

Thanks a lot!

Troller0001 said:
T
You're also inserting all these copies of unique units (and unitclasses), whereas just setting a unitclassOverride for the original unit would be enough.

Even if I want all of them to be buildable at the same time? I thought if i just did unitclassOverride they would override each other and only the bottommost one would make it to the game.

Troller0001 said:
Even if you were to give the correct civilizationType (being CIVILIZATION_JFD_AMERICA_ROOSEVELT), your Trait would be set up incorrectly to use the set of spices.

why? does TRAIT_SPICE have any links outside of the BNW trait file (since i don't found any reference elsewhere in the file)? having TRAIT_SPICE under Leader_traits should be enough right?

Troller0001 · Sep 17, 2018

Equilin said:
Thanks a lot!

Even if I want all of them to be buildable at the same time? I thought if i just did unitclassOverride they would override each other and only the bottommost one would make it to the game.

Yeah, multiple civs can have the same unique unit. (It's even done in the Scramble for Africa Scenario, where each European Nation gets an Explorer as a Unique Unit)

why? does TRAIT_SPICE have any links outside of the BNW trait file (since i don't found any reference elsewhere in the file)? having TRAIT_SPICE under Leader_traits should be enough right?

I seemed to have missed the part you're referencing:

Spoiler :

Code:

--------------------------------   
-- Leader_Traits
--------------------------------   
INSERT INTO Leader_Traits 
            (LeaderType,                 TraitType)
VALUES        ('LEADER_JFD_ROOSEVELT',     'TRAIT_JFD_AMERICA_ROOSEVELT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_RIVER_EXPANSION'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_GATEWAY_AFRICA'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SLAYER_OF_TIAMAT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SOLIDARITY'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SPICE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_EXTRA_TRADE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CARNIVAL'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_GREAT_EXPANSE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_BUFFALO_HORNS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CITY_STATE_FRIENDSHIP'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_AMPHIB_WARLORD'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CAPITAL_BUILDINGS_CHEAPER'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ENHANCED_GOLDEN_AGES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_STRATEGIC_RICHES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_OCEAN_MOVEMENT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_LAND_TRADE_GOLD'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_IGNORE_TERRAIN_IN_FOREST'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CULTURE_FROM_KILLS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ENHANCED_CULTURE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_FIGHT_WELL_DAMAGED'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_WONDER_BUILDER'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CITY_STATE_BONUSES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CONVERTS_SEA_BARBARIANS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ART_OF_WAR'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_INGENIOUS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_TERROR'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SEVEN_CITIES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_GREAT_ANDEAN_ROAD'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_WAYFINDING'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_VIKING_FURY'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SCHOLARS_JADE_HALL'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_LONG_COUNT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_BONUS_AGAINST_TECH'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_EXTRA_BELIEF'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_LUXURY_RETENTION'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_RAZE_AND_HORSES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_FAITH_FROM_NATURE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_PHOENICIAN_HERITAGE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_DIPLOMACY_GREAT_PEOPLE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ANNEX_CITY_STATE');

Which will not work since a Leader can only have 1 trait (even though the database does not enforce this). I'm unsure whether the game will pick the first trait in the Leader_Traits table or the last one (but what matters is that it only picks one)
You've got to manually merge all those traits into one super-trait.

----
Now, since your leader will only have one trait (TRAIT_JFD_AMERICA_ROOSEVELT) with the columns UniqueLuxuryCities and UniqueLuxuryQuantity both set to 0, you will not actually get your (copied) spices until to change those values. The same goes for many other traits that have columns set in the traits-table: they won't actually work until you set the same columns in TRAIT_JFD_AMERICA_ROOSEVELT too!

Equilin · Sep 18, 2018

Troller0001 said:
Yeah, multiple civs can have the same unique unit. (It's even done in the Scramble for Africa Scenario, where each European Nation gets an Explorer as a Unique Unit)

I mean one civ have multiple UUs in the same slot (e.g. having all sorts of knights UU and cavalry UU), which the BAU mod achieved by that pile of code.

Troller0001 said:
Which will not work since a Leader can only have 1 trait

Nope. It will show only one trait in the selection screen and the loading screen (the top one) but you can have much more working together. BAU did it and i also managed to do it successfully in official scenarios.

Equilin · Sep 18, 2018

Still not coming up in the setup screen (i fixed the Resources one already).
Would database file tell me anything? It mentions ArtDefine_StrategicView but i'm not sure if it's related (since i haven't start a game yet).

Troller0001 · Sep 23, 2018

Equilin said:
I mean one civ have multiple UUs in the same slot (e.g. having all sorts of knights UU and cavalry UU), which the BAU mod achieved by that pile of code.

Allright that's fair

Nope. It will show only one trait in the selection screen and the loading screen (the top one) but you can have much more working together. BAU did it and i also managed to do it successfully in official scenarios.

Well that is interesting. You learn something new every day!

Still not coming up in the setup screen (i fixed the Resources one already).

It seems that this is related to your use of NONE when adding UnitClasses (which is a UnitType that does not exist in Units)

Code:

('UNITCLASS_ARCHER2_ATLATLIST', 'TXT_KEY_UNIT_ARCHER', NONE),

I replaced them all by NULL. Even though the DB allowed me to do this, I'm unsure what effects this'll have in-game and I suspect that something will break by doing this.

You also had a duplicate entry for the Chateau in the Builds-table

Code:

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_CHATEAU2'), PrereqTech, Time, ('IMPROVEMENT_CHATEAU2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_CHATEAU');

and another double-duplicate in UnitClasses

Code:

            ('UNITCLASS_ARCHER2_ATLATLIST', 'TXT_KEY_UNIT_CAVALRY', NULL),
            ('UNITCLASS_ARCHER2_ATLATLIST', 'TXT_KEY_UNIT_CAVALRY', NULL),

and you were missing a comma at the end of the following line

Code:

('CIVILIZATION_AMERICA',                'BUILDINGCLASS_STABLE',     'BUILDING_JFD_RANCH')

Would database file tell me anything? It mentions ArtDefine_StrategicView but i'm not sure if it's related (since i haven't start a game yet).

Database.log would indeed tell you this. After you click 'next' on the mod setup screen, all Database-changes will be applied. At this point, Database.log will also be updated (which is before you start a game)

Spoiler :

Code:

--==========================================================================================================================   
-- BUILDINGS
--==========================================================================================================================   
-- Buildings
------------------------------   
INSERT INTO Buildings    
            (Type,                             BuildingClass, Cost, GoldMaintenance,     PrereqTech, Description,                             Civilopedia,                             Help,                                             Strategy,                                        XBuiltTriggersIdeologyChoice,    TrainedFreePromotion,            SpecialistType, SpecialistCount, ArtDefineTag,    MinAreaSize, ConquestProb, HurryCostModifier, PortraitIndex,     IconAtlas)
SELECT        ('BUILDING_JFD_ARMS_FACTORY'),    BuildingClass, Cost, GoldMaintenance,     PrereqTech, ('TXT_KEY_BUILDING_JFD_ARMS_FACTORY'), ('TXT_KEY_CIV5_BUILDINGS_FACTORY_TEXT'), ('TXT_KEY_BUILDING_JFD_ARMS_FACTORY_HELP'),     ('TXT_KEY_BUILDING_JFD_ARMS_FACTORY_STRATEGY'),    1,                                'PROMOTION_JFD_ARMS_FACTORY',    SpecialistType, SpecialistCount, ArtDefineTag,    MinAreaSize, ConquestProb, HurryCostModifier, 2,                 ('JFD_AMERICA_ROOSEVELT_ATLAS')
FROM Buildings WHERE (Type = 'BUILDING_FACTORY');   

INSERT INTO Buildings    
            (Type,                     Happiness,    BuildingClass, Cost,    GoldMaintenance,     PrereqTech,            Description,                     Civilopedia,                         Help,                                     Strategy,                                    ArtDefineTag,    MinAreaSize, ConquestProb, HurryCostModifier, PortraitIndex, IconAtlas)
SELECT        ('BUILDING_JFD_RANCH'),    1,            BuildingClass, Cost+35, 2,                     'TECH_TRAPPING',    ('TXT_KEY_BUILDING_JFD_RANCH'), ('TXT_KEY_CIV5_JFD_RANCH_TEXT'),     ('TXT_KEY_BUILDING_JFD_RANCH_HELP'),     ('TXT_KEY_BUILDING_JFD_RANCH_STRATEGY'),    ArtDefineTag,    MinAreaSize, ConquestProb, HurryCostModifier, 3,            ('JFD_AMERICA_ROOSEVELT_ATLAS')
FROM Buildings WHERE (Type = 'BUILDING_STABLE');

UPDATE Buildings
SET BuildingClass = 'BUILDINGCLASS_COLOSSEUM'
WHERE Type IN ('BUILDING_BURIAL_TOMB');
------------------------------   
-- Building_Flavors
------------------------------       
INSERT INTO Building_Flavors    
            (BuildingType,                     FlavorType, Flavor)
SELECT        ('BUILDING_JFD_ARMS_FACTORY'),    FlavorType, Flavor
FROM Building_Flavors WHERE (BuildingType = 'BUILDING_FACTORY');   

INSERT OR REPLACE INTO Building_Flavors    
            (BuildingType,             FlavorType, Flavor)
SELECT        ('BUILDING_JFD_RANCH'),    FlavorType, Flavor
FROM Building_Flavors WHERE (BuildingType = 'BUILDING_STABLE');
------------------------------   
-- Building_ClassesNeededInCity
------------------------------       
INSERT INTO Building_ClassesNeededInCity    
            (BuildingType,                     BuildingClassType)
SELECT        ('BUILDING_JFD_ARMS_FACTORY'),    BuildingClassType
FROM Building_ClassesNeededInCity WHERE (BuildingType = 'BUILDING_FACTORY');   
------------------------------   
-- Building_YieldChanges
------------------------------       
INSERT INTO Building_YieldChanges    
            (BuildingType,                     YieldType, Yield)
SELECT        ('BUILDING_JFD_ARMS_FACTORY'),    YieldType, Yield
FROM Building_YieldChanges WHERE (BuildingType = 'BUILDING_FACTORY');   
------------------------------   
-- Building_YieldModifiers
------------------------------       
INSERT INTO Building_YieldModifiers    
            (BuildingType,                     YieldType, Yield)
SELECT        ('BUILDING_JFD_ARMS_FACTORY'),    YieldType, Yield
FROM Building_YieldModifiers WHERE (BuildingType = 'BUILDING_FACTORY');   
------------------------------   
-- Building_ResourceQuantityRequirements
------------------------------       
INSERT INTO Building_ResourceQuantityRequirements    
            (BuildingType,                     ResourceType, Cost)
SELECT        ('BUILDING_JFD_ARMS_FACTORY'),    ResourceType, Cost
FROM Building_ResourceQuantityRequirements WHERE (BuildingType = 'BUILDING_FACTORY');   
------------------------------   
-- Building_UnitCombatProductionModifiers
------------------------------   
INSERT OR REPLACE INTO Building_UnitCombatProductionModifiers    
            (BuildingType,             UnitCombatType, Modifier)
SELECT        ('BUILDING_JFD_RANCH'),    UnitCombatType, 10
FROM Building_UnitCombatProductionModifiers WHERE (BuildingType = 'BUILDING_STABLE');

INSERT INTO Building_UnitCombatProductionModifiers    
            (BuildingType,                     UnitCombatType,            Modifier)
VALUES        ('BUILDING_JFD_ARMS_FACTORY',    'UNITCOMBAT_SIEGE',        10),
            ('BUILDING_JFD_ARMS_FACTORY',    'UNITCOMBAT_ARMOR',        10);
------------------------------   
-- Building_DomainProductionModifiers
------------------------------   
INSERT INTO Building_DomainProductionModifiers    
            (BuildingType,                     DomainType,        Modifier)
VALUES        ('BUILDING_JFD_ARMS_FACTORY',    'DOMAIN_AIR',    10);
------------------------------   
-- Building_ResourceYieldChanges
------------------------------       
INSERT OR REPLACE INTO Building_ResourceYieldChanges    
            (BuildingType,             ResourceType, YieldType,    Yield)
SELECT        ('BUILDING_JFD_RANCH'),    ResourceType, YieldType,    Yield
FROM Building_ResourceYieldChanges WHERE (BuildingType = 'BUILDING_STABLE');   

INSERT INTO Building_ResourceYieldChanges    
            (BuildingType,             ResourceType,        YieldType,            Yield)
VALUES        ('BUILDING_JFD_RANCH',    'RESOURCE_DEER',    'YIELD_PRODUCTION', 1),   
            ('BUILDING_JFD_RANCH',    'RESOURCE_BISON',    'YIELD_PRODUCTION', 1);
--==========================================================================================================================   
-- 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_ROOSEVELT',     'TXT_KEY_LEADER_JFD_ROOSEVELT',     'TXT_KEY_LEADER_JFD_ROOSEVELT_PEDIA',     'TXT_KEY_CIVILOPEDIA_LEADERS_JFD_ROOSEVELT',     'Roosevelt_Scene.xml',    8,                         6,                         2,                             6,             7,                 6,                 8,                         6,                 6,             6,             5,                 5,             2,             'JFD_AMERICA_ROOSEVELT_ATLAS',     1);
--------------------------------   
-- Leader_MajorCivApproachBiases
--------------------------------                       
INSERT INTO Leader_MajorCivApproachBiases 
            (LeaderType,                 MajorCivApproachType,                 Bias)
VALUES        ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_WAR',             7),
            ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_HOSTILE',         2),
            ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_DECEPTIVE',     8),
            ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_GUARDED',         6),
            ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_AFRAID',         3),
            ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_FRIENDLY',         6),
            ('LEADER_JFD_ROOSEVELT',     'MAJOR_CIV_APPROACH_NEUTRAL',         6);
--------------------------------   
-- Leader_MajorCivApproachBiases
--------------------------------                       
INSERT INTO Leader_MinorCivApproachBiases 
            (LeaderType,                 MinorCivApproachType,                 Bias)
VALUES        ('LEADER_JFD_ROOSEVELT',     'MINOR_CIV_APPROACH_IGNORE',         6),
            ('LEADER_JFD_ROOSEVELT',     'MINOR_CIV_APPROACH_FRIENDLY',         8),
            ('LEADER_JFD_ROOSEVELT',     'MINOR_CIV_APPROACH_PROTECTIVE',     8),
            ('LEADER_JFD_ROOSEVELT',     'MINOR_CIV_APPROACH_CONQUEST',         4);
--------------------------------   
-- Leader_Flavors
--------------------------------                       
INSERT INTO Leader_Flavors 
            (LeaderType,                 FlavorType,                         Flavor)
VALUES        ('LEADER_JFD_ROOSEVELT',     'FLAVOR_OFFENSE',                     7),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_DEFENSE',                     5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_CITY_DEFENSE',                 4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_MILITARY_TRAINING',         7),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_RECON',                     7),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_RANGED',                     6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_MOBILE',                     8),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_NAVAL',                     4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_NAVAL_RECON',                 4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_NAVAL_GROWTH',                 4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_NAVAL_TILE_IMPROVEMENT',     4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_AIR',                         3),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_EXPANSION',                 6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_GROWTH',                     6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_TILE_IMPROVEMENT',             5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_INFRASTRUCTURE',             8),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_PRODUCTION',                 8),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_GOLD',                         6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_SCIENCE',                     4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_CULTURE',                     5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_HAPPINESS',                 6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_GREAT_PEOPLE',                 6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_WONDER',                     4),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_RELIGION',                     2),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_DIPLOMACY',                 5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_SPACESHIP',                 3),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_WATER_CONNECTION',             3),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_NUKE',                         12),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_USE_NUKE',                     12),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_ESPIONAGE',                 6),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_AIRLIFT',                     3),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_I_TRADE_DESTINATION',         5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_I_TRADE_ORIGIN',             5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_I_SEA_TRADE_ROUTE',         5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_I_LAND_TRADE_ROUTE',         5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_ARCHAEOLOGY',                 5),
            ('LEADER_JFD_ROOSEVELT',     'FLAVOR_AIR_CARRIER',                 5);
--------------------------------   
-- Leader_Traits
--------------------------------   
INSERT INTO Leader_Traits 
            (LeaderType,                 TraitType)
VALUES        ('LEADER_JFD_ROOSEVELT',     'TRAIT_JFD_AMERICA_ROOSEVELT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_RIVER_EXPANSION'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_GATEWAY_AFRICA'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SLAYER_OF_TIAMAT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SOLIDARITY'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SPICE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_EXTRA_TRADE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CARNIVAL'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_GREAT_EXPANSE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_BUFFALO_HORNS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CITY_STATE_FRIENDSHIP'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_AMPHIB_WARLORD'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CAPITAL_BUILDINGS_CHEAPER'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ENHANCED_GOLDEN_AGES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_STRATEGIC_RICHES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_OCEAN_MOVEMENT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_LAND_TRADE_GOLD'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_IGNORE_TERRAIN_IN_FOREST'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CULTURE_FROM_KILLS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ENHANCED_CULTURE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_FIGHT_WELL_DAMAGED'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_WONDER_BUILDER'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CITY_STATE_BONUSES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_CONVERTS_SEA_BARBARIANS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ART_OF_WAR'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_INGENIOUS'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_TERROR'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SEVEN_CITIES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_GREAT_ANDEAN_ROAD'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_WAYFINDING'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_VIKING_FURY'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_SCHOLARS_JADE_HALL'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_LONG_COUNT'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_BONUS_AGAINST_TECH'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_EXTRA_BELIEF'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_LUXURY_RETENTION'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_RAZE_AND_HORSES'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_FAITH_FROM_NATURE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_PHOENICIAN_HERITAGE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_DIPLOMACY_GREAT_PEOPLE'),
        ('LEADER_JFD_ROOSEVELT',     'TRAIT_ANNEX_CITY_STATE');
--==========================================================================================================================   
-- TRAITS
--==========================================================================================================================   
-- Traits
--------------------------------   
INSERT INTO Traits 
            (Type,                                 Description,                             ShortDescription, FreeUnit, FreeUnitPrereqTech, NumTradeRoutesModifier, CombatBonusImprovement)
VALUES        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_TRAIT_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_TRAIT_JFD_AMERICA_ROOSEVELT_SHORT', 'UNITCLASS_MERCHANT', 'TECH_OPTICS', 100, 'IMPROVEMENT_MOAI2');

UPDATE Traits
SET Description = 'TXT_KEY_TRAIT_JFD_AMERICA',    PlotBuyCostModifier = 0
WHERE Type = 'TRAIT_RIVER_EXPANSION';


--------------------------------   
-- Trait_ImprovementYieldChanges
--------------------------------   
INSERT INTO Trait_ImprovementYieldChanges 
            (TraitType,                         ImprovementType,    YieldType,            Yield)
SELECT        ('TRAIT_JFD_AMERICA_ROOSEVELT'),     Type,                ('YIELD_CULTURE'),    2
FROM Improvements WHERE CreatedByGreatPerson = 1;

CREATE TRIGGER JFD_ImprovementsYieldChangesAmericaRoosevelt
AFTER INSERT ON Improvements WHEN 1 = NEW.CreatedByGreatPerson
BEGIN
    INSERT INTO Trait_ImprovementYieldChanges 
            (TraitType,                         ImprovementType,    YieldType,            Yield)
    SELECT    ('TRAIT_JFD_AMERICA_ROOSEVELT'),     NEW.Type,            ('YIELD_CULTURE'),    2
    FROM Improvements WHERE CreatedByGreatPerson = 1;
END;

--------------------------------   
-- Trait_ResourceQuantityModifiers
--------------------------------   
INSERT INTO Trait_ResourceQuantityModifiers 
            (TraitType,                         ResourceType,    ResourceQuantityModifier)
VALUES        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'RESOURCE_HORSE',    100),
        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'RESOURCE_IRON',    100),
        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'RESOURCE_URANIUM',    100),
        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'RESOURCE_OIL',    100),
        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'RESOURCE_ALUMINIUM',    100);

INSERT INTO Trait_YieldChangesStrategicResources 
            (TraitType,                         YieldType,    Yield)
VALUES        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'YIELD_PRODUCTION',    1);

INSERT INTO Trait_YieldChangesPerTradePartner 
            (TraitType,                         YieldType,    Yield)
VALUES        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'YIELD_GOLD',    3),
        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'YIELD_CULTURE',    1);

INSERT INTO Trait_YieldChangesIncomingTradeRoute
            (TraitType,                         YieldType,    Yield)
VALUES        ('TRAIT_JFD_AMERICA_ROOSEVELT',     'YIELD_GOLD',    2);

--==========================================================================================================================   
-- Resources
--==========================================================================================================================   
-- Resources
--------------------------------   
INSERT INTO Resources 
            (Type, CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas)
SELECT        ('RESOURCE_NUTMEG2'), 'CIVILIZATION_JFD_AMERICA_ROOSEVELT', Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas
FROM Resources WHERE (Type = 'RESOURCE_NUTMEG');

INSERT INTO Resources 
            (Type, CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas)
SELECT        ('RESOURCE_CLOVES2'), 'CIVILIZATION_JFD_AMERICA_ROOSEVELT', Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas
FROM Resources WHERE (Type = 'RESOURCE_CLOVES');

INSERT INTO Resources 
            (Type, CivilizationType, Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas)
SELECT        ('RESOURCE_PEPPER2'), 'CIVILIZATION_JFD_AMERICA_ROOSEVELT', Happiness, Description, Civilopedia, Help, ResourceClassType, ArtDefineTag, IconString, PortraitIndex, IconAtlas
FROM Resources WHERE (Type = 'RESOURCE_PEPPER');

--------------------------------   
-- Resource_Flavors
--------------------------------   
INSERT INTO Resource_Flavors 
            (ResourceType,     FlavorType,    Flavor)
VALUES        ('RESOURCE_NUTMEG2',     'FLAVOR_HAPPINESS',    10),
        ('RESOURCE_CLOVES2',     'FLAVOR_HAPPINESS',    10),
        ('RESOURCE_PEPPER2',     'FLAVOR_HAPPINESS',    10);

--------------------------------   
-- Resource_YieldChanges
--------------------------------   
INSERT INTO Resource_YieldChanges 
            (ResourceType,     YieldType,    Yield)
VALUES        ('RESOURCE_NUTMEG2',     'YIELD_GOLD',    2),
        ('RESOURCE_CLOVES2',     'YIELD_GOLD',    2),
        ('RESOURCE_PEPPER2',     'YIELD_GOLD',    2);

--==========================================================================================================================   
-- Improvements
--==========================================================================================================================   
-- Improvements
--------------------------------   
INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, CivilizationType, DefenseModifier, PillageGold, PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_KASBAH2'), Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), DefenseModifier, PillageGold, PortraitIndex, IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_KASBAH');

INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, CivilizationType, DefenseModifier, PillageGold, OnlyCityStateTerritory, Coastal, LuxuryCopiesSiphonedFromMinor, PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_FEITORIA2'), Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), DefenseModifier, PillageGold, OnlyCityStateTerritory, Coastal, LuxuryCopiesSiphonedFromMinor, PortraitIndex,  IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_FEITORIA');

INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, CivilizationType, DefenseModifier, PillageGold, NoTwoAdjacent, AdjacentLuxury, PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_CHATEAU2'), Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), DefenseModifier, PillageGold, NoTwoAdjacent, AdjacentLuxury, PortraitIndex, IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_CHATEAU');

INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, RequiresFeature, SpecificCivRequired, CivilizationType, PillageGold,  PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_POLDER2'), Description, Civilopedia, Help, ArtDefineTag, RequiresFeature, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), PillageGold,  PortraitIndex,  IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_POLDER');

INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, RequiresFeature, SpecificCivRequired, CivilizationType, PillageGold,  PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_BRAZILWOOD_CAMP2'), Description, Civilopedia, Help, ArtDefineTag, RequiresFeature, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), PillageGold,  PortraitIndex,  IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_BRAZILWOOD_CAMP');

INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, CivilizationType, CultureAdjacentSameType, PillageGold, BuildableOnResources, Coastal, PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_MOAI2'), Description, Civilopedia, Help, ArtDefineTag, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), CultureAdjacentSameType, PillageGold, BuildableOnResources, Coastal, PortraitIndex,  IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_MOAI');

INSERT INTO Improvements 
            (Type,     Description, Civilopedia, Help, ArtDefineTag, HillsMakesValid, SpecificCivRequired, CivilizationType, PillageGold,  PortraitIndex, IconAtlas)
SELECT        ('IMPROVEMENT_TERRACE_FARM2'), Description, Civilopedia, Help, ArtDefineTag, HillsMakesValid, SpecificCivRequired, ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), PillageGold,  PortraitIndex,  IconAtlas
FROM Improvements WHERE (Type = 'IMPROVEMENT_TERRACE_FARM');

--------------------------------   
-- Improvement_TechYieldChanges
--------------------------------   
INSERT INTO Improvement_TechYieldChanges 
            (ImprovementType,         TechType,    YieldType, Yield)
VALUES        ('IMPROVEMENT_POLDER2', 'TECH_ECONOMICS',    'YIELD_PRODUCTION',    1),
        ('IMPROVEMENT_POLDER2', 'TECH_ECONOMICS',    'YIELD_GOLD',    2),
        ('IMPROVEMENT_MOAI2',     'TECH_FLIGHT',    'YIELD_GOLD',    1),
        ('IMPROVEMENT_CHATEAU2', 'TECH_FLIGHT',    'YIELD_CULTURE',    1),
        ('IMPROVEMENT_CHATEAU2', 'TECH_FLIGHT',    'YIELD_GOLD',    2),
        ('IMPROVEMENT_BRAZILWOOD_CAMP2', 'TECH_ACOUSTICS',    'YIELD_CULTURE',    2);

--------------------------------   
-- Improvement_ValidFeatures
--------------------------------

INSERT INTO Improvement_ValidFeatures
            (ImprovementType,     FeatureType)
VALUES        ('IMPROVEMENT_POLDER2', 'FEATURE_MARSH'),
        ('IMPROVEMENT_POLDER2', 'FEATURE_FLOOD_PLAINS'),
        ('IMPROVEMENT_BRAZILWOOD_CAMP2', 'FEATURE_JUNGLE');

--------------------------------   
-- Improvement_Yields
--------------------------------


INSERT INTO Improvement_Yields
            (ImprovementType,             YieldType,    Yield)
VALUES        ('IMPROVEMENT_POLDER2',     'YIELD_FOOD',    3),
        ('IMPROVEMENT_MOAI2',     'YIELD_CULTURE',    1),
        ('IMPROVEMENT_KASBAH2',     'YIELD_FOOD',    1),
        ('IMPROVEMENT_KASBAH2',     'YIELD_PRODUCTION',    1),
        ('IMPROVEMENT_KASBAH2',     'YIELD_GOLD',    1),
        ('IMPROVEMENT_CHATEAU2',     'YIELD_CULTURE',    2),
        ('IMPROVEMENT_CHATEAU2',     'YIELD_GOLD',    1),
        ('IMPROVEMENT_BRAZILWOOD_CAMP2',     'YIELD_GOLD',    2),
        ('IMPROVEMENT_TERRACE_FARM2',     'YIELD_FOOD',    1);

--------------------------------   
-- Improvement_Terrainspecifics
--------------------------------

INSERT INTO Improvement_AdjacentMountainYieldChanges
            (ImprovementType,             YieldType,    Yield)
VALUES        ('IMPROVEMENT_TERRACE_FARM2',     'YIELD_FOOD',    1);

INSERT INTO Improvement_TechNoFreshWaterYieldChanges
            (ImprovementType,         TechType,    YieldType, Yield)
VALUES            ('IMPROVEMENT_TERRACE_FARM2', 'TECH_FERTILIZER',    'YIELD_FOOD',    1);

INSERT INTO Improvement_TechFreshWaterYieldChanges
            (ImprovementType,         TechType,    YieldType, Yield)
VALUES            ('IMPROVEMENT_TERRACE_FARM2', 'TECH_CIVIL_SERVICE',    'YIELD_FOOD',    1);


--------------------------------   
-- Improvement_ValidTerrains
--------------------------------

INSERT INTO Improvement_ValidTerrains
            (ImprovementType,     TerrainType)
VALUES        ('IMPROVEMENT_TERRACE_FARM2', 'TERRAIN_HILL'),
        ('IMPROVEMENT_MOAI2', 'TERRAIN_GRASS'),
        ('IMPROVEMENT_MOAI2', 'TERRAIN_PLAINS'),
        ('IMPROVEMENT_MOAI2', 'TERRAIN_DESERT'),
        ('IMPROVEMENT_MOAI2', 'TERRAIN_TUNDRA'),
        ('IMPROVEMENT_MOAI2', 'TERRAIN_SNOW'),
        ('IMPROVEMENT_KASBAH2', 'TERRAIN_DESERT'),
        ('IMPROVEMENT_FEITORIA2', 'TERRAIN_GRASS'),
        ('IMPROVEMENT_FEITORIA2', 'TERRAIN_PLAINS'),
        ('IMPROVEMENT_FEITORIA2', 'TERRAIN_DESERT'),
        ('IMPROVEMENT_FEITORIA2', 'TERRAIN_TUNDRA'),
        ('IMPROVEMENT_FEITORIA2', 'TERRAIN_SNOW'),
        ('IMPROVEMENT_CHATEAU2', 'TERRAIN_GRASS'),
        ('IMPROVEMENT_CHATEAU2', 'TERRAIN_PLAINS'),
        ('IMPROVEMENT_CHATEAU2', 'TERRAIN_DESERT'),
        ('IMPROVEMENT_CHATEAU2', 'TERRAIN_TUNDRA'),
        ('IMPROVEMENT_CHATEAU2', 'TERRAIN_SNOW');

--------------------------------
-- Builds
--------------------------------   
INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_KASBAH2'), PrereqTech, Time, ('IMPROVEMENT_KASBAH2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_KASBAH');

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_MOAI2'), PrereqTech, Time, ('IMPROVEMENT_MOAI2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_MOAI');

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_FEITORIA2'), PrereqTech, Time, ('IMPROVEMENT_FEITORIA2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_FEITORIA');

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_POLDER2'), PrereqTech, Time, ('IMPROVEMENT_POLDER2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_POLDER');

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_TERRACE_FARM2'), PrereqTech, Time, ('IMPROVEMENT_TERRACE_FARM2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_TERRACE_FARM');

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_CHATEAU2'), PrereqTech, Time, ('IMPROVEMENT_CHATEAU2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_CHATEAU');

INSERT INTO Builds
            (Type,     PrereqTech, Time, ImprovementType, Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas)
SELECT        ('BUILD_BRAZILWOOD_CAMP2'), PrereqTech, Time, ('IMPROVEMENT_BRAZILWOOD_CAMP2'), Description, Help, Recommendation, EntityEvent, HotKey, OrderPriority, IconIndex, IconAtlas
FROM Builds WHERE (Type = 'BUILD_BRAZILWOOD_CAMP');

--------------------------------
-- BuildFeatures
--------------------------------   
INSERT INTO BuildFeatures
            (BuildType, FeatureType,    PrereqTech, Time, Production,  Remove)
VALUES            ('BUILD_TERRACE_FARM2', 'FEATURE_JUNGLE','TECH_BRONZE_WORKING',    700, 0,    1),
            ('BUILD_MOAI2', 'FEATURE_JUNGLE','TECH_BRONZE_WORKING',    700, 0,    1),
            ('BUILD_FEITORIA2', 'FEATURE_JUNGLE','TECH_BRONZE_WORKING',    700, 0,    1),
            ('BUILD_CHATEAU2', 'FEATURE_JUNGLE','TECH_BRONZE_WORKING',    700, 0,    1),
            ('BUILD_FEITORIA2', 'FEATURE_MARSH','TECH_MASONRY',    600, 0,    1),
            ('BUILD_CHATEAU2', 'FEATURE_MARSH','TECH_MASONRY',    600, 0,    1),
            ('BUILD_TERRACE_FARM2', 'FEATURE_FOREST','TECH_MINING',    400, 20,    1),
            ('BUILD_MOAI2', 'FEATURE_FOREST','TECH_MINING',    400, 20,    1),
            ('BUILD_FEITORIA2', 'FEATURE_FOREST','TECH_MINING',    400, 20,    1),
            ('BUILD_CHATEAU2', 'FEATURE_FOREST','TECH_MINING',    400, 20,    1);

--------------------------------   
-- Unit_Builds
--------------------------------

INSERT INTO Unit_Builds
            (UnitType,     BuildType)
VALUES        ('UNIT_WORKER', 'BUILD_TERRACE_FARM2'),
        ('UNIT_WORKER', 'BUILD_MOAI2'),
        ('UNIT_WORKER', 'BUILD_POLDER2'),
        ('UNIT_WORKER', 'BUILD_KASBAH2'),
        ('UNIT_WORKER', 'BUILD_BRAZILWOOD_CAMP2'),
        ('UNIT_WORKER', 'BUILD_FEITORIA2'),
        ('UNIT_WORKER', 'BUILD_CHATEAU2');

--==========================================================================================================================   
-- PROMOTIONS
--==========================================================================================================================   
-- UnitPromotions
------------------------------
INSERT INTO UnitPromotions 
            (Type,                             EmbarkDefenseModifier,     Description,                             Help,                                         Sound,                 CannotBeChosen, PortraitIndex,     IconAtlas,             PediaType,             PediaEntry)
VALUES        ('PROMOTION_JFD_ARMS_FACTORY',     50,                        'TXT_KEY_PROMOTION_JFD_ARMS_FACTORY',     'TXT_KEY_PROMOTION_JFD_ARMS_FACTORY_HELP',    'AS2D_IF_LEVELUP',     1,                 59,             'ABILITY_ATLAS',     'PEDIA_ATTRIBUTES', 'TXT_KEY_PROMOTION_JFD_ARMS_FACTORY');
------------------------------   
-- UnitPromotions_UnitCombats
------------------------------   
INSERT INTO UnitPromotions_UnitCombats
            (PromotionType,                    UnitCombatType)
VALUES        ('PROMOTION_JFD_ARMS_FACTORY',    'UNITCOMBAT_ARMOR'),
            ('PROMOTION_JFD_ARMS_FACTORY',    'UNITCOMBAT_SIEGE');
--==========================================================================================================================
-- UNITS
--==========================================================================================================================
-- UnitClasses
--------------------------------   
INSERT INTO UnitClasses
            (Type, Description, DefaultUnit)
VALUES            ('UNITCLASS_ARCHER2_ATLATLIST', 'TXT_KEY_UNIT_ARCHER', NULL),
            ('UNITCLASS_ARCHER3_SLINGER', 'TXT_KEY_UNIT_ARCHER', NULL),
            ('UNITCLASS_CARAVEL2_TURTLE', 'TXT_KEY_UNIT_CARAVEL', NULL),
            ('UNITCLASS_CATAPULT2_SIEGE', 'TXT_KEY_UNIT_CATAPULT', NULL),
            ('UNITCLASS_CAVALRY2_BERBER', 'TXT_KEY_UNIT_CAVALRY',    NULL),
            ('UNITCLASS_CAVALRY3_COMANCHE', 'TXT_KEY_UNIT_CAVALRY',    NULL),
            ('UNITCLASS_CAVALRY4_HUSSAR', 'TXT_KEY_UNIT_CAVALRY',    NULL),
            ('UNITCLASS_CHARIOT_ARCHER2_HORSEARCHER', 'Chariot Archers',    NULL),
            ('UNITCLASS_CHARIOT_ARCHER3_WARCHARIOT', 'Chariot Archers',    NULL),
            ('UNITCLASS_CROSSBOWMAN2_LONGBOWMAN', 'TXT_KEY_UNIT_CROSSBOWMAN',    NULL),
            ('UNITCLASS_HORSEMAN2_CATAPHRACT', 'Horsemen',    NULL),
            ('UNITCLASS_HORSEMAN3_COMPANION', 'Horsemen',    NULL),
            ('UNITCLASS_KNIGHT2_CAMEL', 'TXT_KEY_UNIT_KNIGHT',    NULL),
            ('UNITCLASS_KNIGHT3_CONQUISTADOR', 'TXT_KEY_UNIT_KNIGHT',    NULL),
            ('UNITCLASS_KNIGHT4_KESHIK', 'TXT_KEY_UNIT_KNIGHT',    NULL),
            ('UNITCLASS_KNIGHT5_MANDEKALU', 'TXT_KEY_UNIT_KNIGHT',    NULL),
            ('UNITCLASS_LONGSWORDSMAN2_BERSERKER', 'Longswordsmen',    NULL),
            ('UNITCLASS_LANCER2_HAKKA', 'Lancers',    NULL),
            ('UNITCLASS_LANCER3_SIPAHI', 'Lancers',    NULL),
            ('UNITCLASS_MUSKETMAN2_MINUTEMAN', 'TXT_KEY_UNIT_MUSKETMAN',    NULL),
            ('UNITCLASS_MUSKETMAN3_MUSKETEER', 'TXT_KEY_UNIT_MUSKETMAN',    NULL),
            ('UNITCLASS_MUSKETMAN4_TERCIO', 'TXT_KEY_UNIT_MUSKETMAN',    NULL),
            ('UNITCLASS_RIFLEMAN2_MEHAL', 'TXT_KEY_UNIT_RIFLEMAN',    NULL),
            ('UNITCLASS_RIFLEMAN3_SKI', 'TXT_KEY_UNIT_RIFLEMAN',    NULL),
            ('UNITCLASS_SPEARMAN2_BATTERINGRAM', 'TXT_KEY_UNIT_SPEARMAN',    NULL),
            ('UNITCLASS_SPEARMAN3_HOPLITE', 'TXT_KEY_UNIT_SPEARMAN',    NULL),
            ('UNITCLASS_SPEARMAN4_PICTISH', 'TXT_KEY_UNIT_SPEARMAN',    NULL),
            ('UNITCLASS_SWORDSMAN2_KRIS', 'TXT_KEY_UNIT_SWORDSMAN',    NULL),
            ('UNITCLASS_SWORDSMAN3_MOHAWK', 'TXT_KEY_UNIT_SWORDSMAN',    NULL),
            ('UNITCLASS_TRIREME2_DROMON', 'TXT_KEY_UNIT_TRIREME',    NULL),
            ('UNITCLASS_WARRIOR2_JAGUAR', 'TXT_KEY_UNIT_WARRIOR',    NULL);

--------------------------------
-- Units
------------------------------   
UPDATE Units
SET Cost = Cost-30, FaithCost = FaithCost-60
WHERE Type = 'UNIT_AMERICAN_MINUTEMAN';

INSERT INTO Units
            (Class,             Type,         PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex )
SELECT        ('UNITCLASS_ARCHER2_ATLATLIST'), ('UNIT_MAYAN_ATLATLIST2'), PrereqTech,  Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_MAYAN_ATLATLIST');

INSERT INTO Units
            (Class,             Type,         PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex )
SELECT        ('UNITCLASS_ARCHER3_SLINGER'), ('UNIT_INCAN_SLINGER2'), PrereqTech,  Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_INCAN_SLINGER');

INSERT INTO Units
            (Class,                 Type,             PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex )
SELECT        ('UNITCLASS_CROSSBOWMAN2_LONGBOWMAN'), ('UNIT_ENGLISH_LONGBOWMAN2'),     PrereqTech,  Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_ENGLISH_LONGBOWMAN');

INSERT INTO Units
            (Class,                Type,            PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex )
SELECT        ('UNITCLASS_KNIGHT4_KESHIK'), ('UNIT_MONGOLIAN_KESHIK2'),     PrereqTech,  Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves ,Range ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_MONGOLIAN_KESHIK');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, HurryCostModifier, Cost,  Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, Mechanized, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, MinAreaSize ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate )
SELECT        ('UNITCLASS_CARAVEL2_TURTLE'), ('UNIT_KOREAN_TURTLE_SHIP2'),     PrereqTech,  Combat, HurryCostModifier, Cost, Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, Mechanized, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, MinAreaSize ,XPValueAttack ,XPValueDefense, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex , MoveRate
FROM Units WHERE (Type = 'UNIT_KOREAN_TURTLE_SHIP');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, RangedCombat, Cost,  Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, Mechanized, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, MinAreaSize, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_TRIREME2_DROMON'), ('UNIT_BYZANTINE_DROMON2'),     PrereqTech, Combat, RangedCombat, Cost,  Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, Mechanized, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, MinAreaSize, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_BYZANTINE_DROMON');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_KNIGHT2_CAMEL'), ('UNIT_ARABIAN_CAMELARCHER2'),     PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_ARABIAN_CAMELARCHER');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_CHARIOT_ARCHER2_HORSEARCHER'), ('UNIT_HUN_HORSE_ARCHER2'),     PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_HUN_HORSE_ARCHER');

INSERT INTO Units
            (Class,                 Type,                 PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_CHARIOT_ARCHER3_WARCHARIOT'), ('UNIT_EGYPTIAN_WARCHARIOT2'),     PrereqTech, Combat, RangedCombat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_EGYPTIAN_WARCHARIOT');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, Mechanized, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_CATAPULT2_SIEGE'), ('UNIT_ASSYRIAN_SIEGE_TOWER2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, Mechanized, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_ASSYRIAN_SIEGE_TOWER');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage,  ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_SPEARMAN2_BATTERINGRAM'), ('UNIT_HUN_BATTERING_RAM2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_HUN_BATTERING_RAM');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_CAVALRY2_BERBER'), ('UNIT_BERBER_CAVALRY2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_BERBER_CAVALRY');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_CAVALRY3_COMANCHE'), ('UNIT_SHOSHONE_COMANCHE_RIDERS2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_SHOSHONE_COMANCHE_RIDERS');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_CAVALRY4_HUSSAR'), ('UNIT_AUSTRIAN_HUSSAR2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_AUSTRIAN_HUSSAR');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, FoundAbroad, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_KNIGHT3_CONQUISTADOR'), ('UNIT_SPANISH_CONQUISTADOR2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, FoundAbroad, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech,  GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_SPANISH_CONQUISTADOR');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_KNIGHT5_MANDEKALU'), ('UNIT_SONGHAI_MUSLIMCAVALRY2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_SONGHAI_MUSLIMCAVALRY');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_HORSEMAN2_CATAPHRACT'), ('UNIT_BYZANTINE_CATAPHRACT2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_BYZANTINE_CATAPHRACT');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_HORSEMAN3_COMPANION'), ('UNIT_GREEK_COMPANIONCAVALRY2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_GREEK_COMPANIONCAVALRY');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_LANCER2_HAKKA'), ('UNIT_SWEDISH_HAKKAPELIITTA2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_SWEDISH_HAKKAPELIITTA');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate)
SELECT        ('UNITCLASS_LANCER3_SIPAHI'), ('UNIT_OTTOMAN_SIPAHI2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate
FROM Units WHERE (Type = 'UNIT_OTTOMAN_SIPAHI');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage,  ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense, Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_SPEARMAN3_HOPLITE'), ('UNIT_GREEK_HOPLITE2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_GREEK_HOPLITE');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage,  ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_SPEARMAN4_PICTISH'), ('UNIT_CELT_PICTISH_WARRIOR2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_CELT_PICTISH_WARRIOR');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_RIFLEMAN2_MEHAL'), ('UNIT_ETHIOPIAN_MEHAL_SEFARI2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_ETHIOPIAN_MEHAL_SEFARI');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_RIFLEMAN3_SKI'), ('UNIT_DANISH_SKI_INFANTRY2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_DANISH_SKI_INFANTRY');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_MUSKETMAN2_MINUTEMAN'), ('UNIT_AMERICAN_MINUTEMAN2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_AMERICAN_MINUTEMAN');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_MUSKETMAN3_MUSKETEER'), ('UNIT_FRENCH_MUSKETEER2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_FRENCH_MUSKETEER');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost,  XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_MUSKETMAN4_TERCIO'), ('UNIT_SPANISH_TERCIO2'), PrereqTech, Combat, Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves,CombatClass, Domain, DefaultUnitAI, Description, Civilopedia, Strategy, Help, MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, IgnoreBuildingDefense, GoodyHutUpgradeUnitClass, AdvancedStartCost, XPValueAttack, XPValueDefense,Conscription, UnitArtInfo, UnitFlagAtlas, UnitFlagIconOffset, IconAtlas, PortraitIndex
FROM Units WHERE (Type = 'UNIT_SPANISH_TERCIO');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, FaithCost, RequiresFaithPurchaseEnabled,HurryCostModifier, Cost,  Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex, MoveRate )
SELECT        ('UNITCLASS_LONGSWORDSMAN2_BERSERKER'), ('UNIT_DANISH_BERSERKER2'),     PrereqTech,  Combat, FaithCost, RequiresFaithPurchaseEnabled,HurryCostModifier, Cost, Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex , MoveRate
FROM Units WHERE (Type = 'UNIT_DANISH_BERSERKER');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, FaithCost, RequiresFaithPurchaseEnabled,HurryCostModifier, Cost,  Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_SWORDSMAN2_KRIS'), ('UNIT_KRIS_SWORDSMAN2'),     PrereqTech,  Combat, FaithCost, RequiresFaithPurchaseEnabled,HurryCostModifier, Cost, Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_KRIS_SWORDSMAN');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, FaithCost, RequiresFaithPurchaseEnabled,HurryCostModifier, Cost,  Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_SWORDSMAN3_MOHAWK'), ('UNIT_IROQUOIAN_MOHAWKWARRIOR2'),     PrereqTech,  Combat, FaithCost, RequiresFaithPurchaseEnabled,HurryCostModifier, Cost, Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_IROQUOIAN_MOHAWKWARRIOR');

INSERT INTO Units
            (Class,                 Type,         PrereqTech, Combat, FaithCost, RequiresFaithPurchaseEnabled, Cost,  Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex)
SELECT        ('UNITCLASS_WARRIOR2_JAGUAR'), ('UNIT_AZTEC_JAGUAR2'),     PrereqTech,  Combat, FaithCost, RequiresFaithPurchaseEnabled, Cost, Moves ,CombatClass, Domain ,DefaultUnitAI ,Description, Civilopedia, Strategy, Help ,MilitarySupport, MilitaryProduction, Pillage, ObsoleteTech, GoodyHutUpgradeUnitClass, AdvancedStartCost ,XPValueAttack ,XPValueDefense,Conscription, UnitArtInfo ,UnitFlagAtlas ,UnitFlagIconOffset, IconAtlas, PortraitIndex 
FROM Units WHERE (Type = 'UNIT_AZTEC_JAGUAR');

--------------------------------
-- Unit_AITypes
--------------------------------   
INSERT INTO Unit_AITypes
            (UnitType, UnitAIType)
VALUES            ('UNIT_KOREAN_TURTLE_SHIP2', 'UNITAI_ATTACK_SEA'),
            ('UNIT_KOREAN_TURTLE_SHIP2', 'UNITAI_RESERVE_SEA'),
            ('UNIT_KOREAN_TURTLE_SHIP2', 'UNITAI_ESCORT_SEA'),
            ('UNIT_BYZANTINE_DROMON2', 'UNITAI_ASSAULT_SEA'),
            ('UNIT_BYZANTINE_DROMON2', 'UNITAI_RESERVE_SEA'),
            ('UNIT_BYZANTINE_DROMON2', 'UNITAI_ESCORT_SEA'),
            ('UNIT_BYZANTINE_DROMON2', 'UNITAI_EXPLORE_SEA'),
            ('UNIT_INCAN_SLINGER2', 'UNITAI_RANGED'),
            ('UNIT_MAYAN_ATLATLIST2', 'UNITAI_RANGED'),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'UNITAI_RANGED'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'UNITAI_CITY_BOMBARD'),
            ('UNIT_HUN_BATTERING_RAM2', 'UNITAI_CITY_BOMBARD'),
            ('UNIT_BERBER_CAVALRY2', 'UNITAI_DEFENSE'),
            ('UNIT_BERBER_CAVALRY2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'UNITAI_DEFENSE'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'UNITAI_DEFENSE'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'UNITAI_RANGED'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'UNITAI_ATTACK'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'UNITAI_DEFENSE'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_MONGOLIAN_KESHIK2', 'UNITAI_RANGED'),
            ('UNIT_MONGOLIAN_KESHIK2', 'UNITAI_DEFENSE'),
            ('UNIT_MONGOLIAN_KESHIK2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'UNITAI_ATTACK'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'UNITAI_DEFENSE'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_HUN_HORSE_ARCHER2', 'UNITAI_RANGED'),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'UNITAI_RANGED'),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'UNITAI_DEFENSE'),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'UNITAI_DEFENSE'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_OTTOMAN_SIPAHI2', 'UNITAI_DEFENSE'),
            ('UNIT_OTTOMAN_SIPAHI2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'UNITAI_DEFENSE'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'UNITAI_FAST_ATTACK'),
            ('UNIT_GREEK_HOPLITE2', 'UNITAI_COUNTER'),
            ('UNIT_GREEK_HOPLITE2', 'UNITAI_ATTACK'),
            ('UNIT_GREEK_HOPLITE2', 'UNITAI_DEFENSE'),
            ('UNIT_GREEK_HOPLITE2', 'UNITAI_EXPLORE'),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'UNITAI_ATTACK'),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'UNITAI_DEFENSE'),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'UNITAI_EXPLORE'),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'UNITAI_ATTACK'),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'UNITAI_DEFENSE'),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'UNITAI_EXPLORE'),
            ('UNIT_DANISH_SKI_INFANTRY2', 'UNITAI_ATTACK'),
            ('UNIT_DANISH_SKI_INFANTRY2', 'UNITAI_DEFENSE'),
            ('UNIT_DANISH_SKI_INFANTRY2', 'UNITAI_EXPLORE'),
            ('UNIT_AMERICAN_MINUTEMAN2', 'UNITAI_ATTACK'),
            ('UNIT_AMERICAN_MINUTEMAN2', 'UNITAI_DEFENSE'),
            ('UNIT_AMERICAN_MINUTEMAN2', 'UNITAI_EXPLORE'),
            ('UNIT_FRENCH_MUSKETEER2', 'UNITAI_ATTACK'),
            ('UNIT_FRENCH_MUSKETEER2', 'UNITAI_DEFENSE'),
            ('UNIT_FRENCH_MUSKETEER2', 'UNITAI_EXPLORE'),
            ('UNIT_SPANISH_TERCIO2', 'UNITAI_COUNTER'),
            ('UNIT_SPANISH_TERCIO2', 'UNITAI_DEFENSE'),
            ('UNIT_SPANISH_TERCIO2', 'UNITAI_EXPLORE'),
            ('UNIT_DANISH_BERSERKER2', 'UNITAI_ATTACK'),
            ('UNIT_DANISH_BERSERKER2', 'UNITAI_DEFENSE'),
            ('UNIT_KRIS_SWORDSMAN2', 'UNITAI_ATTACK'),
            ('UNIT_KRIS_SWORDSMAN2', 'UNITAI_DEFENSE'),
            ('UNIT_IROQUOIAN_MOHAWKWARRIOR2', 'UNITAI_ATTACK'),
            ('UNIT_IROQUOIAN_MOHAWKWARRIOR2', 'UNITAI_DEFENSE'),
            ('UNIT_AZTEC_JAGUAR2', 'UNITAI_ATTACK'),
            ('UNIT_AZTEC_JAGUAR2', 'UNITAI_DEFENSE'),
            ('UNIT_AZTEC_JAGUAR2', 'UNITAI_EXPLORE');

--------------------------------
-- Unit_ClassUpgrades
--------------------------------   
INSERT INTO Unit_ClassUpgrades
            (UnitType, UnitClassType)
VALUES            ('UNIT_INCAN_SLINGER2', 'UNITCLASS_COMPOSITE_BOWMAN'),
            ('UNIT_MAYAN_ATLATLIST2', 'UNITCLASS_COMPOSITE_BOWMAN'),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'UNITCLASS_GATLINGGUN'),
            ('UNIT_KOREAN_TURTLE_SHIP2', 'UNITCLASS_DESTROYER'),
            ('UNIT_BYZANTINE_DROMON2', 'UNITCLASS_GALLEASS'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'UNITCLASS_TREBUCHET'),
            ('UNIT_HUN_BATTERING_RAM2', 'UNITCLASS_TREBUCHET'),
            ('UNIT_BERBER_CAVALRY2', 'UNITCLASS_WWI_TANK'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'UNITCLASS_WWI_TANK'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'UNITCLASS_WWI_TANK'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'UNITCLASS_CAVALRY2_BERBER'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'UNITCLASS_CAVALRY4_HUSSAR'),
            ('UNIT_MONGOLIAN_KESHIK2', 'UNITCLASS_CAVALRY3_COMANCHE'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'UNITCLASS_CAVALRY2_BERBER'),
            ('UNIT_HUN_HORSE_ARCHER2', 'UNITCLASS_KNIGHT4_KESHIK'),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'UNITCLASS_KNIGHT2_CAMEL'),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'UNITCLASS_KNIGHT3_CONQUISTADOR'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'UNITCLASS_KNIGHT5_MANDEKALU'),
            ('UNIT_OTTOMAN_SIPAHI2', 'UNITCLASS_ANTI_TANK_GUN'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'UNITCLASS_ANTI_TANK_GUN'),
            ('UNIT_GREEK_HOPLITE2', 'UNITCLASS_PIKEMAN'),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'UNITCLASS_PIKEMAN'),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'UNITCLASS_GREAT_WAR_INFANTRY'),
            ('UNIT_DANISH_SKI_INFANTRY2', 'UNITCLASS_GREAT_WAR_INFANTRY'),
            ('UNIT_AMERICAN_MINUTEMAN2', 'UNITCLASS_RIFLEMAN3_SKI'),
            ('UNIT_FRENCH_MUSKETEER2', 'UNITCLASS_RIFLEMAN'),
            ('UNIT_SPANISH_TERCIO2', 'UNITCLASS_RIFLEMAN2_MEHAL'),
            ('UNIT_DANISH_BERSERKER2', 'UNITCLASS_MUSKETMAN2_MINUTEMAN'),
            ('UNIT_KRIS_SWORDSMAN2', 'UNITCLASS_LONGSWORDSMAN2_BERSERKER'),
            ('UNIT_IROQUOIAN_MOHAWKWARRIOR2', 'UNITCLASS_LONGSWORDSMAN2_BERSERKER'),
            ('UNIT_AZTEC_JAGUAR2', 'UNITCLASS_SWORDSMAN3_MOHAWK');

--------------------------------
-- Unit_Flavors
--------------------------------   
INSERT INTO Unit_Flavors
            (UnitType, FlavorType, Flavor)
VALUES            ('UNIT_INCAN_SLINGER2', 'FLAVOR_OFFENSE', 2),
            ('UNIT_INCAN_SLINGER2', 'FLAVOR_DEFENSE', 1),
            ('UNIT_INCAN_SLINGER2', 'FLAVOR_RANGED', 8),
            ('UNIT_MAYAN_ATLATLIST2', 'FLAVOR_OFFENSE', 2),
            ('UNIT_MAYAN_ATLATLIST2', 'FLAVOR_DEFENSE', 1),
            ('UNIT_MAYAN_ATLATLIST2', 'FLAVOR_RANGED', 10),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'FLAVOR_OFFENSE',    4),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'FLAVOR_OFFENSE',    5),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'FLAVOR_OFFENSE',    10),
            ('UNIT_KOREAN_TURTLE_SHIP2', 'FLAVOR_NAVAL',    24),
            ('UNIT_BYZANTINE_DROMON2', 'FLAVOR_NAVAL',    16),
            ('UNIT_BYZANTINE_DROMON2', 'FLAVOR_NAVAL_RECON',    4),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'FLAVOR_OFFENSE',    20),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'FLAVOR_RANGED',    5),
            ('UNIT_HUN_BATTERING_RAM2', 'FLAVOR_OFFENSE',    20),
            ('UNIT_HUN_BATTERING_RAM2', 'FLAVOR_RANGED',    5),
            ('UNIT_BERBER_CAVALRY2', 'FLAVOR_OFFENSE', 20),
            ('UNIT_BERBER_CAVALRY2', 'FLAVOR_DEFENSE', 12),
            ('UNIT_BERBER_CAVALRY2', 'FLAVOR_MOBILE', 14),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'FLAVOR_OFFENSE', 20),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'FLAVOR_DEFENSE', 12),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'FLAVOR_MOBILE', 14),
            ('UNIT_AUSTRIAN_HUSSAR2', 'FLAVOR_OFFENSE', 20),
            ('UNIT_AUSTRIAN_HUSSAR2', 'FLAVOR_DEFENSE', 12),
            ('UNIT_AUSTRIAN_HUSSAR2', 'FLAVOR_MOBILE', 14),
            ('UNIT_MAYAN_ATLATLIST2', 'FLAVOR_DEFENSE', 1),
            ('UNIT_ARABIAN_CAMELARCHER2', 'FLAVOR_OFFENSE', 5),
            ('UNIT_ARABIAN_CAMELARCHER2', 'FLAVOR_RANGED', 10),
            ('UNIT_ARABIAN_CAMELARCHER2', 'FLAVOR_MOBILE', 10),
            ('UNIT_MONGOLIAN_KESHIK2', 'FLAVOR_OFFENSE', 5),
            ('UNIT_MONGOLIAN_KESHIK2', 'FLAVOR_RANGED', 10),
            ('UNIT_MONGOLIAN_KESHIK2', 'FLAVOR_MOBILE', 12),
            ('UNIT_SPANISH_CONQUISTADOR2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_SPANISH_CONQUISTADOR2', 'FLAVOR_DEFENSE', 4),
            ('UNIT_SPANISH_CONQUISTADOR2', 'FLAVOR_MOBILE', 10),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'FLAVOR_DEFENSE', 4),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'FLAVOR_MOBILE', 10),
            ('UNIT_HUN_HORSE_ARCHER2', 'FLAVOR_OFFENSE', 4),
            ('UNIT_HUN_HORSE_ARCHER2', 'FLAVOR_RANGED', 8),
            ('UNIT_HUN_HORSE_ARCHER2', 'FLAVOR_MOBILE', 2),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'FLAVOR_OFFENSE', 3),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'FLAVOR_DEFENSE', 1),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'FLAVOR_RANGED', 8),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'FLAVOR_MOBILE', 4),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'FLAVOR_DEFENSE', 4),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'FLAVOR_MOBILE', 8),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'FLAVOR_OFFENSE', 10),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'FLAVOR_DEFENSE', 3),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'FLAVOR_MOBILE', 6),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'FLAVOR_GREAT_PEOPLE',    5),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'FLAVOR_OFFENSE', 18),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'FLAVOR_DEFENSE', 2),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'FLAVOR_MOBILE', 14),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'FLAVOR_GREAT_PEOPLE',    4),
            ('UNIT_OTTOMAN_SIPAHI2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_OTTOMAN_SIPAHI2', 'FLAVOR_DEFENSE', 6),
            ('UNIT_OTTOMAN_SIPAHI2', 'FLAVOR_MOBILE', 12),
            ('UNIT_GREEK_HOPLITE2', 'FLAVOR_OFFENSE', 4),
            ('UNIT_GREEK_HOPLITE2', 'FLAVOR_DEFENSE', 8),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'FLAVOR_OFFENSE', 8),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'FLAVOR_DEFENSE', 4),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'FLAVOR_OFFENSE', 20),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'FLAVOR_DEFENSE', 20),
            ('UNIT_DANISH_SKI_INFANTRY2', 'FLAVOR_OFFENSE', 16),
            ('UNIT_DANISH_SKI_INFANTRY2', 'FLAVOR_DEFENSE', 16),
            ('UNIT_AMERICAN_MINUTEMAN2', 'FLAVOR_OFFENSE', 10),
            ('UNIT_AMERICAN_MINUTEMAN2', 'FLAVOR_DEFENSE', 10),
            ('UNIT_AMERICAN_MINUTEMAN2', 'FLAVOR_RECON',    8),
            ('UNIT_FRENCH_MUSKETEER2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_FRENCH_MUSKETEER2', 'FLAVOR_DEFENSE', 12),
            ('UNIT_SPANISH_TERCIO2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_SPANISH_TERCIO2', 'FLAVOR_DEFENSE', 16),
            ('UNIT_DANISH_BERSERKER2', 'FLAVOR_OFFENSE', 16),
            ('UNIT_DANISH_BERSERKER2', 'FLAVOR_DEFENSE', 4),
            ('UNIT_KRIS_SWORDSMAN2', 'FLAVOR_OFFENSE', 12),
            ('UNIT_KRIS_SWORDSMAN2', 'FLAVOR_DEFENSE', 12),
            ('UNIT_IROQUOIAN_MOHAWKWARRIOR2', 'FLAVOR_OFFENSE', 10),
            ('UNIT_IROQUOIAN_MOHAWKWARRIOR2', 'FLAVOR_DEFENSE', 10),
            ('UNIT_AZTEC_JAGUAR2', 'FLAVOR_RECON',    2),
            ('UNIT_AZTEC_JAGUAR2', 'FLAVOR_OFFENSE', 4),
            ('UNIT_AZTEC_JAGUAR2', 'FLAVOR_DEFENSE', 4);

------------------------------
-- Unit_FreePromotions
------------------------------
DELETE FROM Unit_FreePromotions WHERE UnitType = 'UNIT_AMERICAN_MINUTEMAN' AND PromotionType = 'PROMOTION_GOLDEN_AGE_POINTS';

INSERT INTO Unit_FreePromotions
            (UnitType, PromotionType)
VALUES            ('UNIT_KOREAN_TURTLE_SHIP2', 'PROMOTION_OCEAN_IMPASSABLE'),
            ('UNIT_BYZANTINE_DROMON2', 'PROMOTION_OCEAN_IMPASSABLE'),
            ('UNIT_BYZANTINE_DROMON2', 'PROMOTION_NAVAL_BONUS'),
            ('UNIT_BYZANTINE_DROMON2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_INCAN_SLINGER2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_INCAN_SLINGER2', 'PROMOTION_WITHDRAW_BEFORE_MELEE'),
            ('UNIT_MAYAN_ATLATLIST2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_ENGLISH_LONGBOWMAN2', 'PROMOTION_RANGE'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'PROMOTION_SAPPER'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'PROMOTION_CITY_SIEGE'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'PROMOTION_COVER_1'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'PROMOTION_ONLY_ATTACKS_CITIES'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'PROMOTION_EXTRA_SIGHT_I'),
            ('UNIT_ASSYRIAN_SIEGE_TOWER2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_HUN_BATTERING_RAM2', 'PROMOTION_CITY_ASSAULT'),
            ('UNIT_HUN_BATTERING_RAM2', 'PROMOTION_DEFENSE_PENALTY'),
            ('UNIT_HUN_BATTERING_RAM2', 'PROMOTION_COVER_1'),
            ('UNIT_HUN_BATTERING_RAM2', 'PROMOTION_ONLY_ATTACKS_CITIES'),
            ('UNIT_HUN_BATTERING_RAM2', 'PROMOTION_SIGHT_PENALTY'),
            ('UNIT_HUN_BATTERING_RAM2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'PROMOTION_FLANK_ATTACK_BONUS'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'PROMOTION_CITY_PENALTY'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'PROMOTION_EXTRA_SIGHT_I'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_BERBER_CAVALRY2', 'PROMOTION_CITY_PENALTY'),
            ('UNIT_BERBER_CAVALRY2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_BERBER_CAVALRY2', 'PROMOTION_DESERT_WARRIOR'),
            ('UNIT_BERBER_CAVALRY2', 'PROMOTION_HOMELAND_GUARDIAN'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'PROMOTION_CITY_PENALTY'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'PROMOTION_MOON_STRIKER'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'PROMOTION_DEFENSIVE_EMBARKATION'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'PROMOTION_EXTRA_SIGHT_II'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_MONGOLIAN_KESHIK2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_MONGOLIAN_KESHIK2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_MONGOLIAN_KESHIK2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_MONGOLIAN_KESHIK2', 'PROMOTION_SPAWN_GENERALS_I'),
            ('UNIT_MONGOLIAN_KESHIK2', 'PROMOTION_GAIN_EXPERIENCE'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_HUN_HORSE_ARCHER2', 'PROMOTION_ACCURACY_1'),
            ('UNIT_HUN_HORSE_ARCHER2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_HUN_HORSE_ARCHER2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'PROMOTION_ROUGH_TERRAIN_ENDS_TURN'),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'PROMOTION_ONLY_DEFENSIVE'),
            ('UNIT_EGYPTIAN_WARCHARIOT2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'PROMOTION_SMALL_CITY_PENALTY'),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'PROMOTION_CITY_PENALTY'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'PROMOTION_CITY_PENALTY'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'PROMOTION_FORMATION_1'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'PROMOTION_MOVEMENT_TO_GENERAL'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'PROMOTION_GENERAL_STACKING'),
            ('UNIT_OTTOMAN_SIPAHI2', 'PROMOTION_CITY_PENALTY'),
            ('UNIT_OTTOMAN_SIPAHI2', 'PROMOTION_NO_DEFENSIVE_BONUSES'),
            ('UNIT_OTTOMAN_SIPAHI2', 'PROMOTION_CAN_MOVE_AFTER_ATTACKING'),
            ('UNIT_OTTOMAN_SIPAHI2', 'PROMOTION_FORMATION_1'),
            ('UNIT_OTTOMAN_SIPAHI2', 'PROMOTION_FREE_PILLAGE_MOVES'),
            ('UNIT_OTTOMAN_SIPAHI2', 'PROMOTION_EXTRA_SIGHT_I'),
            ('UNIT_GREEK_HOPLITE2', 'PROMOTION_ANTI_MOUNTED_I'),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'PROMOTION_FOREIGN_LANDS'),
            ('UNIT_CELT_PICTISH_WARRIOR2', 'PROMOTION_FREE_PILLAGE_MOVES'),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'PROMOTION_DRILL_1'),
            ('UNIT_ETHIOPIAN_MEHAL_SEFARI2', 'PROMOTION_DEFEND_NEAR_CAPITAL'),
            ('UNIT_DANISH_SKI_INFANTRY2', 'PROMOTION_SKI_INFANTRY'),
            ('UNIT_AMERICAN_MINUTEMAN2', 'PROMOTION_DRILL_1'),
            ('UNIT_AMERICAN_MINUTEMAN2', 'PROMOTION_IGNORE_TERRAIN_COST'),
            ('UNIT_SPANISH_TERCIO2', 'PROMOTION_ANTI_MOUNTED_I'),
            ('UNIT_DANISH_BERSERKER2', 'PROMOTION_AMPHIBIOUS'),
            ('UNIT_KRIS_SWORDSMAN2', 'PROMOTION_MYSTIC_BLADE'),
            ('UNIT_IROQUOIAN_MOHAWKWARRIOR2', 'PROMOTION_MOHAWK'),
            ('UNIT_AZTEC_JAGUAR2', 'PROMOTION_JAGUAR'),
            ('UNIT_AZTEC_JAGUAR2', 'PROMOTION_WOODSMAN'),
            ('UNIT_AZTEC_JAGUAR2', 'PROMOTION_PARTIAL_HEAL_IF_DESTROY_ENEMY');

--------------------------------
-- Unit_ResourceQuantityRequirements
--------------------------------   
INSERT INTO Unit_ResourceQuantityRequirements
            (UnitType, ResourceType)
VALUES            ('UNIT_BERBER_CAVALRY2', 'RESOURCE_HORSE'),
            ('UNIT_SHOSHONE_COMANCHE_RIDERS2', 'RESOURCE_HORSE'),
            ('UNIT_AUSTRIAN_HUSSAR2', 'RESOURCE_HORSE'),
            ('UNIT_ARABIAN_CAMELARCHER2', 'RESOURCE_HORSE'),
            ('UNIT_SPANISH_CONQUISTADOR2', 'RESOURCE_HORSE'),
            ('UNIT_MONGOLIAN_KESHIK2', 'RESOURCE_HORSE'),
            ('UNIT_SONGHAI_MUSLIMCAVALRY2', 'RESOURCE_HORSE'),
            ('UNIT_BYZANTINE_CATAPHRACT2', 'RESOURCE_HORSE'),
            ('UNIT_GREEK_COMPANIONCAVALRY2', 'RESOURCE_HORSE'),
            ('UNIT_OTTOMAN_SIPAHI2', 'RESOURCE_HORSE'),
            ('UNIT_SWEDISH_HAKKAPELIITTA2', 'RESOURCE_HORSE'),
            ('UNIT_DANISH_BERSERKER2', 'RESOURCE_IRON'),
            ('UNIT_KRIS_SWORDSMAN2', 'RESOURCE_IRON');

--------------------------------
-- Unit_YieldFromKills
--------------------------------   
INSERT INTO Unit_YieldFromKills
            (UnitType, YieldType,Yield)
VALUES            ('UNIT_CELT_PICTISH_WARRIOR2', 'YIELD_FAITH', 50);

--==========================================================================================================================   
-- CIVILIZATIONS
--==========================================================================================================================   
-- Civilizations
--------------------------------       
INSERT INTO Civilizations    
            (Type,                                         Description,                                ShortDescription,                                     Adjective,     Civilopedia,     CivilopediaTag,    DefaultPlayerColor,                     ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, IconAtlas,                             PortraitIndex,     AlphaIconAtlas,                         SoundtrackTag,     MapImage,                             DawnOfManQuote,                             DawnOfManImage)
SELECT        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'),     ('TXT_KEY_CIV_JFD_AMERICA_ROOSEVELT_DESC'),    ('TXT_KEY_CIV_JFD_AMERICA_ROOSEVELT_SHORT_DESC'),    Adjective,    Civilopedia,     CivilopediaTag, ('PLAYERCOLOR_JFD_AMERICA_ROOSEVELT'),     ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, ('JFD_AMERICA_ROOSEVELT_ATLAS'),     0,                 ('JFD_AMERICA_ROOSEVELT_ALPHA_ATLAS'),     ('America'),     ('AmericaRooseveltMap512.dds'),        ('TXT_KEY_CIV5_DOM_JFD_ROOSEVELT_TEXT'),     ('DOM_Roosevelt.dds')
FROM Civilizations WHERE (Type = 'CIVILIZATION_AMERICA');
--------------------------------   
-- Civilization_CityNames
--------------------------------   
DELETE FROM Civilization_CityNames WHERE CivilizationType = 'CIVILIZATION_AMERICA';
INSERT INTO Civilization_CityNames 
            (CivilizationType,                         CityName)
VALUES        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_01'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_02'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_03'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_04'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_05'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_06'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_07'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_08'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_09'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_10'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_11'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_12'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_13'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_14'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_15'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_16'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_17'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_18'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_19'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_20'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_21'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_22'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_23'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_24'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_25'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_26'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_27'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_28'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_29'),
            ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'TXT_KEY_CITY_NAME_JFD_AMERICA_ROOSEVELT_30'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_01'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_02'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_03'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_04'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_05'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_06'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_07'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_08'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_09'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_10'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_11'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_12'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_13'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_14'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_15'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_16'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_17'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_18'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_19'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_20'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_21'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_22'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_23'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_24'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_25'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_26'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_27'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_28'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_29'),
            ('CIVILIZATION_AMERICA',                 'TXT_KEY_CITY_NAME_JFD_AMERICA_30');   
--------------------------------   
-- Civilization_FreeBuildingClasses
--------------------------------           
INSERT INTO Civilization_FreeBuildingClasses 
            (CivilizationType,                         BuildingClassType)
SELECT        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), BuildingClassType
FROM Civilization_FreeBuildingClasses WHERE (CivilizationType = 'CIVILIZATION_AMERICA');
--------------------------------   
-- Civilization_FreeTechs
--------------------------------       
INSERT INTO Civilization_FreeTechs 
            (CivilizationType,                         TechType)
VALUES        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT', 'TECH_AGRICULTURE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT', 'TECH_ANIMAL_HUSBANDRY');
-- FROM Civilization_FreeTechs WHERE (CivilizationType = 'CIVILIZATION_AMERICA');
--------------------------------   
-- Civilization_FreeUnits
--------------------------------       
INSERT INTO Civilization_FreeUnits 
            (CivilizationType,                         UnitClassType, Count, UnitAIType)
SELECT        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), UnitClassType, Count, UnitAIType
FROM Civilization_FreeUnits WHERE (CivilizationType = 'CIVILIZATION_AMERICA');
--------------------------------   
-- Civilization_Leaders
--------------------------------       
INSERT INTO Civilization_Leaders 
            (CivilizationType,                         LeaderheadType)
VALUES        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'LEADER_JFD_ROOSEVELT');
--------------------------------   
-- Civilization_UnitClassOverrides 
--------------------------------   
DELETE FROM Civilization_UnitClassOverrides WHERE UnitType = 'UNIT_AMERICAN_B17';   
INSERT INTO Civilization_UnitClassOverrides 
            (CivilizationType,                         UnitClassType,                 UnitType)
VALUES        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_BOMBER',                     'UNIT_AMERICAN_B17'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_ARCHER',                     'UNIT_BABYLONIAN_BOWMAN'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_ARCHER2_ATLATLIST',                 'UNIT_MAYAN_ATLATLIST2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_ARCHER3_SLINGER',                 'UNIT_INCAN_SLINGER2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CARAVEL',                     'UNIT_PORTUGUESE_NAU'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CARAVEL2_TURTLE',                 'UNIT_KOREAN_TURTLE_SHIP2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CATAPULT',                     'UNIT_ROMAN_BALLISTA'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CATAPULT2_SIEGE',                 'UNIT_ASSYRIAN_SIEGE_TOWER2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CAVALRY',                     'UNIT_RUSSIAN_COSSACK'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CAVALRY2_BERBER',                 'UNIT_BERBER_CAVALRY2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CAVALRY3_COMANCHE',                 'UNIT_SHOSHONE_COMANCHE_RIDERS2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CAVALRY4_HUSSAR',                 'UNIT_AUSTRIAN_HUSSAR2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CHARIOT_ARCHER',                 'UNIT_INDIAN_WARELEPHANT'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CHARIOT_ARCHER2_HORSEARCHER',         'UNIT_HUN_HORSE_ARCHER2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CHARIOT_ARCHER3_WARCHARIOT',         'UNIT_EGYPTIAN_WARCHARIOT2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CROSSBOWMAN',                 'UNIT_CHINESE_CHUKONU'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_CROSSBOWMAN2_LONGBOWMAN',             'UNIT_ENGLISH_LONGBOWMAN2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_FIGHTER',                     'UNIT_JAPANESE_ZERO'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_FRIGATE',                     'UNIT_ENGLISH_SHIPOFTHELINE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_GALLEASS',                     'UNIT_VENETIAN_GALLEASS'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_GREAT_GENERAL',                 'UNIT_MONGOLIAN_KHAN'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_HORSEMAN',                     'UNIT_CARTHAGINIAN_FOREST_ELEPHANT'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_HORSEMAN2_CATAPHRACT',             'UNIT_BYZANTINE_CATAPHRACT2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_HORSEMAN3_COMPANION',             'UNIT_GREEK_COMPANIONCAVALRY2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_INFANTRY',                     'UNIT_BRAZILIAN_PRACINHA'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_KNIGHT',                     'UNIT_SIAMESE_WARELEPHANT'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_KNIGHT2_CAMEL',                 'UNIT_ARABIAN_CAMELARCHER2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_KNIGHT3_CONQUISTADOR',             'UNIT_SPANISH_CONQUISTADOR2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_KNIGHT4_KESHIK',                 'UNIT_MONGOLIAN_KESHIK2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_KNIGHT5_MANDEKALU',                 'UNIT_SONGHAI_MUSLIMCAVALRY2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_LANCER',                     'UNIT_POLISH_WINGED_HUSSAR'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_LANCER2_HAKKA',                 'UNIT_SWEDISH_HAKKAPELIITTA2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_LANCER3_SIPAHI',                 'UNIT_OTTOMAN_SIPAHI2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_LONGSWORDSMAN',                 'UNIT_JAPANESE_SAMURAI'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_LONGSWORDSMAN2_BERSERKER',             'UNIT_DANISH_BERSERKER2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_MERCHANT',                     'UNIT_VENETIAN_MERCHANT'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_MUSKETMAN',                     'UNIT_OTTOMAN_JANISSARY'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_MUSKETMAN2_MINUTEMAN',             'UNIT_AMERICAN_MINUTEMAN2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_MUSKETMAN3_MUSKETEER',             'UNIT_FRENCH_MUSKETEER2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_MUSKETMAN4_TERCIO',                 'UNIT_SPANISH_TERCIO2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_PIKEMAN',                     'UNIT_ZULU_IMPI'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_PRIVATEER',                     'UNIT_DUTCH_SEA_BEGGAR'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_RIFLEMAN',                     'UNIT_SWEDISH_CAROLEAN'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_RIFLEMAN2_MEHAL',                 'UNIT_ETHIOPIAN_MEHAL_SEFARI2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_RIFLEMAN3_SKI',                 'UNIT_DANISH_SKI_INFANTRY2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SCOUT',                     'UNIT_SHOSHONE_PATHFINDER'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SPEARMAN',                     'UNIT_PERSIAN_IMMORTAL'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SPEARMAN2_BATTERINGRAM',             'UNIT_HUN_BATTERING_RAM2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SPEARMAN3_HOPLITE',                 'UNIT_GREEK_HOPLITE2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SPEARMAN4_PICTISH',                 'UNIT_CELT_PICTISH_WARRIOR2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SWORDSMAN',                     'UNIT_ROMAN_LEGION'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SWORDSMAN2_KRIS',                 'UNIT_KRIS_SWORDSMAN2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_SWORDSMAN3_MOHAWK',                 'UNIT_IROQUOIAN_MOHAWKWARRIOR2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_TANK',                     'UNIT_GERMAN_PANZER'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_TREBUCHET',                     'UNIT_KOREAN_HWACHA'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_TRIREME',                     'UNIT_CARTHAGINIAN_QUINQUEREME'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_TRIREME2_DROMON',                 'UNIT_BYZANTINE_DROMON2'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_WARRIOR',                     'UNIT_POLYNESIAN_MAORI_WARRIOR'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'UNITCLASS_WARRIOR2_JAGUAR',                 'UNIT_AZTEC_JAGUAR2');
--------------------------------   
-- Civilization_BuildingClassOverrides 
--------------------------------   
INSERT INTO Civilization_BuildingClassOverrides 
            (CivilizationType,         BuildingClassType,             BuildingType)
VALUES        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_FACTORY',     'BUILDING_JFD_ARMS_FACTORY'),
            ('CIVILIZATION_AMERICA',                'BUILDINGCLASS_STABLE',     'BUILDING_JFD_RANCH'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_BANK',         'BUILDING_HANSE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_BARRACKS',     'BUILDING_IKANDA'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_CASTLE',     'BUILDING_MUGHAL_FORT'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_GARDEN',     'BUILDING_CANDI'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_LIBRARY',     'BUILDING_PAPER_MAKER'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_MARKET',     'BUILDING_BAZAAR'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_MONUMENT',     'BUILDING_STELE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_OPERA_HOUSE',     'BUILDING_CEILIDH_HALL'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_SHRINE',     'BUILDING_MAYA_PYRAMID'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_STABLE',     'BUILDING_DUCAL_STABLE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_TEMPLE',     'BUILDING_MUD_PYRAMID_MOSQUE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_UNIVERSITY',     'BUILDING_WAT'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_WALLS',        'BUILDING_WALLS_OF_BABYLON'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_WATERMILL',     'BUILDING_FLOATING_GARDENS'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_WINDMILL',     'BUILDING_COFFEE_HOUSE'),
        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT',     'BUILDINGCLASS_COLOSSEUM',     'BUILDING_BURIAL_TOMB');
--------------------------------   
-- Civilization_Religions
--------------------------------       
INSERT INTO Civilization_Religions 
            (CivilizationType,                         ReligionType)
SELECT        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), ReligionType
FROM Civilization_Religions WHERE (CivilizationType = 'CIVILIZATION_AMERICA');
--------------------------------   
-- Civilization_SpyNames
--------------------------------   
INSERT INTO Civilization_SpyNames 
            (CivilizationType,                         SpyName)
SELECT        ('CIVILIZATION_JFD_AMERICA_ROOSEVELT'), SpyName
FROM Civilization_SpyNames WHERE (CivilizationType = 'CIVILIZATION_AMERICA');
--------------------------------   
-- Civilization_Start_Region_Avoid
--------------------------------   
INSERT INTO Civilization_Start_Region_Avoid 
            (CivilizationType,             RegionType)
VALUES        ('CIVILIZATION_AMERICA',     'REGION_HILLS');
--==========================================================================================================================
--==========================================================================================================================

LeeS · Sep 25, 2018

Troller0001 said:
Which will not work since a Leader can only have 1 trait (even though the database does not enforce this). I'm unsure whether the game will pick the first trait in the Leader_Traits table or the last one (but what matters is that it only picks one)
You've got to manually merge all those traits into one super-trait.

This is not true. The game will implement them all for the same leader. However, there are some limits to the amount of "stuff" this sort of pile-on the game can handle. As I recall there were some issues related to the FreeBuilding (Harbors) when piling all these traits onto the same leader, and there was also as I recall some issues with Germany's trait. The limits seem to be related to a memory allocation issue for tracking all of a leader's trait-stuff when multiple traits are added to the same leader, and only really seems to manifest for a few specific leader-effects when all or nearly all the traits are given to the same leader.

Merging all the traits into one does not get around the issues having to do with the FreeBuilding and the Germany Barb Camp thing as I recall.

I add the extra belief trait to all leaders when I play civ5 and give Theodora (?) another trait. The game implements all this just fine.

LeeS · Sep 25, 2018

You cannot use "NONE" as the default unit of a Unit-Class. The game does not implement the new unit-class properly everywhere it needs to. The same is true for a Building-Class. As I recall in the correct circumstances having a NULL or NONE value as the default building within a building-class will cause CTD. Don't remember whether the game can CTD from a Unit-Class with NONE as the default unit under correct circumstances.

The correct solution would be to make the extra unique unit the default within its stand-alone unit-class, and then dis-allow any but the correct player to purchase or train the unit via an lua script.

LeeS · Sep 25, 2018

Re-directing the Burial Tomb from the Temple-Class of buildings to the Colosseum-Class of Buildings means that Egypt is now messed up because its BuildingClassOverride is now pointing to an incorrect Building-Class. This does not generally lead to a CTD but does cause some odd in-game results.

Equilin · Sep 26, 2018

LeeS said:
You cannot use "NONE" as the default unit of a Unit-Class. The game does not implement the new unit-class properly everywhere it needs to. The same is true for a Building-Class. As I recall in the correct circumstances having a NULL or NONE value as the default building within a building-class will cause CTD. Don't remember whether the game can CTD from a Unit-Class with NONE as the default unit under correct circumstances.

The correct solution would be to make the extra unique unit the default within its stand-alone unit-class, and then dis-allow any but the correct player to purchase or train the unit via an lua script.

I don't know what the equivalent of "NONE" in XML (which worked) would be in SQL. Any idea on that?

LeeS said:
Re-directing the Burial Tomb from the Temple-Class of buildings to the Colosseum-Class of Buildings means that Egypt is now messed up because its BuildingClassOverride is now pointing to an incorrect Building-Class. This does not generally lead to a CTD but does cause some odd in-game results.

I added this

Code:

DELETE FROM Civilization_BuildingClassOverrides WHERE CivilizationType = 'CIVILIZATION_EGYPT';

then readjust Egypt's Tomb to Colosseum too.

Troller0001 said:
It seems that this is related to your use of NONE when adding UnitClasses (which is a UnitType that does not exist in Units)

Code:

('UNITCLASS_ARCHER2_ATLATLIST', 'TXT_KEY_UNIT_ARCHER', NONE),

I replaced them all by NULL. Even though the DB allowed me to do this, I'm unsure what effects this'll have in-game and I suspect that something will break by doing this.

Yep NULL doesn't work either.

LeeS · Sep 27, 2018

You cannot have a unit-class that has no default unit. This is the issue I was pointing out. While it seems to work, it does not actually work correctly in all game circumstances. Whether you give NULL or 'NONE' as the defual unit for the Unit-Class does not matter. It is the fact that the game cannot find the default unit for that class. The more I try to remember all the issues pertaining to using NULL or 'NONE' as the default unit within the class, I am sure as I can be that one of the consequences can be CTD under the correct circumstances, just as it can be for a Building-Class without a default building.

There are only two methods to deal with the issue in all circumstances:

The lua method I described
Adding an untrainable "dummy unit" as the default unit within the unit-class.

Marsarah · Oct 3, 2019

Hi!
I might have missed this, but I cannot seem to find a place that shows how to actually add an sql file to a mod without using ModBuddy. I have seen some tutorials with using ModBuddy, but I am not using ModBuddy. Instead, I use the method of treating my mod as an expansion and I am adding all the .XML file references in the "Expansion2.Civ5Pkg" file in the DLC\Expansion2 folder of the game. My mod folder is in the same location. Everything works perfectly in multiplayer (added 12 new civilizations), but now I want to modify existing unit stats. I know that i can simply change the actual game files, but wish to do it with an UPDATE from my mod file. I understand the code, but don't know where the file goes. I placed an .sql file in an SQL folder in my mod folder and added the entry in the "Expansion2.Civ5Pkg" file but there are no changes. Any leads?

Thank you.

Chrisy15 · Oct 3, 2019

Marsarah said:
Hi!
I might have missed this, but I cannot seem to find a place that shows how to actually add an sql file to a mod without using ModBuddy. I have seen some tutorials with using ModBuddy, but I am not using ModBuddy. Instead, I use the method of treating my mod as an expansion and I am adding all the .XML file references in the "Expansion2.Civ5Pkg" file in the DLC\Expansion2 folder of the game. My mod folder is in the same location. Everything works perfectly in multiplayer (added 12 new civilizations), but now I want to modify existing unit stats. I know that i can simply change the actual game files, but wish to do it with an UPDATE from my mod file. I understand the code, but don't know where the file goes. I placed an .sql file in an SQL folder in my mod folder and added the entry in the "Expansion2.Civ5Pkg" file but there are no changes. Any leads?

Thank you.

If the file is loading it might leave a trace in the Stopwatch log, though I don't think it tracks DLC files; you will be getting an error in your Database log if the SQL itself has a problem though, which would result in your change not being reflected.

whoward69 · Oct 3, 2019

Marsarah said:
I placed an .sql file in an SQL folder in my mod folder and added the entry in the "Expansion2.Civ5Pkg" file but there are no changes.

There are no .sql files referenced in any of the Firaxis .civ5pkg files, so it's highly unlikely that they are supported. Why can't you do the updates with XML?

Marsarah · Oct 10, 2019

Hmm. It makes sense that sql files might not be supported since there are no .sql references in .civ5pkg.
Trying it with XML does not work. I will go off topic if I will write my xml code in here. I'll look into the XML part more. Thanks!

SQL modding for dummies! (specially those that still use XML)

Chrisy15

Flower, Beautiful

Equilin

King

Attachments

Troller0001

I've anxiously awaited your arrival!

Equilin

King

Troller0001

I've anxiously awaited your arrival!

Equilin

King

Equilin

King

Troller0001

I've anxiously awaited your arrival!

LeeS

Imperator

LeeS

Imperator

LeeS

Imperator

Equilin

King

LeeS

Imperator

Marsarah

Chieftain

Chrisy15

Flower, Beautiful

whoward69

DLL Minion

Marsarah

Chieftain

Similar threads