--==========================================================================================================================
-- BUILDINGS
--==========================================================================================================================
-- Buildings
------------------------------
INSERT INTO Buildings
        (TYPE,                      BuildingClass, Cost, PrereqTech, Description,                       Civilopedia,                            Help,                                   Strategy,                                   GreatWorkCount, GreatWorkSlotType,              ArtDefineTag,   MinAreaSize, NeverCapture,  HurryCostModifier, PortraitIndex,   IconAtlas)
SELECT  'BUILDING_GPUZ_KHAZIRA',    BuildingClass, Cost, PrereqTech, 'TXT_KEY_BUILDING_GPUZ_KHAZIRA',   'TXT_KEY_BUILDING_GPUZ_KHAZIRA_TEXT',   'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP',   'TXT_KEY_BUILDING_GPUZ_KHAZIRA_STRATEGY',   2,              'GREAT_WORK_SLOT_LITERATURE',   ArtDefineTag,   MinAreaSize, 1,             HurryCostModifier, 3,               'GPUZ_NODIRA_ICON_ATLAS'
FROM Buildings WHERE TYPE = 'BUILDING_TEMPLE';

INSERT INTO Buildings
        (TYPE,                                      BuildingClass,                  SpecialistType,         GreatPeopleRateModifier,    GreatPeopleRateChange,  TradeRouteRecipientBonus,   TradeRouteTargetBonus,  GreatWorkCount, NeverCapture,   Cost, FaithCost, PrereqTech, Description,                               Help)
VALUES  ('BUILDING_GPUZ_KHAZIRA_GREAT_PERSON',      'BUILDINGCLASS_GPUZ_KOKAND',    NULL,                   25,                         0,                      0,                          0,                      -1,             1,              -1,   -1,        NULL,       'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP',  'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP'),
        ('BUILDING_GPUZ_KUHISTON_TRADE',            'BUILDINGCLASS_GPUZ_KOKAND',    NULL,                   0,                          0,                      1,                          1,                      -1,             1,              -1,   -1,       NULL,        'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP',  'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP'),
        ('BUILDING_GPUZ_NODIRA_GREAT_WRITERS',      'BUILDINGCLASS_GPUZ_KOKAND',    'SPECIALIST_WRITER',    0,                          3,                      0,                          0,                      -1,             1,              -1,   -1,       NULL,        'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP',  'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP'),
        ('BUILDING_GPUZ_NODIRA_WRITING_SCIENCE',    'BUILDINGCLASS_GPUZ_KOKAND',    NULL,                   0,                          0,                      0,                          0,                      -1,             1,              -1,   -1,       NULL,        'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP',  'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP'),
        ('BUILDING_GPUZ_NODIRA_TRADE_SCIENCE',      'BUILDINGCLASS_GPUZ_KOKAND',    NULL,                   0,                          0,                      0,                          0,                      -1,             1,              -1,   -1,       NULL,        'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP',  'TXT_KEY_BUILDING_GPUZ_KHAZIRA_HELP');
------------------------------
-- Building_Flavors
------------------------------
INSERT INTO Building_Flavors
        (BuildingType,              FlavorType, Flavor)
SELECT  'BUILDING_GPUZ_KHAZIRA',    FlavorType, Flavor
FROM Building_Flavors WHERE BuildingType = 'BUILDING_TEMPLE';

INSERT INTO Building_Flavors
        (BuildingType,              FlavorType, Flavor)
SELECT  'BUILDING_GPUZ_KHAZIRA',    FlavorType, Flavor
FROM Building_Flavors WHERE BuildingType = 'BUILDING_AMPHITHEATER';
--------------------------------
-- Building_YieldChanges
--------------------------------
INSERT INTO Building_YieldChanges
            (BuildingType,              YieldType,  Yield)
SELECT      'BUILDING_GPUZ_KHAZIRA',    YieldType,  Yield
FROM Building_YieldChanges WHERE BuildingType = 'BUILDING_TEMPLE';

INSERT INTO Building_YieldChanges
            (BuildingType,                              YieldType,          Yield)
VALUES      ('BUILDING_GPUZ_NODIRA_TRADE_SCIENCE',      'YIELD_SCIENCE',    1),
            ('BUILDING_GPUZ_NODIRA_WRITING_SCIENCE',    'YIELD_SCIENCE',    2)

--------------------------------
-- Building_ThemingBonuses
--------------------------------
INSERT INTO Building_ThemingBonuses
            (BuildingType,              Bonus,  SameEra,    RequiresOwner,  AIPriority)
VALUES      ('BUILDING_GPUZ_KHAZIRA',   2,      1,          1,              6)