-----------------------------------------------------------------------------------------------------
--Defines
-----------------------------------------------------------------------------------------------------
CREATE TABLE Era_PlagueDefines (EraType TEXT DEFAULT NULL, HealthMin INTEGER DEFAULT 0, MaxRange INTEGER DEFAULT 0, MaxDuration INTEGER DEFAULT 0);
CREATE TABLE BuildingClass_Health (BuildingClassType TEXT DEFAULT NULL, Yield INTEGER DEFAULT 0);
CREATE TABLE Resource_Health (ResourceType TEXT DEFAULT NULL, Yield INTEGER DEFAULT 0);
CREATE TABLE Technology_Health (TechType TEXT DEFAULT NULL, Yield INTEGER DEFAULT 0);
CREATE TABLE PolicyBranch_Health (PolicyBranchType TEXT DEFAULT NULL, Yield INTEGER DEFAULT 0);
CREATE TABLE Feature_Health (FeatureType TEXT DEFAULT NULL, Yield INTEGER DEFAULT 0);
INSERT INTO Defines (Name, Value)
SELECT 'PLAGUE_BASE_INIT_THRESHOLD', 15 UNION ALL
SELECT 'PLAGUE_BASE_COOLDOWN_TURNS', 25 UNION ALL
SELECT 'PLAGUE_BASE_BORDER_PERMEABILITY', 1.25 UNION ALL
SELECT 'PLAGUE_BASE_INFLUENCE_MOD', 0.85 UNION ALL
SELECT 'PLAGUE_BASE_PROPAGATE_THRESHOLD', 20 UNION ALL
SELECT 'PLAGUE_CITY_AOE_DMG_PERCENT', 20 UNION ALL
SELECT 'PLAGUE_CITY_TRADE_RANGE_MOD', 0.65 UNION ALL
SELECT 'PLAGUE_CITY_TRADE_LOCAL_MOD', 0.8 UNION ALL
SELECT 'PLAGUE_CITY_BASE_DEATH_THRESHOLD', 70 UNION ALL
SELECT 'PLAGUE_CITY_BASE_HEALING_MALUS', 13 UNION ALL
SELECT 'PLAGUE_CITY_ADJ_DISEASE_UNIT', -2 UNION ALL
SELECT 'PLAGUE_BASE_SPY_SABOTAGE_THRESHOLD', 1 UNION ALL
SELECT 'PLAGUE_BASE_FRESHWATER_HEALTH', 8 UNION ALL
SELECT 'PLAGUE_BASE_UNHAPPY_HEALTH', 2;
INSERT INTO Era_PlagueDefines (EraType, HealthMin, MaxRange, MaxDuration)
SELECT 'ERA_ANCIENT', 2, 5, 6 UNION ALL
SELECT 'ERA_CLASSICAL', 3, 6, 7 UNION ALL
SELECT 'ERA_MEDIEVAL', 6, 7, 8 UNION ALL
SELECT 'ERA_RENAISSANCE', 5, 8, 7 UNION ALL
SELECT 'ERA_INDUSTRIAL', 4, 9, 6 UNION ALL
SELECT 'ERA_MODERN', 3, 10, 5 UNION ALL
SELECT 'ERA_POSTMODERN', 2, 12, 5 UNION ALL
SELECT 'ERA_FUTURE', 1, 14, 4;
INSERT INTO BuildingClass_Health (BuildingClassType, Yield)
SELECT 'BUILDINGCLASS_KERKER', -3 UNION ALL
SELECT 'BUILDINGCLASS_STABLE', -1 UNION ALL
SELECT 'BUILDINGCLASS_STONE_WORKS', -1 UNION ALL
SELECT 'BUILDINGCLASS_CIRCUS', -1 UNION ALL
SELECT 'BUILDINGCLASS_FORGE', -1 UNION ALL
SELECT 'BUILDINGCLASS_WORKSHOP', -1 UNION ALL
SELECT 'BUILDINGCLASS_IRONWORKS', -1 UNION ALL
SELECT 'BUILDINGCLASS_COLOSSEUM', -1 UNION ALL
SELECT 'BUILDINGCLASS_THEATRE', -1 UNION ALL
SELECT 'BUILDINGCLASS_HARBOR', -1 UNION ALL
SELECT 'BUILDINGCLASS_FACTORY', -3 UNION ALL
SELECT 'BUILDINGCLASS_HOTEL', -1 UNION ALL
SELECT 'BUILDINGCLASS_AIRPORT', -2 UNION ALL
SELECT 'BUILDINGCLASS_TOURIST_CENTER', -1 UNION ALL
SELECT 'BUILDINGCLASS_CATHEDRAL', 1 UNION ALL
SELECT 'BUILDINGCLASS_CONSTABLE', 1 UNION ALL
SELECT 'BUILDINGCLASS_POLICE_STATION', 1 UNION ALL
SELECT 'BUILDINGCLASS_MOSQUE', 1 UNION ALL
SELECT 'BUILDINGCLASS_PAGODA', 1 UNION ALL
SELECT 'BUILDINGCLASS_HERDER', 1 UNION ALL
SELECT 'BUILDINGCLASS_APOTHECARY', 1 UNION ALL
SELECT 'BUILDINGCLASS_BUTCHER', 1 UNION ALL
SELECT 'BUILDINGCLASS_SAGE', 1 UNION ALL
SELECT 'BUILDINGCLASS_MINER', 1 UNION ALL
SELECT 'BUILDINGCLASS_TRADER', 1 UNION ALL
SELECT 'BUILDINGCLASS_GARDEN2', 1 UNION ALL
SELECT 'BUILDINGCLASS_SMITH', 1 UNION ALL
SELECT 'BUILDINGCLASS_ESTATE', 1 UNION ALL
SELECT 'BUILDINGCLASS_MERCHANT', 1 UNION ALL
SELECT 'BUILDINGCLASS_CATTLE_DRIVER', 1 UNION ALL
SELECT 'BUILDINGCLASS_ALCHEMIST', 1 UNION ALL
SELECT 'BUILDINGCLASS_MANUFACTURER', 1 UNION ALL
SELECT 'BUILDINGCLASS_VENDER', 1 UNION ALL
SELECT 'BUILDINGCLASS_RANCHER', 1 UNION ALL
SELECT 'BUILDINGCLASS_PLANTATION', 1 UNION ALL
SELECT 'BUILDINGCLASS_HERBALIST', 1 UNION ALL
SELECT 'BUILDINGCLASS_GUILD', 1 UNION ALL
SELECT 'BUILDINGCLASS_FOOD_PROCESSING_PLANT', 2 UNION ALL
SELECT 'BUILDINGCLASS_CHEMICAL_PLANT', -1 UNION ALL
SELECT 'BUILDINGCLASS_PRISON', -1 UNION ALL
SELECT 'BUILDINGCLASS_SUPERMARKET', 2 UNION ALL
SELECT 'BUILDINGCLASS_BIOTECH_INDUSTRIAL_PARK', 2 UNION ALL
SELECT 'BUILDINGCLASS_ARCOLOGY', 3 UNION ALL
SELECT 'BUILDINGCLASS_IMPLANT_STATION', 3 UNION ALL
SELECT 'BUILDINGCLASS_BEEF_VAT', 2 UNION ALL
SELECT 'BUILDINGCLASS_BIO_MEMORY_IMPLANT', 2 UNION ALL
SELECT 'BUILDINGCLASS_BODY_EXCHANGE', 3 UNION ALL
SELECT 'BUILDINGCLASS_SHOPPING_MALL', 1 UNION ALL
SELECT 'BUILDINGCLASS_TOWN_HALL', 1 UNION ALL
SELECT 'BUILDINGCLASS_BOND_MARKET', 1 UNION ALL
SELECT 'BUILDINGCLASS_DRUG_STORE', 2 UNION ALL
SELECT 'BUILDINGCLASS_GIGA_TOWER', 3 UNION ALL
SELECT 'BUILDINGCLASS_DINOSAUR_PARK', -3 UNION ALL
SELECT 'BUILDINGCLASS_TRANSCONTINENTAL_RAILROAD', -1 UNION ALL
SELECT 'BUILDINGCLASS_OIL_REFINERY', -1 UNION ALL
SELECT 'BUILDINGCLASS_WINDMILL', 1 UNION ALL
SELECT 'BUILDINGCLASS_GARDEN', 1 UNION ALL
SELECT 'BUILDINGCLASS_UNIVERSITY', 2 UNION ALL
SELECT 'BUILDINGCLASS_RECYCLING_CENTER', 1 UNION ALL
SELECT 'BUILDINGCLASS_HOSPITAL', 2 UNION ALL
SELECT 'BUILDINGCLASS_MEDICAL_LAB', 3 UNION ALL
SELECT 'BUILDINGCLASS_LABORATORY', 2;
INSERT INTO Resource_Health (ResourceType, Yield)
SELECT 'RESOURCE_IRON', -1 UNION ALL
SELECT 'RESOURCE_COAL', -2 UNION ALL
SELECT 'RESOURCE_OIL', -1 UNION ALL
SELECT 'RESOURCE_URANIUM', -1 UNION ALL
SELECT 'RESOURCE_NUTMEG', 3 UNION ALL
SELECT 'RESOURCE_CLOVES', 3 UNION ALL
SELECT 'RESOURCE_PEPPER', 3 UNION ALL
SELECT 'RESOURCE_BANANA', 2 UNION ALL
SELECT 'RESOURCE_WHEAT', 2 UNION ALL
SELECT 'RESOURCE_COW', 2 UNION ALL
SELECT 'RESOURCE_SHEEP', 2 UNION ALL
SELECT 'RESOURCE_DEER', 2 UNION ALL
SELECT 'RESOURCE_FISH', 2 UNION ALL
SELECT 'RESOURCE_WHALE', 2 UNION ALL
SELECT 'RESOURCE_SPICES', 2 UNION ALL
SELECT 'RESOURCE_WINE', 2 UNION ALL
SELECT 'RESOURCE_SALT', 2 UNION ALL
SELECT 'RESOURCE_CITRUS', 2 UNION ALL
SELECT 'RESOURCE_TEA', 2 UNION ALL
SELECT 'RESOURCE_TITANIUM', 1 UNION ALL
SELECT 'RESOURCE_POPPY', -1 UNION ALL
SELECT 'RESOURCE_ALOE_VERA', 2 UNION ALL
SELECT 'RESOURCE_JADE', 1 UNION ALL
SELECT 'RESOURCE_OAK', 1 UNION ALL
SELECT 'RESOURCE_MANGANESE', 1 UNION ALL
SELECT 'RESOURCE_SQUID', 2 UNION ALL
SELECT 'RESOURCE_AMBER', 1 UNION ALL
SELECT 'RESOURCE_TOBACCO', -1 UNION ALL
SELECT 'RESOURCE_TIN', 1 UNION ALL
SELECT 'RESOURCE_CRAB', 2;
INSERT INTO Technology_Health (TechType, Yield)
SELECT 'TECH_ANIMAL_HUSBANDRY', -1 UNION ALL
SELECT 'TECH_THE_WHEEL', -1 UNION ALL
SELECT 'TECH_SAILING', -1 UNION ALL
SELECT 'TECH_OPTICS', -1 UNION ALL
SELECT 'TECH_COMPASS', -1 UNION ALL
SELECT 'TECH_ASTRONOMY', -1 UNION ALL
SELECT 'TECH_NAVIGATION', -1 UNION ALL
SELECT 'TECH_COMBUSTION', -1 UNION ALL
SELECT 'TECH_FLIGHT', -1 UNION ALL
SELECT 'TECH_GLOBALIZATION', -1 UNION ALL
SELECT 'TECH_POTTERY', 1 UNION ALL
SELECT 'TECH_ENGINEERING', 1 UNION ALL
SELECT 'TECH_CHEMISTRY', 2 UNION ALL
SELECT 'TECH_SCIENTIFIC_THEORY', 2 UNION ALL
SELECT 'TECH_BIOLOGY', 3 UNION ALL
SELECT 'TECH_ELECTRICITY', 3 UNION ALL
SELECT 'TECH_REFRIGERATION', 3 UNION ALL
SELECT 'TECH_PENICILIN', 3 UNION ALL
SELECT 'TECH_ECOLOGY', 3 UNION ALL
SELECT 'TECH_SATELLITES', 3 UNION ALL
SELECT 'TECH_ROBOTICS', 3 UNION ALL
SELECT 'TECH_AGRICULTURAL_REVOLUTION', 2 UNION ALL
SELECT 'TECH_PUBLIC_WORKS', 1 UNION ALL
SELECT 'TECH_ECONOMY_OF_SCALE', 1 UNION ALL
SELECT 'TECH_PHARMACEUTICALS', 3 UNION ALL
SELECT 'TECH_CLONING', 3 UNION ALL
SELECT 'TECH_BIOTECH_INDUSTRY', 3 UNION ALL
SELECT 'TECH_GENETIC_ENGINEERING', 3 UNION ALL
SELECT 'TECH_FERMENTATION', 1 UNION ALL
SELECT 'TECH_BIOLOGICAL_SYNTHESIS', 3 UNION ALL
SELECT 'TECH_FUNCTIONAL_MRI', 2 UNION ALL
SELECT 'TECH_SOCIAL_NETWORKS', 1 UNION ALL
SELECT 'TECH_VACCINES', 1 UNION ALL
SELECT 'TECH_MOBILE_PHONES', 1 UNION ALL
SELECT 'TECH_INTERNET', 2 UNION ALL
SELECT 'TECH_OCEAN_PIONEERING', -1 UNION ALL
SELECT 'TECH_BONDS', 1 UNION ALL
SELECT 'TECH_TRADE_FAIRS', 1 UNION ALL
SELECT 'TECH_WOODWORKING', -1 UNION ALL
SELECT 'TECH_PRIESTHOOD', 1 UNION ALL
SELECT 'TECH_NANOTECHNOLOGY', 3;
INSERT INTO PolicyBranch_Health (PolicyBranchType, Yield)
SELECT 'POLICY_BRANCH_AUTOCRACY', -1 UNION ALL
SELECT 'POLICY_BRANCH_EXPLORATION', -1 UNION ALL
SELECT 'POLICY_BRANCH_ORDER', 1 UNION ALL
SELECT 'POLICY_BRANCH_RATIONALISM', 1;
INSERT INTO Feature_Health (FeatureType, Yield)
SELECT 'FEATURE_FALLOUT', -3 UNION ALL
SELECT 'FEATURE_FLOOD_PLAINS', -1 UNION ALL
SELECT 'FEATURE_MARSH', -1 UNION ALL
SELECT 'FEATURE_ATOLL', 1 UNION ALL
SELECT 'FEATURE_EL_DORADO', 1 UNION ALL
SELECT 'FEATURE_POTOSI', 1 UNION ALL
SELECT 'FEATURE_FOUNTAIN_YOUTH', 3 UNION ALL
SELECT 'FEATURE_GEYSER', 1 UNION ALL
SELECT 'FEATURE_GIBRALTAR', -1 UNION ALL
SELECT 'FEATURE_VOLCANO', -1 UNION ALL
SELECT 'FEATURE_REEF', -1 UNION ALL
SELECT 'FEATURE_MESA', 1 UNION ALL
SELECT 'FEATURE_CRATER', 1 UNION ALL
SELECT 'FEATURE_FUJI', -1 UNION ALL
SELECT 'FEATURE_OASIS', 3 UNION ALL
SELECT 'FEATURE_ULURU', -1 UNION ALL
SELECT 'FEATURE_SRI_PADA', 1 UNION ALL
SELECT 'FEATURE_MT_KAILASH', 1 UNION ALL
SELECT 'FEATURE_MT_SINAI', 1 UNION ALL
SELECT 'FEATURE_KILIMANJARO', 1 UNION ALL
SELECT 'FEATURE_SOLOMONS_MINES', -1 UNION ALL
SELECT 'FEATURE_LAKE_VICTORIA', 3 UNION ALL
SELECT 'FEATURE_JUNGLE', 1 UNION ALL
SELECT 'FEATURE_FOREST', 2;
-----------------------------------------------------------------------------------------------------
--Font Mapping
-----------------------------------------------------------------------------------------------------
INSERT INTO IconFontTextures (IconFontTexture, IconFontTextureFile)
SELECT 'ICON_FONT_TEXTURE_PLAGUE', 'Plague-FontIcons';
INSERT INTO IconFontMapping (IconName, IconFontTexture, IconMapping)
SELECT 'ICON_HEALTH', 'ICON_FONT_TEXTURE_PLAGUE', 1 UNION ALL
SELECT 'ICON_PLAGUE', 'ICON_FONT_TEXTURE_PLAGUE', 2;
-----------------------------------------------------------------------------------------------------
--Buildings
-----------------------------------------------------------------------------------------------------
INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor)
SELECT 'BUILDING_AQUEDUCT', 'FLAVOR_PRODUCTION', 3 UNION ALL
SELECT 'BUILDING_AQUEDUCT', 'FLAVOR_CULTURE', 3 UNION ALL
SELECT 'BUILDING_AQUEDUCT', 'FLAVOR_GOLD', 3 UNION ALL
SELECT 'BUILDING_AQUEDUCT', 'FLAVOR_HAPPINESS', 3 UNION ALL
SELECT 'BUILDING_AQUEDUCT', 'FLAVOR_CITY_DEFENSE', 3;
-----------------------------------------------------------------------------------------------------
--Promotions
-----------------------------------------------------------------------------------------------------
INSERT INTO UnitPromotions (Type, CannotBeChosen, DefenseMod, Description, Help, PediaEntry, IconAtlas, PortraitIndex, Sound, PediaType)
SELECT 'PROMOTION_PLAGUED', 1, -50, 'TXT_KEY_PROMOTION_PLAGUED', 'TXT_KEY_PROMOTION_PLAGUED_HELP', 'TXT_KEY_PROMOTION_PLAGUED', 'PROMOTION_ATLAS', 57, 'AS2D_IF_LEVELUP', 'PEDIA_ATTRIBUTES';
-----------------------------------------------------------------------------------------------------
--Pedia Entries
-----------------------------------------------------------------------------------------------------
INSERT INTO Concepts (Type, Topic, Description, Summary, AdvisorQuestion, Advisor, CivilopediaHeaderType, InsertBefore)
SELECT 'CONCEPT_HEALTH_CITY', 'TXT_KEY_TOPIC_CITIES', 'TXT_KEY_CITIES_HEALTH_HEADING3_TITLE', 'TXT_KEY_CITIES_HEALTH_HEADING3_BODY', 'TXT_KEY_CITIES_ADV_QUEST', 'ECONOMIC', 'HEADER_CITIES', 'CONCEPT_CITIES' UNION ALL
SELECT 'CONCEPT_HEALTH_EMPIRE', 'TXT_KEY_TOPIC_CITIES', 'TXT_KEY_EMPIRE_HEALTH_HEADING3_TITLE', 'TXT_KEY_EMPIRE_HEALTH_HEADING3_BODY', 'TXT_KEY_CITIES_ADV_QUEST', 'ECONOMIC', 'HEADER_CITIES', 'CONCEPT_CITIES' UNION ALL
SELECT 'CONCEPT_HEALTH_PLAGUE', 'TXT_KEY_TOPIC_CITIES', 'TXT_KEY_CITIES_PLAGUE_HEADING3_TITLE', 'TXT_KEY_CITIES_PLAGUE_HEADING3_BODY', 'TXT_KEY_CITIES_ADV_QUEST', 'ECONOMIC', 'HEADER_CITIES', 'CONCEPT_CITIES';
-----------------------------------------------------------------------------------------------------
--Compatibility
-----------------------------------------------------------------------------------------------------
ALTER TABLE Buildings ADD IsVisible boolean DEFAULT 1;