SQL!?

[Dreamzilla]

Heya,

So I am entirely new to modding. I already found out that I could alter the XML files directly, but that is a bit a nasty way to get things done.

So that is why I want to create a proper mod. (Not a new civ by changing a template file, but a real proper mod from scratch).

Now I am starting simple, and I am trying to swap the unique improvements of China and Australia.

My mod contains of 2 files:

I wrote te following SQL
main.sql

UPDATE Improvements 
    SET TraitType = CASE ImprovementType
        WHEN 'IMPROVEMENT_GREAT_WALL' THEN 'TRAIT_CIVILIZATION_IMPROVEMENT_OUTBACK_STATION'
        WHEN 'IMPROVEMENT_OUTBACK_STATION' THEN 'TRAIT_CIVILIZATION_IMPROVEMENT_GREAT_WALL'
    END
    WHERE ImprovementType IN('IMPROVEMENT_GREAT_WALL', 'IMPROVEMENT_OUTBACK_STATION');

Which should work, according to SQLiteStudio and my DebugGameplay db. But when I load the mod nothing changed, neither do I find any change in the Debug db. Heck, I couldn't even find a trace of the following line of SQL after loading my mod.

INSERT INTO Improvements (ImprovementType) VALUES ('Poopies');

The second file obviously is the modinfo file (I attached the sql as an in-game action)

<?xml version="1.0" encoding="utf-8"?>
<Mod id="32e3360e-61ab-49b8-9923-40981dbdf0b4" version="1">
  <Properties>
    <Name>Unique Improvements Overhaul</Name>
    <Description>Changes the way Unique Improvements are designed.</Description>
    <Teaser>Changes the way Unique Improvements are designed.</Teaser>
    <Authors>Dreamzilla</Authors>
  </Properties>
  <FrontEndActions />
  <InGameActions>
    <UpdateDatabase id="ChangeUniqueImprovements">
      <File priority="1">main.sql</File>
    </UpdateDatabase>
  </InGameActions>
  <Files>
    <File>main.sql</File>
  </Files>
</Mod>

Anyway, I am lost, what am I doing wrong here? It must be something very simple.

 

[Dreamzilla]

Update: I don't know how, I started over, this time without modbuddy but directly in the mod directory and that worked