Trying to create A NERFING GDR mod

[Moulefrite]

Hi,
I am trying to create my first mod. I would like to nerf GDR. I am a bit lost.

Here is what I tried :

In a SQL FILE :
UPDATE Units SET Combat=120, AntiAirCombat=120 WHERE UnitType='UNIT_GIANT_DEATH_ROBOT';

In a modinfo file :

<Mod id="<61a79a1d-cecd-4bbd-a746-aafc30270e35>" version="1">
<Properties>
<Name>NERF GDR</Name>
<Description>NERF GDR</Description>
<CustomProperties></CustomProperties>
<Teaser>NERF GDR </Teaser>
<Authors>BOBOYLE</Authors>
<SpecialThanks> </SpecialThanks>
</Properties>
<FrontEndActions>
<UpdateDatabase id="Expansion2_Units">
<File>Data/NERF GDR.SQL</File>

</InGameActions>
<Files>
<File>Data/NERF GDR.SQL</File>

</Files>
</Mod>


I am not sure about what I am doing, can someone help me to identify what should I do ?

 

[ARIJTOT]

<?xml version="1.0" encoding="utf-8"?> <Mod id="<61a79a1d-cecd-4bbd-a746-aafc30270e35>" version="1"> <Properties> <Name>NERF GDR</Name> <Description>NERF GDR</Description> <CustomProperties></CustomProperties> <Teaser>NERF GDR </Teaser> <Authors>BOBOYLE</Authors> <SpecialThanks> </SpecialThanks> </Properties> <Files> <File>Data/NERF GDR.SQL</File> </Files> <Components> <UpdateDatabase id="nerf_gdr"> <Properties> <LoadOrder>100</LoadOrder> </Properties> <File>Data/NERF GDR.SQL</File> </UpdateDatabase> </Components> </Mod>

Looks like there's nothing wrong with the sql part.
So I just rewrote the modinfo file.
I hope that helps.
Tips: Better use Notepad++ or VSC.

 

[Moulefrite]

Thanks for your help.
I tried with your modinfo part.
Both file are saved here : Documents\My Games\Sid Meier's Civilization VI\Mods
The mod appears in the mod selection and is activated but doesn't affect game.