-------------------------------------------------------------

-- GRANARY

-- +1 Housing:

UPDATE Buildings SET Housing = 1

WHERE BuildingType = 'BUILDING_GRANARY_UPGRADE';

-- +1 Food:

INSERT INTO Building_YieldChanges (BuildingType, YieldType, YieldChange) VALUES

('BUILDING_GRANARY_UPGRADE', 'YIELD_FOOD', 1);

-- +1 Food from RESOURCE_BANANAS / RESOURCE_RICE/ RESOURCE_WHEAT/ RESOURCE_CITRUS/ RESOURCE_SALT/ RESOURCE_SPICES/ RESOURCE_SUGAR/ RESOURCE_WINE:

INSERT INTO BuildingModifiers (BuildingType, ModifierId) VALUES

('BUILDING_GRANARY_UPGRADE', 'GRANARY_UPGRADE_ADD_RESOURCE_FOOD');

INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId) VALUES

('GRANARY_UPGRADE_ADD_RESOURCE_FOOD', 'MODIFIER_CITY_PLOT_YIELDS_ADJUST_PLOT_YIELD', 0, 0, NULL, 'RESOURCES_FOR_GRANARY_UPGRADE');

INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES

('GRANARY_UPGRADE_ADD_RESOURCE_FOOD', 'YieldType', 'YIELD_FOOD'),

('GRANARY_UPGRADE_ADD_RESOURCE_FOOD', 'Amount',    '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES

('RESOURCES_FOR_GRANARY_UPGRADE', 'REQUIREMENTSET_TEST_ANY');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES

('RESOURCES_FOR_GRANARY_UPGRADE', 'RBU_GR_REQUIRES_FOOD_TAG');

INSERT INTO Requirements (RequirementId, RequirementType) VALUES

('RBU_GR_REQUIRES_FOOD_TAG', 'REQUIREMENT_PLOT_RESOURCE_TAG_MATCHES');

INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES

('RBU_GR_REQUIRES_FOOD_TAG', 'Tag', 'CLASS_FOOD');

-------------------------------------------------------------

-- WATER_MILL

-- +1 Housing, River:

UPDATE Buildings SET Housing = 1, RequiresAdjacentRiver = 1

WHERE BuildingType = 'BUILDING_WATER_MILL_UPGRADE';

-- + 1 Production:

INSERT INTO Building_YieldChanges (BuildingType, YieldType, YieldChange) VALUES

('BUILDING_WATER_MILL_UPGRADE', 'YIELD_PRODUCTION', 1);

-- +1 Production from RESOURCE_DEER / RESOURCE_IVORY / RESOURCE_MARBLE / RESOURCE_SALT / RESOURCE_WHALES / RESOURCE_COTTON / RESOURCE_FURS /RESOURCE_SHEEP:

INSERT INTO BuildingModifiers (BuildingType, ModifierId) VALUES

('BUILDING_WATER_MILL_UPGRADE', 'WATER_MILL_UPGRADE_ADD_RESOURCE_PRODUCTION');

INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId) VALUES

('WATER_MILL_UPGRADE_ADD_RESOURCE_PRODUCTION', 'MODIFIER_CITY_PLOT_YIELDS_ADJUST_PLOT_YIELD', 0, 0, NULL, 'RESOURCES_FOR_WATER_MILL_UPGRADE');

INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES

('WATER_MILL_UPGRADE_ADD_RESOURCE_PRODUCTION', 'YieldType', 'YIELD_PRODUCTION'),

('WATER_MILL_UPGRADE_ADD_RESOURCE_PRODUCTION', 'Amount',    '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES

('RESOURCES_FOR_WATER_MILL_UPGRADE', 'REQUIREMENTSET_TEST_ANY');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES

('RESOURCES_FOR_WATER_MILL_UPGRADE', 'RBU_WM_REQUIRES_PRODUCTION_TAG');

INSERT INTO Requirements (RequirementId, RequirementType) VALUES

('RBU_WM_REQUIRES_PRODUCTION_TAG', 'REQUIREMENT_PLOT_RESOURCE_TAG_MATCHES');

INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES

('RBU_WM_REQUIRES_PRODUCTION_TAG', 'Tag', 'CLASS_PRODUCTION');

-------------------------------------------------------------