LeeS
Imperator
Make sure you aren't making the common mistake of assuming file names have any real meaning other than to make it easier to find stuff. There is a file called Projects_Expansion2.xml in the DLC folder for Gathering Storm, but that's just a filename, not a database table name.
To find the definitions of all the Vanilla database tables look first in file
Expansion1 (Rise and Fall) has its data in folder
Expansion2 (Gathering Storm) has its data in folder
To find the definitions of all the Vanilla database tables look first in file
The other files in the same folder also have some table-definitions for oddball stuff. Remember that these are the definitions of the names of the tables and the various columns each table uses, but in the quoted folder there is no data. Data for these tables is added from the contents of the files found (for Vanilla) in folderC:\Program Files (x86)\Steam\steamapps\common\Sid Meier's Civilization VI\Base\Assets\Gameplay\Data\Schema/01_GameplaySchema.sql
C:\Program Files (x86)\Steam\steamapps\common\Sid Meier's Civilization VI\Base\Assets\Gameplay\Data
Expansion1 (Rise and Fall) has its data in folder
and the definitions of new tables added by Rise and Fall is in this same folder in file Expansion1_Schema.sqlC:\Program Files (x86)\Steam\steamapps\common\Sid Meier's Civilization VI\DLC\Expansion1\Data
Expansion2 (Gathering Storm) has its data in folder
and the definitions of new tables added by Rise and Fall is in this same folder in file Expansion2_Schema.sqlC:\Program Files (x86)\Steam\steamapps\common\Sid Meier's Civilization VI\DLC\Expansion2\Data