INSERT INTO Unit_AITypes
(UnitType, UnitAIType)
VALUES ('UNIT_ZEPPELIN', 'UNITAI_ASSAULT_SEA'),
('UNIT_ZEPPELIN', 'UNITAI_COUNTER'),
('UNIT_ZEPPELIN', 'UNITAI_RANGED');
INSERT INTO Unit_Flavors
(UnitType, FlavorType, Flavor)
VALUES ('UNIT_ZEPPELIN', 'FLAVOR_OFFENSE', 5),
('UNIT_ZEPPELIN', 'FLAVOR_DEFENSE', 5),
('UNIT_ZEPPELIN', 'FLAVOR_RANGED', 5),
('UNIT_ZEPPELIN', 'FLAVOR_MOBILE', 5),
('UNIT_ZEPPELIN', 'FLAVOR_NAVAL_RECON', 35),
('UNIT_ZEPPELIN', 'FLAVOR_NAVAL', 15);
DELETE FROM Unit_FreePromotions WHERE UnitType = 'UNIT_ZEPPELIN';
INSERT INTO Unit_FreePromotions
(UnitType, PromotionType)
VALUES ('UNIT_ZEPPELIN', 'PROMOTION_IGNORE_TERRAIN_COST'),
('UNIT_ZEPPELIN', 'PROMOTION_RECON_EXPERIENCE'),
('UNIT_ZEPPELIN', 'PROMOTION_EXTRA_SIGHT_I'),
('UNIT_ZEPPELIN', 'PROMOTION_HOVER_UNIT'),
('UNIT_ZEPPELIN', 'PROMOTION_SCOUT_GOODY_BONUS');
UPDATE Units
SET Pillage = 0
WHERE Type = 'UNIT_ZEPPELIN';
INSERT INTO UnitPromotions_UnitCombats
(PromotionType, UnitCombatType)
VALUES ('PROMOTION_SUB_PATROL', 'UNITCOMBAT_NAVALMELEE');
INSERT INTO UnitPromotions_UnitClasses
(PromotionType, UnitClassType, Defense)
VALUES ('PROMOTION_HOVER_UNIT', 'UNITCLASS_SUBMARINE', 75),
('PROMOTION_HOVER_UNIT', 'UNITCLASS_NUCLEAR_SUBMARINE', 75);
UPDATE UnitPromotions
SET LostWithUpgrade = 1, HoveringUnit = 1, CanMoveImpassable = 1, CanMoveAllTerrain = 1, AllowsEmbarkation = 0, EmbarkedAllWater = 0, EnemyHealChange = -5, NeutralHealChange = -10, ExtraWithdrawal = 30, EmbarkDefenseModifier = 0, EmbarkedDeepWater = 0
WHERE Type = 'PROMOTION_HOVER_UNIT';
INSERT INTO UnitPromotions
(Type, Description, Help, PortraitIndex, IconAtlas, Sound, CannotBeChosen, LostWithUpgrade, VisibilityChange, HoveringUnit, CanMoveImpassable, CanMoveAllTerrain, EnemyHealChange, NeutralHealChange, EnemyDamageChance, NeutralDamageChance, EnemyDamage, NeutralDamage, SeeInvisible, PediaType, PediaEntry, AddedFromNearbyPromotion, IsNearbyPromotion, NearbyRange)
VALUES ('PROMOTION_SUB_PATROL', 'TXT_KEY_PROMOTION_SUB_PATROL', 'TXT_KEY_PROMOTION_SUB_PATROL_HELP', 58, 'ABILITY_ATLAS', 'AS2D_IF_LEVELUP', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'INVISIBLE_SUBMARINE', 'PEDIA_NAVAL', 'TXT_KEY_PROMOTION_SUB_PATROL', 'PROMOTION_HOVER_UNIT', 1, 1);
INSERT INTO UnitPromotions_UnitCombats
(PromotionType, UnitCombatType)
VALUES ('PROMOTION_SUB_PATROL', 'UNITCOMBAT_NAVALMELEE'),
('PROMOTION_SUB_PATROL', 'UNITCOMBAT_NAVALRANGED');
UPDATE Language_en_US
SET Text = 'Airship'
WHERE Tag = 'TXT_KEY_PROMOTION_HOVER_UNIT';
UPDATE Language_en_US
SET Text = 'Hovering unit. Can move over all Terrain and Water tiles. Cannot heal outside friendly territory without medic support. 30% chance to withdraw before melee attacks.'
WHERE Tag = 'TXT_KEY_PROMOTION_HOVER_UNIT_HELP';
INSERT INTO Language_en_US
(Tag, Text)
VALUES ('TXT_KEY_PROMOTION_SUB_PATROL', 'Submarine Patrol'),
('TXT_KEY_PROMOTION_SUB_PATROL_HELP', 'Nearby airship has provided ability to spot submarines.');