UnitUpdates.sql

-- From Unit SQL maker.xlsx, just select column A and paste into UnitUpdates.sql
UPDATE Units SET PromotionClass = 'PROMOTION_CLASS_RECON', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 30, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_SCOUT' ;
UPDATE Units SET PromotionClass = 'PROMOTION_CLASS_RECON', BaseSightRange = 3, BaseMoves = 3, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 30, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_CREE_OKIHTCITAW' ;
UPDATE Units SET PromotionClass = 'PROMOTION_CLASS_RECON', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 30, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_INCA_CHASQUI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 10, RangedCombat = 20, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 35, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_SLINGER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 3, Combat = 10, RangedCombat = 15, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 35, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_BARBARIAN_HORSE_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 20, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 40, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_BARBARIAN_HORSEMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 30, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 40, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_WARRIOR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 38, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_AZTEC_EAGLE_WARRIOR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 3, BaseMoves = 2, Combat = 17, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 35, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_BABYLONIAN_SABUM_KIBITTUM' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 30, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 60, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_GAUL_GAESATAE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 2, Combat = 10, RangedCombat = 20, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 60, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 3, Combat = 12, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 70, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_NUBIAN_PITATI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 2, Combat = 10, RangedCombat = 23, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 60, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_MAYAN_HULCHE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 38, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_SPEARMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 38, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_GREEK_HOPLITE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 38, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 40, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_SUMERIAN_PHALANX' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 28, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 0, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_HEAVY_CHARIOT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 30, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 55, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_SUMERIAN_WAR_CART' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 28, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 0, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_GAUL_CARRUS' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_BATTERING_RAM' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 10, RangedCombat = 20, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 65, Maintenance = 0, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_CHARIOT_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 20, RangedCombat = 30, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 90, Maintenance = 0, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_EGYPTIAN_CHARIOT_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_NORWEGIAN_ULFHEDNAR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 120, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_KONGO_MEDICINE_MAN' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_HORSEMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_MACEDONIAN_HETAIROI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_ROMAN_EQUITE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 2, Combat = 22, RangedCombat = 32, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 85, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_COMPOSITE_BOWMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_HEAVY_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 90, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_SWORDSMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 34, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 90, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_AZTEC_JAGUAR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 90, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_EGYPTIAN_KHOPESH' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 110, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_KONGO_SHIELD_BEARER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MACEDONIAN_HYPASPIST' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 36, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 120, Maintenance = 0, StrategicResource = NULL WHERE UnitType = 'UNIT_MAORI_TOA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 30, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_PERSIAN_IMMORTAL' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 1, Combat = 40, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 110, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ROMAN_LEGION' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_MONK', BaseSightRange = 2, BaseMoves = 3, Combat = 35, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_WARRIOR_MONK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_MONK', BaseSightRange = 2, BaseMoves = 3, Combat = 40, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_INDONESIAN_KRIS_SWORDSMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 3, Combat = 15, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_HORSE_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 15, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_SCYTHIAN_HORSE_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 3, Combat = 15, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_ARABIAN_CAMEL_ARCHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 15, RangedCombat = 30, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 80, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_PHOENICIA_NUMIDIAN_CAVALRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 25, RangedCombat = 29, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_PELTAST' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 28, RangedCombat = 33, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 60, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_GREEK_PELTAST' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 20, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 60, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_ZULU_ASSEGAI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_CHINESE_SHIGONG' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 40, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_ARMORED_HORSEMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 2, Combat = 40, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_PERSIAN_CATAPHRACT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ELEPHANT', BaseSightRange = 2, BaseMoves = 2, Combat = 40, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_INDIAN_VARU' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ELEPHANT', BaseSightRange = 2, BaseMoves = 2, Combat = 40, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_NUBIAN_AFRICAN_FOREST_ELEPHANT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 2, Combat = 23, RangedCombat = 0, Bombard = 35, Range = 1, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_CATAPULT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 2, Combat = 23, RangedCombat = 0, Bombard = 35, Range = 1, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_MACEDONIAN_BALLISTA' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 100, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_SIEGE_TOWER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 20, RangedCombat = 30, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 150, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_SKIRMISHER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 20, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 165, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_INCA_WARAKAQ' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 44, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_LONGSWORDSMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 45, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 140, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_GEORGIAN_KHEVSURETI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 46, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ELEANOR_TEMPLAR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_JAPANESE_SAMURAI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 40, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_NORWEGIAN_BERSERKER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 46, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_SCOTTISH_GALLOWGLASS' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 46, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MAYAN_HOLKAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_BYZANTINE_VARANGIAN_GUARD' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 170, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_MILITARY_ENGINEER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 42, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 180, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_JAPANESE_SOHEI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 33, RangedCombat = 37, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_AXE_THROWER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 30, RangedCombat = 50, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 160, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_CHINESE_CROUCHING_TIGER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 2, Combat = 30, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_CROSSBOWMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 2, Combat = 30, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_ENGLISH_LONGBOWMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ARCHER', BaseSightRange = 2, BaseMoves = 2, Combat = 30, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_MALI_SOFA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 30, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_MOUNTED_CROSSBOW' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 30, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_HUNGARY_KALANDOZO' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 30, RangedCombat = 40, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_MONGOLIAN_KESHIG' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 41, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 180, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_PIKEMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 45, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 80, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_GERMAN_LANDSKNECHT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 45, RangedCombat = 33, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 160, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_MAPUCHE_GUERILLA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 41, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 125, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_ZULU_IMPI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 44, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_COURSER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 47, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 205, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_HUNGARY_BLACK_ARMY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 3, BaseMoves = 5, Combat = 46, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_ETHIOPIAN_OROMO_CAVALRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 44, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 150, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_RUSSIAN_DRUZHINA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 2, Combat = 33, RangedCombat = 0, Bombard = 45, Range = 1, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_TREBUCHET' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 2, Combat = 38, RangedCombat = 0, Bombard = 50, Range = 1, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_MONGOLIAN_HUI_HUI_PAO' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_ELEPHANT', BaseSightRange = 2, BaseMoves = 2, Combat = 33, RangedCombat = 0, Bombard = 45, Range = 1, AntiAirCombat = 0, Cost = 220, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_KHMER_DOMREY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 220, Maintenance = 4, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_KNIGHT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 220, Maintenance = 4, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ARABIAN_MAMLUK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 50, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_FRENCH_GENDARME' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 180, Maintenance = 3, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_GEORGIAN_TADZREULI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 49, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 220, Maintenance = 4, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MALI_MANDEKALU_CAVALRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 50, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 220, Maintenance = 4, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_OTTOMAN_SIPAHI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_SCYTHIAN_AMAZON' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_MAPUCHE_MALON_RAIDER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 3, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_POLISH_HUSSAR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 220, Maintenance = 4, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_BYZANTINE_TAGMA' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 40, RangedCombat = 50, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 230, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_CULVERIN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 240, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_MUSKETMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_DUTCH_SCHUTTERIJ' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_SPANISH_CONQUISTADOR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 60, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 120, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_SULEIMAN_JANISSARY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_DEFENSIVE_GUN', BaseSightRange = 2, BaseMoves = 2, Combat = 43, RangedCombat = 47, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 240, Maintenance = 3, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_ARQUEBUSIER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_PIKE_AND_SHOT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 60, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_SPANISH_TERCIO' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 52, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 3, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_HARQUEBUSIER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 56, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 260, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_REITER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 42, RangedCombat = 52, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 250, Maintenance = 3, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_STRADIOT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 43, RangedCombat = 0, Bombard = 55, Range = 2, AntiAirCombat = 0, Cost = 280, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_BOMBARD' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 61, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 420, Maintenance = 4, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_LANCER' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AERIAL_OBSERVATION', BaseSightRange = 4, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 240, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_OBSERVATION_BALLOON' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_LINE_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_SWEDEN_CAROLEAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 320, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_RIFLEMAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 65, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 340, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_ENGLISH_REDCOAT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 65, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 340, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_FRENCH_GARDE_IMPERIALE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 64, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 350, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_INDIAN_SEPOY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 64, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 310, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_COLOMBIAN_BRITISH_LEGION' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 64, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 310, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_ETHIOPIAN_MEHAL_SEFARI' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_DEFENSIVE_GUN', BaseSightRange = 2, BaseMoves = 2, Combat = 53, RangedCombat = 57, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 320, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_GATLING_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_MARINE', BaseSightRange = 2, BaseMoves = 2, Combat = 60, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 350, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_INDUSTRIAL_MARINE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 5, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_CAVALRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 5, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_CREE_OTEHTAPIW' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 65, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 335, Maintenance = 5, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_HUNGARY_HUSZAR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 5, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_POLISH_UHLAN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 67, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 340, Maintenance = 5, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_RUSSIAN_COSSACK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 2, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_COLOMBIAN_LLANERO' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 62, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 5, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_SWEDEN_HAKKAPELIITTA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 64, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 5, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_CUIRASSIER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 67, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 385, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_AMERICAN_ROUGH_RIDER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 50, RangedCombat = 60, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 330, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_FIELD_CANNON' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 45, RangedCombat = 60, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 250, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_KOREAN_HWACHA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 4, Combat = 50, RangedCombat = 60, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 350, Maintenance = 5, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_HORSE_ARTILLERY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 53, RangedCombat = 0, Bombard = 65, Range = 2, AntiAirCombat = 0, Cost = 360, Maintenance = 5, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_RIFLED_CANNON' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 370, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_MEDIC' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 45, RangedCombat = 60, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_RANGER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 46, RangedCombat = 60, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 220, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_BRAZILIAN_BANDEIRANTE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 45, RangedCombat = 55, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_MAORI_TUPARA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 50, RangedCombat = 65, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_SCOTTISH_HIGHLANDER' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AERIAL_OBSERVATION', BaseSightRange = 4, BaseMoves = 4, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 330, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_RECON_HELICOPTER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 65, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 390, Maintenance = 5, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_EARLY_LIGHT_TANK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_DEFENSIVE_GUN', BaseSightRange = 2, BaseMoves = 2, Combat = 61, RangedCombat = 65, Bombard = 0, Range = 2, AntiAirCombat = 50, Cost = 400, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_MACHINE_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 60, RangedCombat = 68, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 400, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_ANTI_TANK_RIFLE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 70, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 410, Maintenance = 6, StrategicResource = 'RESOURCE_HORSES' WHERE UnitType = 'UNIT_MOUNTED_RIFLES' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIREARM_CAVALRY', BaseSightRange = 4, BaseMoves = 5, Combat = 60, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 400, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_CANADA_MOUNTIE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_DEFENSIVE_GUN', BaseSightRange = 2, BaseMoves = 4, Combat = 61, RangedCombat = 65, Bombard = 0, Range = 1, AntiAirCombat = 50, Cost = 420, Maintenance = 5, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ARMORED_CAR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 80, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 420, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_LANDSHIP' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 58, RangedCombat = 68, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 420, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_FIELD_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 70, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 430, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_WW1_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 80, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 430, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_DIGGER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 2, Combat = 63, RangedCombat = 0, Bombard = 75, Range = 2, AntiAirCombat = 0, Cost = 450, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ARTILLERY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 4, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 450, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_SUPPLY_CONVOY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 2, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 1, AntiAirCombat = 90, Cost = 455, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_ANTIAIR_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_INFANTRY', BaseSightRange = 2, BaseMoves = 5, Combat = 80, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 470, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ARMORED_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 68, RangedCombat = 72, Bombard = 0, Range = 1, AntiAirCombat = 60, Cost = 490, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_AT_CREW' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 88, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 530, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_TANK' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AERIAL_OBSERVATION', BaseSightRange = 5, BaseMoves = 3, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 420, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_DRONE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_MARINE', BaseSightRange = 2, BaseMoves = 2, Combat = 76, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 430, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_WW2_MARINE' ;
UPDATE Units SET PromotionClass = 'PROMOTION_CLASS_RECON', BaseSightRange = 2, BaseMoves = 5, Combat = 72, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 450, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_LIGHT_TANK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 70, RangedCombat = 75, Bombard = 0, Range = 1, AntiAirCombat = 66, Cost = 490, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_ANTI_TANK_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 80, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 500, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 65, RangedCombat = 75, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 500, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_FIELD_HOWITZER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_DEFENSIVE_GUN', BaseSightRange = 2, BaseMoves = 4, Combat = 68, RangedCombat = 72, Bombard = 0, Range = 1, AntiAirCombat = 60, Cost = 510, Maintenance = 6, StrategicResource = 'RESOURCE_OIL' WHERE UnitType = 'UNIT_ASSAULT_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 4, Combat = 70, RangedCombat = 75, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 510, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_TANK_DESTROYER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 4, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 1, AntiAirCombat = 75, Cost = 520, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_MOBILE_AAA' ;
UPDATE Units SET PromotionClass = 'PROMOTION_CLASS_RECON', BaseSightRange = 2, BaseMoves = 3, Combat = 60, RangedCombat = 65, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 520, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_SPEC_OPS' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 3, Combat = 72, RangedCombat = 0, Bombard = 88, Range = 3, AntiAirCombat = 0, Cost = 560, Maintenance = 7, StrategicResource = 'RESOURCE_OIL' WHERE UnitType = 'UNIT_HEAVY_HOWITZER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 4, Combat = 65, RangedCombat = 75, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 560, Maintenance = 6, StrategicResource = 'RESOURCE_OIL' WHERE UnitType = 'UNIT_SP_HOWITZER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 4, BaseMoves = 4, Combat = 75, RangedCombat = 85, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 600, Maintenance = 7, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_HELICOPTER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 4, BaseMoves = 4, Combat = 78, RangedCombat = 88, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 600, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_AMERICAN_AH64_APACHE' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 3, Combat = 78, RangedCombat = 82, Bombard = 0, Range = 1, AntiAirCombat = 70, Cost = 580, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_MODERN_AT' ;
UPDATE Units SET PromotionClass = 'PROMOTION_CLASS_RECON', BaseSightRange = 2, BaseMoves = 5, Combat = 80, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 580, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ARMORED_CAVALRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUPPORT', BaseSightRange = 2, BaseMoves = 4, Combat = 0, RangedCombat = 0, Bombard = 0, Range = 2, AntiAirCombat = 100, Cost = 590, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_MOBILE_SAM' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 2, Combat = 75, RangedCombat = 85, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 600, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_FIELD_ARTILLERY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 4, Combat = 75, RangedCombat = 85, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 600, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MODERN_TANK_DEST' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_DEFENSIVE_GUN', BaseSightRange = 2, BaseMoves = 4, Combat = 78, RangedCombat = 82, Bombard = 0, Range = 1, AntiAirCombat = 70, Cost = 600, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MOBILE_GUN_SYSTEM' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_INFANTRY', BaseSightRange = 2, BaseMoves = 2, Combat = 90, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 640, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_MODERN_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 5, Combat = 90, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 650, Maintenance = 8, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MECHANIZED_INFANTRY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_LIGHT_CAVALRY', BaseSightRange = 2, BaseMoves = 6, Combat = 96, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 650, Maintenance = 8, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_AUSTRALIAN_SASR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_MARINE', BaseSightRange = 2, BaseMoves = 4, Combat = 86, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 650, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_MODERN_MARINE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 2, BaseMoves = 4, Combat = 75, RangedCombat = 85, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 675, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_SP_GUN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_HEAVY_CAVALRY', BaseSightRange = 2, BaseMoves = 4, Combat = 98, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 680, Maintenance = 8, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_MODERN_ARMOR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SIEGE', BaseSightRange = 2, BaseMoves = 4, Combat = 83, RangedCombat = 0, Bombard = 95, Range = 3, AntiAirCombat = 0, Cost = 680, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_ROCKET_ARTILLERY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_FIELD_ARTILLERY', BaseSightRange = 5, BaseMoves = 4, Combat = 60, RangedCombat = 80, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 700, Maintenance = 7, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_UAV' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_GIANT_DEATH_ROBOT', BaseSightRange = 2, BaseMoves = 5, Combat = 130, RangedCombat = 120, Bombard = 0, Range = 3, AntiAirCombat = 0, Cost = 1500, Maintenance = 15, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_GIANT_DEATH_ROBOT' ;


UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 2, BaseMoves = 3, Combat = 25, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_GALLEY' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 2, BaseMoves = 3, Combat = 25, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_BARBARIAN_RAIDER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 2, BaseMoves = 3, Combat = 25, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_KHMER_WAR_CANOE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 2, BaseMoves = 3, Combat = 30, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_NORWEGIAN_LONGSHIP' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 2, BaseMoves = 4, Combat = 30, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 65, Maintenance = 1, StrategicResource = NULL WHERE UnitType = 'UNIT_PHOENICIA_BIREME' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 3, Combat = 25, RangedCombat = 25, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_QUADRIREME' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 25, RangedCombat = 0, Bombard = 39, Range = 1, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_GREEK_FIRE_SHIP' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 3, Combat = 25, RangedCombat = 25, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 120, Maintenance = 2, StrategicResource = NULL WHERE UnitType = 'UNIT_BYZANTINE_DROMON' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 3, BaseMoves = 3, Combat = 48, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_COG' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 3, Combat = 40, RangedCombat = 41, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 200, Maintenance = 3, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_GALLEASS' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 40, RangedCombat = 0, Bombard = 50, Range = 1, AntiAirCombat = 0, Cost = 280, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_CARRACK' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RECONRAIDER', BaseSightRange = 3, BaseMoves = 4, Combat = 50, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_CARAVEL' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RECONRAIDER', BaseSightRange = 3, BaseMoves = 5, Combat = 55, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 250, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_KOREAN_TURTLE_SHIP' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RECONRAIDER', BaseSightRange = 3, BaseMoves = 5, Combat = 61, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_CORVETTE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RECONRAIDER', BaseSightRange = 2, BaseMoves = 4, Combat = 45, RangedCombat = 54, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_PRIVATEER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RECONRAIDER', BaseSightRange = 2, BaseMoves = 4, Combat = 45, RangedCombat = 54, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 260, Maintenance = 3, StrategicResource = NULL WHERE UnitType = 'UNIT_OTTOMAN_BARBARY_CORSAIR' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 4, Combat = 50, RangedCombat = 55, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_FRIGATE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 4, Combat = 55, RangedCombat = 60, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_DE_ZEVEN_PROVINCIEN' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 5, Combat = 50, RangedCombat = 55, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = NULL WHERE UnitType = 'UNIT_INDONESIAN_JONG' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 50, RangedCombat = 0, Bombard = 71, Range = 2, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_SHIP_OF_THE_LINE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 55, RangedCombat = 0, Bombard = 76, Range = 2, AntiAirCombat = 0, Cost = 300, Maintenance = 4, StrategicResource = 'RESOURCE_NITER' WHERE UnitType = 'UNIT_ENGLISH_SHIP_OF_THE_LINE' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 3, BaseMoves = 5, Combat = 66, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = NULL WHERE UnitType = 'UNIT_IRONCLAD' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RECONRAIDER', BaseSightRange = 2, BaseMoves = 4, Combat = 55, RangedCombat = 54, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_RAIDER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 4, Combat = 60, RangedCombat = 59, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ARMORED_CRUISER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 60, RangedCombat = 0, Bombard = 78, Range = 2, AntiAirCombat = 0, Cost = 380, Maintenance = 5, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_PRE_DREADNOUGHT' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 3, BaseMoves = 6, Combat = 74, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_TORPEDO_GUNBOAT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 5, Combat = 70, RangedCombat = 60, Bombard = 0, Range = 2, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_LIGHT_CRUISER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUBMARINE', BaseSightRange = 2, BaseMoves = 4, Combat = 65, RangedCombat = 54, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_SUBMARINE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUBMARINE', BaseSightRange = 2, BaseMoves = 4, Combat = 65, RangedCombat = 54, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 410, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_GERMAN_UBOAT' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 70, RangedCombat = 0, Bombard = 78, Range = 3, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_DREADNOUGHT' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 3, BaseMoves = 6, Combat = 83, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 75, Cost = 580, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_DESTROYER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 2, BaseMoves = 6, Combat = 83, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 75, Cost = 580, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_CANADA_HMCS_HAIDA' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 2, BaseMoves = 5, Combat = 75, RangedCombat = 77, Bombard = 0, Range = 2, AntiAirCombat = 100, Cost = 560, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_BATTLECRUISER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 75, RangedCombat = 0, Bombard = 87, Range = 3, AntiAirCombat = 75, Cost = 600, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_BATTLESHIP' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 3, Combat = 85, RangedCombat = 0, Bombard = 97, Range = 3, AntiAirCombat = 80, Cost = 520, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_BRAZILIAN_MINAS_GERAES' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_CARRIER', BaseSightRange = 2, BaseMoves = 4, Combat = 65, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 580, Maintenance = 7, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_AIRCRAFT_CARRIER' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_RANGED', BaseSightRange = 3, BaseMoves = 5, Combat = 70, RangedCombat = 85, Bombard = 0, Range = 5, AntiAirCombat = 110, Cost = 680, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_MISSILE_DESTROYER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_MELEE', BaseSightRange = 3, BaseMoves = 5, Combat = 90, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 85, Cost = 660, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_MISSILE_FRIGATE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_BOMBARD', BaseSightRange = 2, BaseMoves = 5, Combat = 90, RangedCombat = 90, Bombard = 0, Range = 3, AntiAirCombat = 130, Cost = 690, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_MISSILE_CRUISER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUBMARINE', BaseSightRange = 2, BaseMoves = 4, Combat = 90, RangedCombat = 73, Bombard = 0, Range = 1, AntiAirCombat = 0, Cost = 680, Maintenance = 8, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_NUCLEAR_SUBMARINE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_SUBMARINE', BaseSightRange = 2, BaseMoves = 5, Combat = 61, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 550, Maintenance = 8, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_ATTACK_SUBMARINE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_NAVAL_CARRIER', BaseSightRange = 2, BaseMoves = 5, Combat = 80, RangedCombat = 0, Bombard = 0, Range = 0, AntiAirCombat = 0, Cost = 680, Maintenance = 8, StrategicResource = 'RESOURCE_IRON' WHERE UnitType = 'UNIT_SUPERCARRIER' ;


UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_FIGHTER', BaseSightRange = 4, BaseMoves = 6, Combat = 80, RangedCombat = 70, Bombard = 0, Range = 5, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_BIPLANE' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_ATTACK', BaseSightRange = 2, BaseMoves = 6, Combat = 70, RangedCombat = 80, Bombard = 0, Range = 5, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_WW1_GROUND_ATTACK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_BOMBER', BaseSightRange = 2, BaseMoves = 6, Combat = 60, RangedCombat = 0, Bombard = 85, Range = 7, AntiAirCombat = 0, Cost = 460, Maintenance = 6, StrategicResource = NULL WHERE UnitType = 'UNIT_WW1_BOMBER' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_FIGHTER', BaseSightRange = 4, BaseMoves = 8, Combat = 105, RangedCombat = 95, Bombard = 0, Range = 8, AntiAirCombat = 0, Cost = 580, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_FIGHTER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_FIGHTER', BaseSightRange = 4, BaseMoves = 10, Combat = 110, RangedCombat = 100, Bombard = 0, Range = 8, AntiAirCombat = 0, Cost = 580, Maintenance = 7, StrategicResource = NULL WHERE UnitType = 'UNIT_AMERICAN_P51' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_ATTACK', BaseSightRange = 2, BaseMoves = 8, Combat = 95, RangedCombat = 105, Bombard = 0, Range = 8, AntiAirCombat = 0, Cost = 580, Maintenance = 7, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_GROUND_ATTACK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_BOMBER', BaseSightRange = 2, BaseMoves = 10, Combat = 85, RangedCombat = 0, Bombard = 110, Range = 10, AntiAirCombat = 0, Cost = 580, Maintenance = 7, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_BOMBER' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_FIGHTER', BaseSightRange = 5, BaseMoves = 10, Combat = 115, RangedCombat = 105, Bombard = 0, Range = 10, AntiAirCombat = 0, Cost = 690, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_JET_FIGHTER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_ATTACK', BaseSightRange = 2, BaseMoves = 10, Combat = 105, RangedCombat = 115, Bombard = 0, Range = 10, AntiAirCombat = 0, Cost = 690, Maintenance = 8, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_JET_GROUND_ATTACK' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_BOMBER', BaseSightRange = 2, BaseMoves = 15, Combat = 90, RangedCombat = 0, Bombard = 120, Range = 15, AntiAirCombat = 0, Cost = 690, Maintenance = 8, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_JET_BOMBER' ;

UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_FIGHTER', BaseSightRange = 5, BaseMoves = 10, Combat = 125, RangedCombat = 115, Bombard = 0, Range = 10, AntiAirCombat = 0, Cost = 800, Maintenance = 8, StrategicResource = NULL WHERE UnitType = 'UNIT_STEALTH_FIGHTER' ;
UPDATE Units SET PromotionClass = 'BW_PROMOTION_CLASS_AIR_BOMBER', BaseSightRange = 2, BaseMoves = 15, Combat = 100, RangedCombat = 0, Bombard = 130, Range = 15, AntiAirCombat = 0, Cost = 800, Maintenance = 8, StrategicResource = 'RESOURCE_ALUMINUM' WHERE UnitType = 'UNIT_STEALTH_BOMBER' ;


















INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HEAVY_CHARIOT', 1, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GAUL_CARRUS', 1, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_CHARIOT_ARCHER', 1, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_EGYPTIAN_CHARIOT_ARCHER', 1, NULL, 0) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HORSEMAN', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MACEDONIAN_HETAIROI', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ROMAN_EQUITE', 10, NULL, 0) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SWORDSMAN', 20, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_EGYPTIAN_KHOPESH', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_KONGO_SHIELD_BEARER', 5, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MACEDONIAN_HYPASPIST', 5, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_PERSIAN_IMMORTAL', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ROMAN_LEGION', 10, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_INDONESIAN_KRIS_SWORDSMAN', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HORSE_ARCHER', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SCYTHIAN_HORSE_ARCHER', 5, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_PHOENICIA_NUMIDIAN_CAVALRY', 10, NULL, 0) ;




INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARMORED_HORSEMAN', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_PERSIAN_CATAPHRACT', 10, NULL, 0) ;








INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_LONGSWORDSMAN', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GEORGIAN_KHEVSURETI', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ELEANOR_TEMPLAR', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_JAPANESE_SAMURAI', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_NORWEGIAN_BERSERKER', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SCOTTISH_GALLOWGLASS', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MAYAN_HOLKAN', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BYZANTINE_VARANGIAN_GUARD', 20, NULL, 0) ;







INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MOUNTED_CROSSBOW', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HUNGARY_KALANDOZO', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MONGOLIAN_KESHIG', 10, NULL, 0) ;




INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_COURSER', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HUNGARY_BLACK_ARMY', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ETHIOPIAN_OROMO_CAVALRY', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_RUSSIAN_DRUZHINA', 10, NULL, 0) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_KNIGHT', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARABIAN_MAMLUK', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_FRENCH_GENDARME', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GEORGIAN_TADZREULI', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MALI_MANDEKALU_CAVALRY', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_OTTOMAN_SIPAHI', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SCYTHIAN_AMAZON', 10, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_POLISH_HUSSAR', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BYZANTINE_TAGMA', 10, NULL, 0) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MUSKETMAN', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_DUTCH_SCHUTTERIJ', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SPANISH_CONQUISTADOR', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SULEIMAN_JANISSARY', 10, NULL, 0) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HARQUEBUSIER', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_REITER', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_STRADIOT', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BOMBARD', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_LANCER', 20, NULL, 0) ;




INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_RIFLEMAN', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ENGLISH_REDCOAT', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_FRENCH_GARDE_IMPERIALE', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_INDIAN_SEPOY', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_COLOMBIAN_BRITISH_LEGION', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ETHIOPIAN_MEHAL_SEFARI', 20, NULL, 0) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_CAVALRY', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_CREE_OTEHTAPIW', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HUNGARY_HUSZAR', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_POLISH_UHLAN', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_RUSSIAN_COSSACK', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_COLOMBIAN_LLANERO', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SWEDEN_HAKKAPELIITTA', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_CUIRASSIER', 20, NULL, 0) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HORSE_ARTILLERY', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_RIFLED_CANNON', 20, NULL, 0) ;







INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_EARLY_LIGHT_TANK', 1, 'RESOURCE_OIL', 1) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MOUNTED_RIFLES', 20, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARMORED_CAR', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_LANDSHIP', 1, 'RESOURCE_OIL', 1) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARTILLERY', 1, NULL, 0) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARMORED_INFANTRY', 1, 'RESOURCE_OIL', 1) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_TANK', 1, 'RESOURCE_OIL', 1) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_LIGHT_TANK', 1, 'RESOURCE_OIL', 1) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ASSAULT_GUN', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_TANK_DESTROYER', 1, 'RESOURCE_OIL', 1) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HEAVY_HOWITZER', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SP_HOWITZER', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_HELICOPTER', 30, 'RESOURCE_OIL', 1) ;



INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARMORED_CAVALRY', 1, 'RESOURCE_OIL', 1) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MODERN_TANK_DEST', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MOBILE_GUN_SYSTEM', 1, 'RESOURCE_OIL', 1) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MECHANIZED_INFANTRY', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_AUSTRALIAN_SASR', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MODERN_MARINE', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SP_GUN', 1, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_MODERN_ARMOR', 50, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ROCKET_ARTILLERY', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_UAV', 40, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GIANT_DEATH_ROBOT', 50, 'RESOURCE_URANIUM', 3) ;












INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GALLEASS', 10, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_CARRACK', 20, NULL, 0) ;




INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_PRIVATEER', 20, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_FRIGATE', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_DE_ZEVEN_PROVINCIEN', 10, NULL, 0) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SHIP_OF_THE_LINE', 20, NULL, 0) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ENGLISH_SHIP_OF_THE_LINE', 20, NULL, 0) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_RAIDER', 20, 'RESOURCE_COAL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ARMORED_CRUISER', 20, 'RESOURCE_COAL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_PRE_DREADNOUGHT', 20, 'RESOURCE_COAL', 1) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_LIGHT_CRUISER', 30, 'RESOURCE_COAL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SUBMARINE', 30, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GERMAN_UBOAT', 30, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_DREADNOUGHT', 30, 'RESOURCE_COAL', 1) ;




INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BATTLESHIP', 40, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BRAZILIAN_MINAS_GERAES', 40, 'RESOURCE_COAL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_AIRCRAFT_CARRIER', 40, 'RESOURCE_OIL', 1) ;




INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_NUCLEAR_SUBMARINE', 50, 'RESOURCE_URANIUM', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_ATTACK_SUBMARINE', 50, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_SUPERCARRIER', 50, 'RESOURCE_URANIUM', 1) ;


INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BIPLANE', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_WW1_GROUND_ATTACK', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_WW1_BOMBER', 0, 'RESOURCE_OIL', 1) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_FIGHTER', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_AMERICAN_P51', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_GROUND_ATTACK', 20, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_BOMBER', 20, 'RESOURCE_OIL', 1) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_JET_FIGHTER', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_JET_GROUND_ATTACK', 30, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_JET_BOMBER', 30, 'RESOURCE_OIL', 1) ;

INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_STEALTH_FIGHTER', 0, 'RESOURCE_OIL', 1) ;
INSERT INTO Units_XP2 (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount) VALUES ('UNIT_STEALTH_BOMBER', 40, 'RESOURCE_OIL', 1) ;





INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SLINGER', 'UNIT_PELTAST') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_WARRIOR', 'UNIT_SPEARMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_AZTEC_EAGLE_WARRIOR', 'UNIT_SPEARMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BABYLONIAN_SABUM_KIBITTUM', 'UNIT_SPEARMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GAUL_GAESATAE', 'UNIT_SPEARMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARCHER', 'UNIT_COMPOSITE_BOWMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_NUBIAN_PITATI', 'UNIT_COMPOSITE_BOWMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MAYAN_HULCHE', 'UNIT_COMPOSITE_BOWMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SPEARMAN', 'UNIT_HEAVY_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GREEK_HOPLITE', 'UNIT_HEAVY_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SUMERIAN_PHALANX', 'UNIT_HEAVY_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HEAVY_CHARIOT', 'UNIT_HORSEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SUMERIAN_WAR_CART', 'UNIT_HORSEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GAUL_CARRUS', 'UNIT_HORSEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BATTERING_RAM', 'UNIT_SIEGE_TOWER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CHARIOT_ARCHER', 'UNIT_HORSE_ARCHER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_EGYPTIAN_CHARIOT_ARCHER', 'UNIT_HORSE_ARCHER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_NORWEGIAN_ULFHEDNAR', 'UNIT_MEDIC') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_KONGO_MEDICINE_MAN', 'UNIT_MEDIC') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HORSEMAN', 'UNIT_ARMORED_HORSEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MACEDONIAN_HETAIROI', 'UNIT_ARMORED_HORSEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ROMAN_EQUITE', 'UNIT_ARMORED_HORSEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_COMPOSITE_BOWMAN', 'UNIT_CROSSBOWMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HEAVY_INFANTRY', 'UNIT_SWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SWORDSMAN', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_AZTEC_JAGUAR', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_EGYPTIAN_KHOPESH', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_KONGO_SHIELD_BEARER', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MACEDONIAN_HYPASPIST', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MAORI_TOA', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PERSIAN_IMMORTAL', 'UNIT_LONGSWORDSMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ROMAN_LEGION', 'UNIT_LONGSWORDSMAN') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HORSE_ARCHER', 'UNIT_MOUNTED_CROSSBOW') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SCYTHIAN_HORSE_ARCHER', 'UNIT_MOUNTED_CROSSBOW') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARABIAN_CAMEL_ARCHER', 'UNIT_MOUNTED_CROSSBOW') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PHOENICIA_NUMIDIAN_CAVALRY', 'UNIT_MOUNTED_CROSSBOW') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PELTAST', 'UNIT_SKIRMISHER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GREEK_PELTAST', 'UNIT_SKIRMISHER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ZULU_ASSEGAI', 'UNIT_SKIRMISHER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CHINESE_SHIGONG', 'UNIT_MEDIC') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARMORED_HORSEMAN', 'UNIT_COURSER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PERSIAN_CATAPHRACT', 'UNIT_COURSER') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CATAPULT', 'UNIT_TREBUCHET') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MACEDONIAN_BALLISTA', 'UNIT_TREBUCHET') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SKIRMISHER', 'UNIT_AXE_THROWER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_INCA_WARAKAQ', 'UNIT_AXE_THROWER') ;











INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CHINESE_CROUCHING_TIGER', 'UNIT_CULVERIN') ;



INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MOUNTED_CROSSBOW', 'UNIT_STRADIOT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HUNGARY_KALANDOZO', 'UNIT_STRADIOT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MONGOLIAN_KESHIG', 'UNIT_STRADIOT') ;




INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_COURSER', 'UNIT_KNIGHT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HUNGARY_BLACK_ARMY', 'UNIT_KNIGHT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ETHIOPIAN_OROMO_CAVALRY', 'UNIT_KNIGHT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_RUSSIAN_DRUZHINA', 'UNIT_KNIGHT') ;



INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_KNIGHT', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARABIAN_MAMLUK', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_FRENCH_GENDARME', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GEORGIAN_TADZREULI', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MALI_MANDEKALU_CAVALRY', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_OTTOMAN_SIPAHI', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SCYTHIAN_AMAZON', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MAPUCHE_MALON_RAIDER', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_POLISH_HUSSAR', 'UNIT_LANCER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BYZANTINE_TAGMA', 'UNIT_LANCER') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CULVERIN', 'UNIT_RIFLED_CANNON') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MUSKETMAN', 'UNIT_RIFLEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_DUTCH_SCHUTTERIJ', 'UNIT_RIFLEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SPANISH_CONQUISTADOR', 'UNIT_RIFLEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SULEIMAN_JANISSARY', 'UNIT_RIFLEMAN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARQUEBUSIER', 'UNIT_GATLING_GUN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PIKE_AND_SHOT', 'UNIT_LINE_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SPANISH_TERCIO', 'UNIT_LINE_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HARQUEBUSIER', 'UNIT_CAVALRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_REITER', 'UNIT_CUIRASSIER') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BOMBARD', 'UNIT_ARTILLERY') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_OBSERVATION_BALLOON', 'UNIT_RECON_HELICOPTER') ;








INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GATLING_GUN', 'UNIT_MACHINE_GUN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_INDUSTRIAL_MARINE', 'UNIT_WW2_MARINE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CAVALRY', 'UNIT_MOUNTED_RIFLES') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CREE_OTEHTAPIW', 'UNIT_MOUNTED_RIFLES') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HUNGARY_HUSZAR', 'UNIT_MOUNTED_RIFLES') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_POLISH_UHLAN', 'UNIT_MOUNTED_RIFLES') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_RUSSIAN_COSSACK', 'UNIT_MOUNTED_RIFLES') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_COLOMBIAN_LLANERO', 'UNIT_MOUNTED_RIFLES') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SWEDEN_HAKKAPELIITTA', 'UNIT_MOUNTED_RIFLES') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_FIELD_CANNON', 'UNIT_FIELD_GUN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_KOREAN_HWACHA', 'UNIT_FIELD_GUN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HORSE_ARTILLERY', 'UNIT_SP_HOWITZER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_RIFLED_CANNON', 'UNIT_ARTILLERY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MEDIC', 'UNIT_SUPPLY_CONVOY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_RANGER', 'UNIT_SPEC_OPS') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BRAZILIAN_BANDEIRANTE', 'UNIT_SPEC_OPS') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MAORI_TUPARA', 'UNIT_SPEC_OPS') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SCOTTISH_HIGHLANDER', 'UNIT_SPEC_OPS') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_RECON_HELICOPTER', 'UNIT_DRONE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_EARLY_LIGHT_TANK', 'UNIT_LIGHT_TANK') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MACHINE_GUN', 'UNIT_AT_CREW') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MOUNTED_RIFLES', 'UNIT_ARMORED_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CANADA_MOUNTIE', 'UNIT_ARMORED_INFANTRY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARMORED_CAR', 'UNIT_ASSAULT_GUN') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_LANDSHIP', 'UNIT_TANK') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_FIELD_GUN', 'UNIT_FIELD_HOWITZER') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARTILLERY', 'UNIT_HEAVY_HOWITZER') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ANTIAIR_GUN', 'UNIT_MOBILE_AAA') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARMORED_INFANTRY', 'UNIT_MECHANIZED_INFANTRY') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_TANK', 'UNIT_MODERN_ARMOR') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_DRONE', 'UNIT_UAV') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_WW2_MARINE', 'UNIT_MODERN_MARINE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_LIGHT_TANK', 'UNIT_ARMORED_CAVALRY') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_FIELD_HOWITZER', 'UNIT_FIELD_ARTILLERY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ASSAULT_GUN', 'UNIT_MOBILE_GUN_SYSTEM') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_MOBILE_AAA', 'UNIT_MOBILE_SAM') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_HEAVY_HOWITZER', 'UNIT_ROCKET_ARTILLERY') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SP_HOWITZER', 'UNIT_SP_GUN') ;





















INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GALLEY', 'UNIT_COG') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BARBARIAN_RAIDER', 'UNIT_COG') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_KHMER_WAR_CANOE', 'UNIT_COG') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_NORWEGIAN_LONGSHIP', 'UNIT_COG') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PHOENICIA_BIREME', 'UNIT_COG') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_QUADRIREME', 'UNIT_GALLEASS') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GREEK_FIRE_SHIP', 'UNIT_CARRACK') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BYZANTINE_DROMON', 'UNIT_GALLEASS') ;


INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GALLEASS', 'UNIT_FRIGATE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CARRACK', 'UNIT_SHIP_OF_THE_LINE') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CARAVEL', 'UNIT_CORVETTE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_KOREAN_TURTLE_SHIP', 'UNIT_CORVETTE') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PRIVATEER', 'UNIT_RAIDER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_OTTOMAN_BARBARY_CORSAIR', 'UNIT_RAIDER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_FRIGATE', 'UNIT_ARMORED_CRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_DE_ZEVEN_PROVINCIEN', 'UNIT_ARMORED_CRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_INDONESIAN_JONG', 'UNIT_ARMORED_CRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SHIP_OF_THE_LINE', 'UNIT_PRE_DREADNOUGHT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ENGLISH_SHIP_OF_THE_LINE', 'UNIT_PRE_DREADNOUGHT') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_IRONCLAD', 'UNIT_TORPEDO_GUNBOAT') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_RAIDER', 'UNIT_SUBMARINE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_ARMORED_CRUISER', 'UNIT_LIGHT_CRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_PRE_DREADNOUGHT', 'UNIT_DREADNOUGHT') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_TORPEDO_GUNBOAT', 'UNIT_DESTROYER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_LIGHT_CRUISER', 'UNIT_BATTLECRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_SUBMARINE', 'UNIT_NUCLEAR_SUBMARINE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GERMAN_UBOAT', 'UNIT_NUCLEAR_SUBMARINE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_DREADNOUGHT', 'UNIT_BATTLESHIP') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_DESTROYER', 'UNIT_MISSILE_FRIGATE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_CANADA_HMCS_HAIDA', 'UNIT_MISSILE_FRIGATE') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BATTLECRUISER', 'UNIT_MISSILE_DESTROYER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BATTLESHIP', 'UNIT_MISSILE_CRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BRAZILIAN_MINAS_GERAES', 'UNIT_MISSILE_CRUISER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_AIRCRAFT_CARRIER', 'UNIT_SUPERCARRIER') ;









INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BIPLANE', 'UNIT_FIGHTER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_WW1_GROUND_ATTACK', 'UNIT_GROUND_ATTACK') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_WW1_BOMBER', 'UNIT_BOMBER') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_FIGHTER', 'UNIT_JET_FIGHTER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_AMERICAN_P51', 'UNIT_JET_FIGHTER') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_GROUND_ATTACK', 'UNIT_JET_GROUND_ATTACK') ;
INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_BOMBER', 'UNIT_JET_BOMBER') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_JET_FIGHTER', 'UNIT_STEALTH_FIGHTER') ;

INSERT INTO UnitUpgrades (Unit, UpgradeUnit) VALUES ('UNIT_JET_BOMBER', 'UNIT_STEALTH_BOMBER') ;






-- INSERT INTO UnitReplaces (CivUniqueUnitType, ReplacesUnitType) VALUES ('UNIT_CREE_OKIHTCITAW', 'UNIT_SCOUT') ;
-- INSERT INTO UnitReplaces (CivUniqueUnitType, ReplacesUnitType) VALUES ('UNIT_INCA_CHASQUI', 'UNIT_SCOUT') ;











-- INSERT INTO UnitReplaces (CivUniqueUnitType, ReplacesUnitType) VALUES ('UNIT_GREEK_HOPLITE', 'UNIT_SPEARMAN') ;
-- INSERT INTO UnitReplaces (CivUniqueUnitType, ReplacesUnitType) VALUES ('UNIT_SUMERIAN_PHALANX', 'UNIT_SPEARMAN') ;




















































































































































































































































