I cannot say from this vague description "Yields [ICON_FOOD] Food, [ICON_GOLD] Gold and [ICON_PRODUCTION] Production. [...] and [ICON_GOLD] Gold from adjacent Luxury Resources." but I suppose you want the effect for various resource classes.
The easy way:
INSERT INTO Improvement_AdjacentResourceYieldChanges
(ImprovementType, ResourceType, YieldType,Yield)
SELECT 'IMPROVEMENT_SPAIN_HACIENDA', Type, 'YIELD_GOLD', 2
FROM Resources
WHERE ResourceClassType = 'RESOURCECLASS_LUXURY';
I cannot say from this vague description "Yields [ICON_FOOD] Food, [ICON_GOLD] Gold and [ICON_PRODUCTION] Production. [...] and [ICON_GOLD] Gold from adjacent Luxury Resources." but I suppose you want the effect for various resource classes. The easy way:
and others in similar way.