Adding new columns to a table can't be done in Lua (AFAIK). You should use SQL. Here is how I did it:
Code:
ALTER TABLE Civilizations ADD COLUMN CoA_StartingPantheon TEXT DEFAULT NULL REFERENCES Beliefs (Type);
(I'm not sure if the DEFAULT NULL part is needed here, probably the effect will be the same without it.)
Then when defining a civ using XML or SQL, just define the content of the new column as you do with any other column:
Code:
<Civilizations>
<Row>
<Type>CIVILIZATION_DWARVES</Type>
...
<CoA_StartingPantheon>BELIEF_MOTHER_EARTH</CoA_StartingPantheon>
...
</Row>
</Civilizations>
Alternatively, you can use Update to set it for already defined civs:
Code:
<Civilizations>
<Update>
<Where Type="CIVILIZATION_DWARVES"/>
<Set CoA_StartingPantheon = "BELIEF_MOTHER_EARTH"/>
</Update>
</Civilizations>
(Note: The SQL code that adds the new column must be executed in the Actions tab
before the code that sets the value of that column.)