INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType) SELECT 'NO_CAP_HAPPINESS_' || ResourceType, 'MODIFIER_PLAYER_ADJUST_NO_CAP_RESOURCE'
FROM Resources WHERE ResourceClassType IN ('RESOURCECLASS_BONUS', 'RESOURCECLASS_LUXURY');
INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value) SELECT 'NO_CAP_HAPPINESS_' || ResourceType, 'ResourceType', ResourceType
FROM Resources WHERE ResourceClassType IN ('RESOURCECLASS_BONUS', 'RESOURCECLASS_LUXURY');
INSERT OR REPLACE INTO GameModifiers (ModifierId) SELECT 'NO_CAP_HAPPINESS_' || ResourceType
FROM Resources WHERE ResourceClassType IN ('RESOURCECLASS_BONUS', 'RESOURCECLASS_LUXURY');
-- works for bonus resource too
-- UPDATE Resources SET Happiness = 1 WHERE ResourceClassType = 'RESOURCECLASS_BONUS';