--=======================================================================================================================
-- BUILDINGCLASSES
--=======================================================================================================================
-- BuildingClasses
------------------------------
INSERT INTO BuildingClasses
(Type, DefaultBuilding, Description, NoLimit)
VALUES ('BUILDINGCLASS_SMH_RUSFED', 'BUILDING_SMH_RUSFED', 'TXT_KEY_BUILDING_SMH_RUSFED', 1);
--==========================================================================================================================
-- BUILDINGS
--==========================================================================================================================
-- Buildings
------------------------------
INSERT INTO Buildings
(Type, BuildingClass, Cost, SpecialistType, SpecialistCount, GoldMaintenance, PrereqTech, Description, Help, Civilopedia, Strategy, ArtDefineTag, MinAreaSize, NeverCapture, HurryCostModifier, PortraitIndex, IconAtlas)
SELECT 'BUILDING_SMH_OBLAST', BuildingClass, 1500, SpecialistType, SpecialistCount, GoldMaintenance, STEAM_POWER, 'TXT_KEY_BUILDING_SMH_OBLAST', 'TXT_KEY_SMH_OBLAST_HELP', 'TXT_KEY_CIV5_SMH_OBLAST_TEXT', 'TXT_KEY_BUILDING_SMH_OBLAST_STRATEGY', ArtDefineTag, MinAreaSize, NeverCapture, HurryCostModifier, 3, 'JFD_RUSSIA_PUTIN_ATLAS'
FROM Buildings WHERE Type = 'BUILDING_COAL_PLANT';
INSERT INTO Buildings
(Type, BuildingClass, Cost, GreatWorkCount, FaithCost, PrereqTech, GoldMaintenance, Description, MinAreaSize, HurryCostModifier, PortraitIndex, IconAtlas, NeverCapture)
VALUES ('BUILDING_SMH_OBLAST_YIELD_MODIFIER', 'BUILDINGCLASS_SMH_RUSFED', -1, -1, -1, NULL, 0, 'TXT_KEY_BUILDING_SMH_OBLAST_YIELD_MODIFIER', -1, -1, 10, 'CITIZEN_ATLAS', 1);
------------------------------
-- Building_Flavors
------------------------------
INSERT INTO Building_Flavors
(BuildingType, FlavorType, Flavor)
SELECT 'BUILDING_SMH_OBLAST', FlavorType, Flavor
FROM Building_Flavors WHERE BuildingType = 'BUILDING_COAL_PLANT';
INSERT INTO Building_Flavors
(BuildingType, FlavorType, Flavor)
VALUES ('BUILDING_SMH_OBLAST', 'FLAVOR_INFRASTRUCTURE', 30);
INSERT INTO Building_Flavors
(BuildingType, FlavorType, Flavor)
VALUES ('BUILDING_SMH_OBLAST', 'FLAVOR_EXPANSION', 30);
INSERT INTO Building_Flavors
(BuildingType, FlavorType, Flavor)
VALUES ('BUILDING_SMH_OBLAST', 'FLAVOR_GROWTH', 15);
------------------------------
-- Building_YieldModifiers
------------------------------
INSERT INTO Building_YieldModifiers
(BuildingType, YieldType, Yield)
VALUES ('BUILDING_SMH_OBLAST_YIELD_MODIFIER', 'YIELD_GOLD', 5),
('BUILDING_SMH_OBLAST_YIELD_MODIFIER', 'YIELD_CULTURE', 5),
('BUILDING_SMH_OBLAST_YIELD_MODIFIER', 'YIELD_FOOD', 5);