-------------------------------------------------------------
-- GRANARY

-- +1 Housing:
UPDATE Buildings SET Housing = 1
WHERE BuildingType = 'BUILDING_GRANARY_UPGRADE';

-- +1 Food from FOOD tagged resources:
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', 'REQUIRES_RESOURCE_TAG_FOOD'),

INSERT INTO Requirements (RequirementId, RequirementType) VALUES
('REQUIRES_RESOURCE_TAG_FOOD', 'REQUIREMENT_PLOT_RESOURCE_TAG_TYPE_MATCHES'),

INSERT INTO RequirementArguments (RequirementId, Value) VALUES
('REQUIRES_RESOURCE_TAG_FOOD', 'CLASS_FOOD'),

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