DELETE FROM TypeTags WHERE Type = 'ABILITY_100_PERCENT_FLANKING' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_100_PERCENT_FLANKING', 'DB_CLASS_UNIT_OTTOMAN_SIPAHI') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_100_PERCENT_FLANKING', 'DB_CLASS_UNIT_POLISH_UHLAN') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ADDITIONAL_ATTACK' ; 
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ADDITIONAL_ATTACK', 'DB_CLASS_UNIT_MAORI_TUPARA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_AIR_BOMBER_ATTACK_UNIT_DEBUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_AIR_BOMBER_ATTACK_UNIT_DEBUFF', 'BW_CLASS_AIR_BOMBER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_AIR_FIGHTER_ATTACK_DISTRICT_DEBUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_AIR_FIGHTER_ATTACK_DISTRICT_DEBUFF', 'BW_CLASS_AIR_FIGHTER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_AIRPORT_TRAINED_AIRCRAFT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_AIRPORT_TRAINED_AIRCRAFT_XP', 'DB_CLASS_AIR_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ALPINE_TRAINING' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ALPINE_TRAINING', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ALTITUDE_TRAINING' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ALTITUDE_TRAINING', 'CLASS_RELIGIOUS_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_AMERICAN_AH64_APACHE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_AMERICAN_AH64_APACHE', 'DB_CLASS_UNIT_AMERICAN_AH64_APACHE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ANTI_AIR_COVER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ANTI_AIR_COVER', 'CLASS_ANTI_AIR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ARCHAEOLOGIST_ENTER_FOREIGN_LANDS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ARCHAEOLOGIST_ENTER_FOREIGN_LANDS', 'DB_CLASS_UNIT_ARCHAEOLOGIST') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ARMATOLOS' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_ARMORY_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ARMORY_TRAINED_UNIT_XP', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BALKAN_CAVALRY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BALKAN_CAVALRY', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BALLISTA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BALLISTA', 'DB_CLASS_UNIT_MACEDONIAN_BALLISTA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BANDEIRANTE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BANDEIRANTE', 'DB_CLASS_UNIT_BRAZILIAN_BANDEIRANTE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BARBAROSSA_COMBAT_BONUS_VS_CITY_STATES' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BARBAROSSA_COMBAT_BONUS_VS_CITY_STATES', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BARRACKS_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BARRACKS_TRAINED_UNIT_XP', 'DB_CLASS_LAND_NON_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BASILIKOI_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BASILIKOI_TRAINED_UNIT_XP', 'DB_CLASS_LAND_NON_CAVALRY') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BASILIKOI_TRAINED_UNIT_XP', 'DB_CLASS_UNIT_MACEDONIAN_HETAIROI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BERSERKER_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BERSERKER_MOVEMENT', 'DB_CLASS_UNIT_NORWEGIAN_BERSERKER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BERSERKER_RAGE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BERSERKER_RAGE', 'DB_CLASS_UNIT_NORWEGIAN_BERSERKER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BIREME_PROTECT_TRADER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BIREME_PROTECT_TRADER', 'DB_CLASS_UNIT_CANADA_HMCS_HAIDA') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BIREME_PROTECT_TRADER', 'DB_CLASS_UNIT_PHOENICIA_BIREME') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BLACK_ARMY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BLACK_ARMY', 'DB_CLASS_UNIT_HUNGARY_BLACK_ARMY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BOMBARD_ATTACK_UNIT_DEBUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BOMBARD_ATTACK_UNIT_DEBUFF', 'BW_CLASS_SIEGE') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BOMBARD_ATTACK_UNIT_DEBUFF', 'BW_CLASS_SIEGE_ARTILLERY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_BYPASS_WALLS_PROMOTION_CLASS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_BYPASS_WALLS_PROMOTION_CLASS', 'DB_CLASS_UNIT_SIEGE_TOWER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CAMEL_ARCHER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CAMEL_ARCHER', 'DB_CLASS_UNIT_ARABIAN_CAMEL_ARCHER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CAPTIVE_WORKERS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CAPTIVE_WORKERS', 'DB_CLASS_UNIT_AZTEC_EAGLE_WARRIOR') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CAPTIVE_WORKERS', 'DB_CLASS_UNIT_AZTEC_JAGUAR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CAROLEAN' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CAROLEAN', 'DB_CLASS_UNIT_SWEDEN_CAROLEAN') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CHING_SHIH_PLUNDER_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CHING_SHIH_PLUNDER_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CHOLA_NAVAL_COMBAT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CHOLA_NAVAL_COMBAT', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CHOSEN_INFANTRY' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_CLANCY_FERNANDO_BONUS_EXPERIENCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CLANCY_FERNANDO_BONUS_EXPERIENCE', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_COMMUNISM_DEFENSE_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_COMMUNISM_DEFENSE_BUFF', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CONQUISTADOR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CONQUISTADOR', 'DB_CLASS_UNIT_SPANISH_CONQUISTADOR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CORBACI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CORBACI', 'DB_CLASS_UNIT_SULEIMAN_JANISSARY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CORSAIR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CORSAIR', 'DB_CLASS_UNIT_OTTOMAN_BARBARY_CORSAIR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_COSSACK' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_COSSACK', 'DB_CLASS_UNIT_RUSSIAN_COSSACK') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CREE_OTEHTAPIW' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CREE_OTEHTAPIW', 'DB_CLASS_UNIT_CREE_OTEHTAPIW') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_CYBER_WARFARE_COMBAT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_CYBER_WARFARE_COMBAT_BONUS', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_DIGGER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_DIGGER', 'DB_CLASS_UNIT_DIGGER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_DIGITAL_DEMOCRACY_DEBUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_DIGITAL_DEMOCRACY_DEBUFF', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_DRONE_GRANT_SIEGE_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_DRONE_GRANT_SIEGE_BONUS', 'DB_CLASS_UNIT_DRONE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_DRUZHINA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_DRUZHINA', 'DB_CLASS_UNIT_RUSSIAN_DRUZHINA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_DUTCH_SCHUTTERIJ' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_DUTCH_SCHUTTERIJ', 'DB_CLASS_UNIT_DUTCH_SCHUTTERIJ') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_DUTCH_ZEVEN_PROVINCIEN' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_DUTCH_ZEVEN_PROVINCIEN', 'DB_CLASS_UNIT_DE_ZEVEN_PROVINCIEN') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ECONOMIC_GOLDEN_AGE_PLUNDER_IMMUNITY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ECONOMIC_GOLDEN_AGE_PLUNDER_IMMUNITY', 'DB_CLASS_UNIT_TRADER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ENABLE_WALL_ATTACK_PROMOTION_CLASS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ENABLE_WALL_ATTACK_PROMOTION_CLASS', 'DB_CLASS_UNIT_BATTERING_RAM') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_EQUITE_ADJACENCY_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_EQUITE_ADJACENCY_BONUS', 'DB_CLASS_UNIT_ROMAN_EQUITE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ERIKSON_NAVAL_SIGHT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ERIKSON_NAVAL_SIGHT', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_EXPERT_MARKSMAN' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_EXPERT_MARKSMAN', 'DB_CLASS_UNIT_INCA_WARAKAQ') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_EXTRA_MOVEMENT_ON_SNOW_TUNDRA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_EXTRA_MOVEMENT_ON_SNOW_TUNDRA', 'DB_CLASS_UNIT_SWEDEN_HAKKAPELIITTA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_FASCISM_ATTACK_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_FASCISM_ATTACK_BUFF', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_FASCISM_LEGACY_ATTACK_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_FASCISM_LEGACY_ATTACK_BUFF', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_FATHERLAND_VOLUNTEER' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_FINEST_HOUR_FRIENDLY_TERRITORY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_FINEST_HOUR_FRIENDLY_TERRITORY', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_FRANCIS_DRAKE_PLUNDER_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_FRANCIS_DRAKE_PLUNDER_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_FRENCH_MARINE' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_FRIENDLY_TERRITORY_RELIGIOUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_FRIENDLY_TERRITORY_RELIGIOUS', 'DB_CLASS_UNIT_INQUISITOR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GARDE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GARDE', 'DB_CLASS_UNIT_FRENCH_GARDE_IMPERIALE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GARDE_REPUBLICAINE' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_GENDARME' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GENDARME', 'DB_CLASS_UNIT_FRENCH_GENDARME') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GENGHIS_KHAN_CAVALRY_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GENGHIS_KHAN_CAVALRY_BONUS', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GENGHIS_KHAN_CAVALRY_CAPTURE_CAVALRY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GENGHIS_KHAN_CAVALRY_CAPTURE_CAVALRY', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GEORGIAN_KHEVSURETI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GEORGIAN_KHEVSURETI', 'DB_CLASS_UNIT_GEORGIAN_KHEVSURETI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GEORGIAN_TADZREULI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GEORGIAN_TADZREULI', 'DB_CLASS_UNIT_GEORGIAN_TADZREULI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GEORGY_ZHUKOV_FLANKING_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GEORGY_ZHUKOV_FLANKING_BONUS', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GHAZI' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_GITARJA_RELIGIOUS_NO_EMBARK_DISEMBARK_COST' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GITARJA_RELIGIOUS_NO_EMBARK_DISEMBARK_COST', 'CLASS_RELIGIOUS_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GLOBAL_COALITION_FRIENDLY_TERRITORY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GLOBAL_COALITION_FRIENDLY_TERRITORY', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GRANT_MOVEMENT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GRANT_MOVEMENT_BONUS', 'DB_CLASS_UNIT_SUPPLY_CONVOY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_ADMIRAL_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_ADMIRAL_MOVEMENT', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_ADMIRAL_STRENGTH' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_ADMIRAL_STRENGTH', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_GENERAL_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_GENERAL_MOVEMENT', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_GENERAL_STRENGTH' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_GENERAL_STRENGTH', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_LIGHTHOUSE_EMBARKED_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_LIGHTHOUSE_EMBARKED_MOVEMENT', 'DB_CLASS_LAND_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_LIGHTHOUSE_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_LIGHTHOUSE_MOVEMENT', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_GREAT_TURKISH_BOMBARD' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_TURKISH_BOMBARD', 'BW_CLASS_SIEGE') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_GREAT_TURKISH_BOMBARD', 'BW_CLASS_SIEGE_ARTILLERY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HANGAR_TRAINED_AIRCRAFT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HANGAR_TRAINED_AIRCRAFT_XP', 'DB_CLASS_AIR_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HEAL_NEUTRAL_TERRITORY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HEAL_NEUTRAL_TERRITORY', 'BW_CLASS_NAVAL_MELEE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HETAIROI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HETAIROI', 'DB_CLASS_UNIT_MACEDONIAN_HETAIROI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HIRDMAN' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_HOJO_TOKIMUNE_COASTAL_COMBAT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HOJO_TOKIMUNE_COASTAL_COMBAT_BONUS', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HOJO_TOKIMUNE_SHALLOW_WATER_COMBAT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HOJO_TOKIMUNE_SHALLOW_WATER_COMBAT_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HOPLITE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HOPLITE', 'DB_CLASS_UNIT_GREEK_HOPLITE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HORATIO_NELSON_FLANKING_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HORATIO_NELSON_FLANKING_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HUSZAR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HUSZAR', 'DB_CLASS_UNIT_HUNGARY_HUSZAR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_HYPASPIST' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_HYPASPIST', 'DB_CLASS_UNIT_MACEDONIAN_HYPASPIST') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_IGNORE_CROSSING_RIVERS_COST' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_IGNORE_CROSSING_RIVERS_COST', 'BW_CLASS_AERIAL_OBSERVATION') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_IGNORE_CROSSING_RIVERS_COST', 'BW_CLASS_HELICOPTER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_IGNORE_TERRAIN_COST' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_IGNORE_TERRAIN_COST', 'BW_CLASS_AERIAL_OBSERVATION') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_IGNORE_TERRAIN_COST', 'BW_CLASS_HELICOPTER') ;
 
