[COLOR="Navy"]CASE WHEN EXISTS(SELECT[/COLOR] Type [COLOR="Navy"]FROM [/COLOR]Improvements [COLOR="Navy"]WHERE [/COLOR]Type=[COLOR="DimGray"]"IMPROVEMENT_TERRACE_FARM"[/COLOR])
[COLOR="navy"]THEN
insert into[/COLOR] Improvement_TechFreshWaterYieldChanges [COLOR="navy"]([/COLOR]ImprovementType, TechType,YieldType, Yield[COLOR="navy"])[/COLOR]
[COLOR="navy"]values([COLOR="DimGray"]'IMPROVEMENT_TERRACE_FARM'[/COLOR], [COLOR="DimGray"]'TECH_CIVIL_SERVICE'[/COLOR], [COLOR="DimGray"]'YIELD_FOOD'[/COLOR], [COLOR="DimGray"]'1'[/COLOR]);
insert into[/COLOR] Improvement_TechNoFreshWaterYieldChanges [COLOR="navy"]([/COLOR]ImprovementType, TechType,YieldType, Yield[COLOR="navy"])
values([COLOR="DimGray"]'IMPROVEMENT_TERRACE_FARM'[/COLOR], [COLOR="DimGray"]'TECH_FERTILIZER'[/COLOR], [COLOR="DimGray"]'YIELD_FOOD'[/COLOR], [COLOR="DimGray"]'1'[/COLOR]);
END[/COLOR]