DELETE FROM TypeTags WHERE Type = 'ABILITY_INQUISITION_FRIENDLY_TERRITORY_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_INQUISITION_FRIENDLY_TERRITORY_BONUS', 'CLASS_RELIGIOUS_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_JAGUAR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_JAGUAR', 'DB_CLASS_UNIT_AZTEC_JAGUAR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_JINETE' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_JOHN_MONASH_BONUS_EXPERIENCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_JOHN_MONASH_BONUS_EXPERIENCE', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_JONG' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_JONG', 'DB_CLASS_UNIT_INDONESIAN_JONG') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_KHMER_WAR_CANOE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_KHMER_WAR_CANOE', 'DB_CLASS_UNIT_KHMER_WAR_CANOE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_KNARR_IGNORE_EMBARK_DISEMBARK_COST' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_KNARR_IGNORE_EMBARK_DISEMBARK_COST', 'DB_CLASS_LAND_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_KOREAN_TURTLE_SHIP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_KOREAN_TURTLE_SHIP', 'DB_CLASS_UNIT_KOREAN_TURTLE_SHIP') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_LASKARINA_BOUBOULINA_BONUS_EXPERIENCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_LASKARINA_BOUBOULINA_BONUS_EXPERIENCE', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_LESS_MOVEMENT_PILLAGE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_LESS_MOVEMENT_PILLAGE', 'DB_CLASS_UNIT_HUNGARY_KALANDOZO') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_LESS_MOVEMENT_PILLAGE', 'DB_CLASS_UNIT_OTTOMAN_SIPAHI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_LIGHTHOUSE_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_LIGHTHOUSE_TRAINED_UNIT_XP', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_LONGBOWMAN' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_LONGBOWMAN', 'DB_CLASS_UNIT_ENGLISH_LONGBOWMAN') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_LONGSHIP_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_LONGSHIP_MOVEMENT', 'DB_CLASS_UNIT_NORWEGIAN_LONGSHIP') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MAMLUK' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MAMLUK', 'DB_CLASS_UNIT_ARABIAN_MAMLUK') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MANA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MANA', 'DB_CLASS_LAND_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MANDEKALU' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MANDEKALU', 'DB_CLASS_UNIT_MALI_MANDEKALU_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MAPUCHE_GUERILLA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MAPUCHE_GUERILLA', 'DB_CLASS_UNIT_MAPUCHE_GUERILLA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MAPUCHE_MALON_RAIDER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MAPUCHE_MALON_RAIDER', 'DB_CLASS_UNIT_MAPUCHE_MALON_RAIDER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MARINE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MARINE', 'BW_CLASS_MARINE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MARTYR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MARTYR', 'DB_CLASS_UNIT_MISSIONARY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MEDIC_HEAL' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MEDIC_HEAL', 'DB_CLASS_UNIT_MEDIC') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MEDITERRANEAN_COLONIES' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MEDITERRANEAN_COLONIES', 'DB_CLASS_UNIT_SETTLER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MILITARY_ACADEMY_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MILITARY_ACADEMY_TRAINED_UNIT_XP', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MINUTEMAN' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_MONGOLIAN_HUI_HUI_PAO' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MONGOLIAN_HUI_HUI_PAO', 'DB_CLASS_UNIT_MONGOLIAN_HUI_HUI_PAO') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MONGOLIAN_KESHIG' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MONGOLIAN_KESHIG', 'DB_CLASS_UNIT_MONGOLIAN_KESHIG') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MONTEZUMA_COMBAT_BONUS_PER_LUXURY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MONTEZUMA_COMBAT_BONUS_PER_LUXURY', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MOUNTIE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MOUNTIE', 'DB_CLASS_UNIT_CANADA_MOUNTIE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MOVE_AFTER_ATTACKING' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MOVE_AFTER_ATTACKING', 'DB_CLASS_UNIT_PHOENICIA_NUMIDIAN_CAVALRY') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MOVE_AFTER_ATTACKING', 'DB_CLASS_UNIT_SCYTHIAN_AMAZON') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_MUGHAL_SOWAR' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_MUSTANG' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_MUSTANG', 'DB_CLASS_UNIT_AMERICAN_P51') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_NAGAO' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NAGAO', 'DB_CLASS_UNIT_KONGO_SHIELD_BEARER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_NO_FOREIGN_SPREAD' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NO_FOREIGN_SPREAD', 'DB_CLASS_UNIT_INQUISITOR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_NO_MOVE_AND_SHOOT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NO_MOVE_AND_SHOOT', 'BW_CLASS_SIEGE') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NO_MOVE_AND_SHOOT', 'BW_CLASS_SIEGE_ARTILLERY') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NO_MOVE_AND_SHOOT', 'DB_CLASS_UNIT_KOREAN_HWACHA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_NUBIA_RANGED_EXPERIENCE_MODIFIER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NUBIA_RANGED_EXPERIENCE_MODIFIER', 'BW_CLASS_ARCHER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_NUBIAN_AFRICAN_FOREST_ELEPHANT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_NUBIAN_AFRICAN_FOREST_ELEPHANT', 'DB_CLASS_UNIT_NUBIAN_AFRICAN_FOREST_ELEPHANT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_OBSERVATION_STRENGTH_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_OBSERVATION_STRENGTH_BONUS', 'BW_CLASS_AERIAL_OBSERVATION') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_OLIGARCHY_LEGACY_MELEE_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_OLIGARCHY_LEGACY_MELEE_BUFF', 'DB_CLASS_LAND_MELEE_ATTACKER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_OLIGARCHY_MELEE_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_OLIGARCHY_MELEE_BUFF', 'DB_CLASS_LAND_MELEE_ATTACKER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ORDU_INCREASED_MOVEMENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ORDU_INCREASED_MOVEMENT', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ORDU_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ORDU_TRAINED_UNIT_XP', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PANZER' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_PARADROP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PARADROP', 'DB_CLASS_UNIT_SPEC_OPS') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PERC_50_POST_COMBAT_GOLD' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PERC_50_POST_COMBAT_GOLD', 'DB_CLASS_UNIT_HUNGARY_KALANDOZO') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PERC_50_POST_COMBAT_GOLD', 'DB_CLASS_UNIT_ROMAN_EQUITE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PERSIAN_WARSHIP' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_PEZHETAIROS' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_PHALANX' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PHALANX', 'DB_CLASS_UNIT_SUMERIAN_PHALANX') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PHILIP_II_COMBAT_BONUS_OTHER_RELIGION' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PHILIP_II_COMBAT_BONUS_OTHER_RELIGION', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_10_DEFENDER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_10_DEFENDER', 'DB_CLASS_UNIT_JAPANESE_SOHEI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_5_BONUS_VS_DAMAGED' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_5_BONUS_VS_DAMAGED', 'DB_CLASS_UNIT_EGYPTIAN_KHOPESH') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_5_BONUS_VS_DAMAGED', 'DB_CLASS_UNIT_MALI_SOFA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_5_DEFENDER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_5_DEFENDER', 'DB_CLASS_UNIT_GREEK_PELTAST') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_5_OTHER_RELIGION_COMBAT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_5_OTHER_RELIGION_COMBAT_BONUS', 'DB_CLASS_UNIT_ELEANOR_TEMPLAR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_5_WHEN_ATTACKING' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_5_WHEN_ATTACKING', 'DB_CLASS_UNIT_SWEDEN_HAKKAPELIITTA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_X_HOLY_SITE_PROXIMITY_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_X_HOLY_SITE_PROXIMITY_BONUS', 'DB_CLASS_UNIT_ELEANOR_TEMPLAR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_X_IN_FORMATION_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_X_IN_FORMATION_BONUS', 'DB_CLASS_UNIT_CANADA_HMCS_HAIDA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PLUS_X_VS_NAVAL_RAIDER_COMBAT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PLUS_X_VS_NAVAL_RAIDER_COMBAT_BONUS', 'DB_CLASS_UNIT_CANADA_HMCS_HAIDA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_PRIZE_SHIPS' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_PUSHBACK' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_PUSHBACK', 'DB_CLASS_UNIT_POLISH_HUSSAR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RAJENDRA_CHOLA_PLUNDER_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RAJENDRA_CHOLA_PLUNDER_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RANGED_ATTACK_DISTRICT_DEBUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RANGED_ATTACK_DISTRICT_DEBUFF', 'DB_CLASS_LAND_RANGED_ATTACKER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_BOMBARD_STRENGTH_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_BOMBARD_STRENGTH_BUFF', 'BW_CLASS_SIEGE_ARTILLERY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_HUI_HUI_PAO_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_HUI_HUI_PAO_BONUS', 'BW_CLASS_HEAVY_INFANTRY') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_HUI_HUI_PAO_BONUS', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_KHMER_WAR_CANOE_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_KHMER_WAR_CANOE_BONUS', 'DB_CLASS_LAND_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_MEDICINE_MAN_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_MEDICINE_MAN_BONUS', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_NORWEGIAN_ULFHEDNAR_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_NORWEGIAN_ULFHEDNAR_BONUS', 'DB_CLASS_LAND_COMBAT') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_NORWEGIAN_ULFHEDNAR_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_PERSIAN_WARSHIP_BONUS' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_RANGE_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_RANGE_BONUS', 'BW_CLASS_SIEGE') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_RANGE_BONUS', 'BW_CLASS_SIEGE_ARTILLERY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_SHIGONG_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_SHIGONG_BONUS', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_SOFA_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RECEIVE_SOFA_BONUS', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RECEIVE_WARRIOR_PRIEST_BONUS' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_REDCOAT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_REDCOAT', 'DB_CLASS_UNIT_ENGLISH_REDCOAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RELIGIOUS_CANNOT_ATTACK' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RELIGIOUS_CANNOT_ATTACK', 'DB_CLASS_UNIT_MISSIONARY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_RELIGIOUS_ENTER_FOREIGN_LANDS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_RELIGIOUS_ENTER_FOREIGN_LANDS', 'CLASS_RELIGIOUS_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ROCK_BAND_ENTER_FOREIGN_LANDS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ROCK_BAND_ENTER_FOREIGN_LANDS', 'DB_CLASS_UNIT_ROCK_BAND') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ROMAN_LEGION_BUILD' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ROMAN_LEGION_BUILD', 'DB_CLASS_UNIT_ROMAN_LEGION') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ROOSEVELT_COMBAT_BONUS_HOME_CONTINENT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ROOSEVELT_COMBAT_BONUS_HOME_CONTINENT', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ROUGH_RIDER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ROUGH_RIDER', 'DB_CLASS_UNIT_AMERICAN_ROUGH_RIDER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ROYAL_NAVY_DOCKYARD_MOVEMENT_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ROYAL_NAVY_DOCKYARD_MOVEMENT_BONUS', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SAMURAI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SAMURAI', 'DB_CLASS_UNIT_JAPANESE_SAMURAI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SASR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SASR', 'DB_CLASS_UNIT_AUSTRALIAN_SASR') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SCOTTISH_GALLOWGLASS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SCOTTISH_GALLOWGLASS', 'DB_CLASS_UNIT_SCOTTISH_GALLOWGLASS') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SCOTTISH_HIGHLANDER' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SCOTTISH_HIGHLANDER', 'DB_CLASS_UNIT_SCOTTISH_HIGHLANDER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SEAPORT_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SEAPORT_TRAINED_UNIT_XP', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SEPOY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SEPOY', 'DB_CLASS_UNIT_INDIAN_SEPOY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SERGEY_GORSHKOV_BONUS_EXPERIENCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SERGEY_GORSHKOV_BONUS_EXPERIENCE', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SHIP_OF_THE_LINE_ADJACENCY_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SHIP_OF_THE_LINE_ADJACENCY_BONUS', 'DB_CLASS_UNIT_ENGLISH_SHIP_OF_THE_LINE') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SHIPYARD_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SHIPYARD_TRAINED_UNIT_XP', 'DB_CLASS_NAVAL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SPEAR_OF_FIONN' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SPEAR_OF_FIONN', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_STABLE_TRAINED_UNIT_XP' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_STABLE_TRAINED_UNIT_XP', 'DB_CLASS_LAND_CAVALRY') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_SWEDEN_HAKKAPELIITTA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_SWEDEN_HAKKAPELIITTA', 'DB_CLASS_UNIT_SWEDEN_HAKKAPELIITTA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_T34' ; 
DELETE FROM TypeTags WHERE Type = 'ABILITY_TERCIO' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TERCIO', 'DB_CLASS_UNIT_SPANISH_TERCIO') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_THE_RAVEN_KING' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_THE_RAVEN_KING', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_THEOCRACY_LEGACY_RELIGIOUS_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_THEOCRACY_LEGACY_RELIGIOUS_BUFF', 'CLASS_RELIGIOUS_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_THEOCRACY_RELIGIOUS_BUFF' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_THEOCRACY_RELIGIOUS_BUFF', 'CLASS_RELIGIOUS_ALL') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TIMUR_BONUS_EXPERIENCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TIMUR_BONUS_EXPERIENCE', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TOA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TOA', 'DB_CLASS_UNIT_MAORI_TOA') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TOMYRIS_BONUS_VS_WOUNDED_UNITS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TOMYRIS_BONUS_VS_WOUNDED_UNITS', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TOMYRIS_HEAL_AFTER_DEFEATING_UNIT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TOMYRIS_HEAL_AFTER_DEFEATING_UNIT', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TOQUI_COMBAT_BUFF_VS_GOLDEN_AGE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TOQUI_COMBAT_BUFF_VS_GOLDEN_AGE', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TOQUI_XP_FROM_GOVERNOR' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TOQUI_XP_FROM_GOVERNOR', 'DB_CLASS_ALL_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TRADE_ROUTE_PLUNDER_IMMUNITY_SEA' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TRADE_ROUTE_PLUNDER_IMMUNITY_SEA', 'DB_CLASS_UNIT_TRADER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TRADER_PROTECTED_BY_BIREME' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TRADER_PROTECTED_BY_BIREME', 'DB_CLASS_UNIT_TRADER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TRADER_PROTECTED_BY_MANDEKALU' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TRADER_PROTECTED_BY_MANDEKALU', 'DB_CLASS_UNIT_TRADER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_TWILIGHT_VALOR_ATTACK_BONUS' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TWILIGHT_VALOR_ATTACK_BONUS', 'DB_CLASS_LAND_MELEE_ATTACKER') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_TWILIGHT_VALOR_ATTACK_BONUS', 'DB_CLASS_NAVAL_MELEE_ATTACKER') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_UBOAT' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UBOAT', 'DB_CLASS_UNIT_GERMAN_UBOAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_UNIT_AUTO_VETERANCY' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UNIT_AUTO_VETERANCY', 'BW_CLASS_GIANT_DEATH_ROBOT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_UNIT_FIGHT_WHILE_EMBARKED' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UNIT_FIGHT_WHILE_EMBARKED', 'BW_CLASS_GIANT_DEATH_ROBOT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_UNIT_WMD_RESISTANCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UNIT_WMD_RESISTANCE', 'BW_CLASS_GIANT_DEATH_ROBOT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_UNOBSTRUCTED_VIEW' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UNOBSTRUCTED_VIEW', 'BW_CLASS_AERIAL_OBSERVATION') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UNOBSTRUCTED_VIEW', 'BW_CLASS_HELICOPTER') ;
 INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_UNOBSTRUCTED_VIEW', 'DB_CLASS_AIR_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_VARU' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_VARU', 'DB_CLASS_UNIT_INDIAN_VARU') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_VIJAYA_WIMALARATNE_BONUS_EXPERIENCE' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_VIJAYA_WIMALARATNE_BONUS_EXPERIENCE', 'DB_CLASS_LAND_COMBAT') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ZULU_ASSEGAI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ZULU_ASSEGAI', 'DB_CLASS_UNIT_ZULU_ASSEGAI') ;
DELETE FROM TypeTags WHERE Type = 'ABILITY_ZULU_IMPI' ; INSERT INTO TypeTags (Type, Tag) VALUES ('ABILITY_ZULU_IMPI', 'DB_CLASS_UNIT_ZULU_IMPI') ;