thecrazyscot
Spiffy
- Joined
- Dec 27, 2012
- Messages
- 2,460
I'm attempting to follow Pazyryk's directions (here and here) in starting to set up a total conversion mod which stays purely in the ancient and classical eras.
***Most recent unsolved errors are in this post***
In my tests I started with this code:
And then moved to add back in what I wanted to add with XML files for primary tables and SQL files for secondary tables (just much easier for me to keep track of that way).
Civilizations Primary:
Civilizations Secondary:
I used this method for Buildings, Civilizations, Leaders, Traits, and Units (all primary and secondary tables).
I also loaded this code immediately after the Overrides code to try and head off errors in my tests:
However, when I load up the mod the Game Setup screen does not show any civilizations, and crashes upon attempting to start a game.
(Continued in next post)
***Most recent unsolved errors are in this post***
In my tests I started with this code:
Spoiler :
Code:
--Civilization Overrides
DELETE FROM Civilizations;
DELETE FROM Civilization_BuildingClassOverrides;
DELETE FROM Civilization_CityNames;
DELETE FROM Civilization_DisableTechs;
DELETE FROM Civilization_FreeBuildingClasses;
DELETE FROM Civilization_FreeTechs;
DELETE FROM Civilization_FreeUnits;
DELETE FROM Civilization_Leaders;
DELETE FROM Civilization_Religions;
DELETE FROM Civilization_SpyNames;
DELETE FROM Civilization_UnitClassOverrides;
DELETE FROM Civilization_Start_Along_Ocean;
DELETE FROM Civilization_Start_Along_River;
DELETE FROM Civilization_Start_Region_Priority;
DELETE FROM Civilization_Start_Region_Avoid;
DELETE FROM Civilization_Start_Place_First_Along_Ocean;
DELETE FROM Traits;
DELETE FROM Trait_ExtraYieldThresholds;
DELETE FROM Trait_YieldChanges;
DELETE FROM Trait_YieldChangesStrategicResources;
DELETE FROM Trait_YieldChangesNaturalWonder;
DELETE FROM Trait_YieldChangesPerTradePartner;
DELETE FROM Trait_YieldChangesIncomingTradeRoute;
DELETE FROM Trait_YieldModifiers;
DELETE FROM Trait_FreePromotions;
DELETE FROM Trait_FreePromotionUnitCombats;
DELETE FROM Trait_MovesChangeUnitCombats;
DELETE FROM Trait_MaintenanceModifierUnitCombats;
DELETE FROM Trait_Terrains;
DELETE FROM Trait_ResourceQuantityModifiers;
DELETE FROM Trait_FreeResourceFirstXCities;
DELETE FROM Trait_ImprovementYieldChanges;
DELETE FROM Trait_SpecialistYieldChanges;
DELETE FROM Trait_UnimprovedFeatureYieldChanges;
DELETE FROM Trait_NoTrain;
DELETE FROM Leaders;
DELETE FROM Leader_MajorCivApproachBiases;
DELETE FROM Leader_MinorCivApproachBiases;
DELETE FROM Leader_Flavors;
DELETE FROM Leader_Traits;
--Building Overrides
DELETE FROM BuildingClasses;
DELETE FROM BuildingClass_VictoryThresholds;
DELETE FROM Buildings;
DELETE FROM Building_AreaYieldModifiers;
DELETE FROM Building_BuildingClassHappiness;
DELETE FROM Building_BuildingClassYieldChanges;
DELETE FROM Building_ClassesNeededInCity;
DELETE FROM Building_FreeUnits;
DELETE FROM Building_DomainFreeExperiences;
DELETE FROM Building_DomainFreeExperiencePerGreatWork;
DELETE FROM Building_DomainProductionModifiers;
DELETE FROM Building_FreeSpecialistCounts;
DELETE FROM Building_Flavors;
DELETE FROM Building_GlobalYieldModifiers;
DELETE FROM Building_HurryModifiers;
DELETE FROM Building_LocalResourceAnds;
DELETE FROM Building_LocalResourceOrs;
DELETE FROM Building_LockedBuildingClasses;
DELETE FROM Building_PrereqBuildingClasses;
DELETE FROM Building_ResourceQuantity;
DELETE FROM Building_ResourceQuantityRequirements;
DELETE FROM Building_ResourceYieldModifiers;
DELETE FROM Building_ResourceCultureChanges;
DELETE FROM Building_ResourceFaithChanges;
DELETE FROM Building_RiverPlotYieldChanges;
DELETE FROM Building_SeaPlotYieldChanges;
DELETE FROM Building_LakePlotYieldChanges;
DELETE FROM Building_SeaResourceYieldChanges;
DELETE FROM Building_ResourceYieldChanges;
DELETE FROM Building_FeatureYieldChanges;
DELETE FROM Building_TerrainYieldChanges;
DELETE FROM Building_SpecialistYieldChanges;
DELETE FROM Building_UnitCombatFreeExperiences;
DELETE FROM Building_UnitCombatProductionModifiers;
DELETE FROM Building_TechAndPrereqs;
DELETE FROM Building_YieldChanges;
DELETE FROM Building_YieldChangesPerPop;
DELETE FROM Building_YieldChangesPerReligion;
DELETE FROM Building_TechEnhancedYieldChanges;
DELETE FROM Building_YieldModifiers;
DELETE FROM Building_ThemingBonuses;
DELETE FROM Processes;
DELETE FROM Process_Flavors;
DELETE FROM Process_ProductionYields;
--Unit Overrides
DELETE FROM Units;
DELETE FROM UnitClasses;
DELETE FROM Unit_AITypes;
DELETE FROM Unit_Buildings;
DELETE FROM Unit_BuildingClassRequireds;
DELETE FROM Unit_ProductionModifierBuildings;
DELETE FROM Unit_Builds;
DELETE FROM Unit_ClassUpgrades;
DELETE FROM Unit_FreePromotions;
DELETE FROM Unit_Flavors;
DELETE FROM Unit_GreatPersons;
DELETE FROM Unit_ResourceQuantityRequirements;
--DELETE FROM Unit_UniqueNames;
DELETE FROM Unit_YieldFromKills;
--Resequence Primary Tables
UPDATE sqlite_sequence
SET seq = 0 WHERE name = 'Civilizations';
UPDATE sqlite_sequence
SET seq = 0 WHERE name = 'Traits';
UPDATE sqlite_sequence
SET seq = 0 WHERE name = 'Leaders';
UPDATE sqlite_sequence
SET seq = 0 WHERE name = 'Units';
UPDATE sqlite_sequence
SET seq = 0 WHERE name = 'Buildings';
UPDATE sqlite_sequence
SET seq = 0 WHERE name = 'Processes';
Civilizations Primary:
Spoiler :
Code:
<GameData>
<!--Civilization/Trait Primary Tables-->
<Civilizations>
<!--Major Civilizations-->
<Row>
<ID>0</ID>
<Type>CIVILIZATION_ASSYRIA</Type>
<Description>TXT_KEY_CIV_ASSYRIA_DESC</Description>
<ShortDescription>TXT_KEY_CIV_ASSYRIA_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_ASSYRIA_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_ASSYRIA</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_ASSYRIA</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_ASSYRIA</ArtDefineTag>
<ArtStyleType>ARTSTYLE_MIDDLE_EAST</ArtStyleType>
<ArtStyleSuffix>_MED</ArtStyleSuffix>
<ArtStylePrefix>MEDITERRANEAN</ArtStylePrefix>
<PortraitIndex>0</PortraitIndex>
<IconAtlas>EXPANSION2_CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>EXPANSION2_CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapAssyria360x410.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_ASSYRIA_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Ashurbanipal.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_ASSYRIA</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_BABYLON</Type>
<Description>TXT_KEY_CIV_BABYLON_DESC</Description>
<ShortDescription>TXT_KEY_CIV_BABYLON_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_BABYLON_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_BABYLON</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_BABYLON</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_BABYLON</ArtDefineTag>
<ArtStyleType>ARTSTYLE_MIDDLE_EAST</ArtStyleType>
<PortraitIndex>0</PortraitIndex>
<IconAtlas>NEB_CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>NEB_CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapBabylon512.dds</MapImage>
<ArtStyleSuffix>_MED</ArtStyleSuffix>
<ArtStylePrefix>MEDITERRANEAN </ArtStylePrefix>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_BABYLON_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Nebuchadnezzar.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_BABYLON</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_CARTHAGE</Type>
<Description>TXT_KEY_CIV_CARTHAGE_DESC</Description>
<ShortDescription>TXT_KEY_CIV_CARTHAGE_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_CARTHAGE_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_CARTHAGE</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_CARTHAGE</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_ROME</ArtDefineTag>
<ArtStyleType>ARTSTYLE_GRECO_ROMAN</ArtStyleType>
<ArtStyleSuffix>_MED</ArtStyleSuffix>
<ArtStylePrefix>MEDITERRANEAN </ArtStylePrefix>
<PortraitIndex>2</PortraitIndex>
<IconAtlas>EXPANSION_CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>EXPANSION_CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapCarthage512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_CARTHAGE_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Dido.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_CARTHAGE</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_CELTS</Type>
<Description>TXT_KEY_CIV_CELTS_DESC</Description>
<ShortDescription>TXT_KEY_CIV_CELTS_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_CELTS_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_CELTS</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_CELTS</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_ROME</ArtDefineTag>
<ArtStyleType>ARTSTYLE_EUROPEAN</ArtStyleType>
<ArtStyleSuffix>_EURO</ArtStyleSuffix>
<ArtStylePrefix>EUROPEAN </ArtStylePrefix>
<PortraitIndex>3</PortraitIndex>
<IconAtlas>EXPANSION_CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>EXPANSION_CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapCelts512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_CELTS_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Boudicca.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_CELTS</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_EGYPT</Type>
<Description>TXT_KEY_CIV_EGYPT_DESC</Description>
<ShortDescription>TXT_KEY_CIV_EGYPT_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_EGYPT_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_EGYPT</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_EGYPT</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_EGYPT</ArtDefineTag>
<ArtStyleType>ARTSTYLE_MIDDLE_EAST</ArtStyleType>
<ArtStyleSuffix>_AFRI</ArtStyleSuffix>
<ArtStylePrefix>AFRICAN </ArtStylePrefix>
<PortraitIndex>5</PortraitIndex>
<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapEgypt512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_EGYPT_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Ramesess.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_EGYPT</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_GREECE</Type>
<Description>TXT_KEY_CIV_GREECE_DESC</Description>
<ShortDescription>TXT_KEY_CIV_GREECE_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_GREECE_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_GREECE</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_GREECE</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_GREECE</ArtDefineTag>
<ArtStyleType>ARTSTYLE_GRECO_ROMAN</ArtStyleType>
<ArtStyleSuffix>_MED</ArtStyleSuffix>
<ArtStylePrefix>MEDITERRANEAN </ArtStylePrefix>
<PortraitIndex>9</PortraitIndex>
<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapMacedonia512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_GREECE_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Alex.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_GREECE</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_HUNS</Type>
<Description>TXT_KEY_CIV_HUNS_DESC</Description>
<ShortDescription>TXT_KEY_CIV_HUNS_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_HUNS_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_HUNS</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_HUNS</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_ROME</ArtDefineTag>
<ArtStyleType>ARTSTYLE_ASIAN</ArtStyleType>
<ArtStyleSuffix>_ASIA</ArtStyleSuffix>
<ArtStylePrefix>ASIAN </ArtStylePrefix>
<PortraitIndex>5</PortraitIndex>
<IconAtlas>EXPANSION_CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>EXPANSION_CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapHuns512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_HUNS_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Attila.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_HUNS</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_PERSIA</Type>
<Description>TXT_KEY_CIV_PERSIA_DESC</Description>
<ShortDescription>TXT_KEY_CIV_PERSIA_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_PERSIA_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_PERSIA</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_PERSIA</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_PERSIA</ArtDefineTag>
<ArtStyleType>ARTSTYLE_MIDDLE_EAST</ArtStyleType>
<ArtStyleSuffix>_AFRI</ArtStyleSuffix>
<ArtStylePrefix>AFRICAN </ArtStylePrefix>
<PortraitIndex>16</PortraitIndex>
<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapPersia512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_PERSIA_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Darius.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_PERSIA</DawnOfManAudio>
</Row>
<Row>
<Type>CIVILIZATION_ROME</Type>
<Description>TXT_KEY_CIV_ROME_DESC</Description>
<ShortDescription>TXT_KEY_CIV_ROME_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_ROME_ADJECTIVE</Adjective>
<CivilopediaTag>TXT_KEY_CIV5_ROME</CivilopediaTag>
<DefaultPlayerColor>PLAYERCOLOR_ROME</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_ROME</ArtDefineTag>
<ArtStyleType>ARTSTYLE_GRECO_ROMAN</ArtStyleType>
<ArtStyleSuffix>_MED</ArtStyleSuffix>
<ArtStylePrefix>MEDITERRANEAN </ArtStylePrefix>
<PortraitIndex>17</PortraitIndex>
<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>CIV_ALPHA_ATLAS</AlphaIconAtlas>
<MapImage>MapRome512.dds</MapImage>
<DawnOfManQuote>TXT_KEY_CIV5_DAWN_ROME_TEXT</DawnOfManQuote>
<DawnOfManImage>DOM_Augustus.dds</DawnOfManImage>
<DawnOfManAudio>AS2D_DOM_SPEECH_ROME</DawnOfManAudio>
</Row>
<!--Non-playable Civilizations-->
<Row>
<Type>CIVILIZATION_MINOR</Type>
<Description>TXT_KEY_CIV_MINOR_DESC</Description>
<ShortDescription>TXT_KEY_CIV_MINOR_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_MINOR_ADJECTIVE</Adjective>
<DefaultPlayerColor>PLAYERCOLOR_MINOR_WHITE</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_MINOR</ArtDefineTag>
<ArtStyleType>ARTSTYLE_BARBARIAN</ArtStyleType>
<Playable>false</Playable>
<AIPlayable>false</AIPlayable>
<PortraitIndex>22</PortraitIndex>
<IconAtlas>CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>CIV_ALPHA_ATLAS</AlphaIconAtlas>
</Row>
<Row>
<Type>CIVILIZATION_BARBARIAN</Type>
<Description>TXT_KEY_CIV_BARBARIAN_DESC</Description>
<ShortDescription>TXT_KEY_CIV_BARBARIAN_SHORT_DESC</ShortDescription>
<Adjective>TXT_KEY_CIV_BARBARIAN_ADJECTIVE</Adjective>
<DefaultPlayerColor>PLAYERCOLOR_BARBARIAN</DefaultPlayerColor>
<ArtDefineTag>ART_DEF_CIVILIZATION_BARBARIAN</ArtDefineTag>
<ArtStyleType>ARTSTYLE_BARBARIAN</ArtStyleType>
<Playable>false</Playable>
<AIPlayable>false</AIPlayable>
<PortraitIndex>0</PortraitIndex>
<IconAtlas>SHARED_CIV_COLOR_ATLAS</IconAtlas>
<AlphaIconAtlas>SHARED_CIV_ALPHA_ATLAS</AlphaIconAtlas>
</Row>
</Civilizations>
</GameData>
Spoiler :
Code:
--Civilization Secondary Tables
-------------------------------
--Civilization_BuildingClassOverrides (CivilizationType, BuildingClassType, BuildingType)
INSERT INTO Civilization_BuildingClassOverrides
SELECT 'CIVILIZATION_ASSYRIA', 'BUILDINGCLASS_LIBRARY', 'BUILDING_ROYAL_LIBRARY' UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'BUILDINGCLASS_WALLS', 'BUILDING_WALLS_OF_BABYLON' UNION ALL
SELECT 'CIVILIZATION_CELTS', 'BUILDINGCLASS_AMPHITHEATER', 'BUILDING_CEILIDH_HALL' UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'BUILDINGCLASS_TEMPLE', 'BUILDING_BURIAL_TOMB' UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'BUILDINGCLASS_COURTHOUSE', 'BUILDING_SATRAPS_COURT' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_PALACE', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_HEROIC_EPIC', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_NATIONAL_EPIC', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_NATIONAL_COLLEGE', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_NATIONAL_TREASURY', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_CIRCUS_MAXIMUS', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_PYRAMID', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_GREAT_LIBRARY', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_STONEHENGE', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_HANGING_GARDEN', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_COLOSSUS', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_GREAT_LIGHTHOUSE', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_ORACLE', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_PARTHENON', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_WRITERS_GUILD', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_ARTISTS_GUILD', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDINGCLASS_MUSICIANS_GUILD', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDING_STATUE_ZEUS', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDING_PETRA', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDING_TERRACOTTA_ARMY', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'BUILDING_GRAND_TEMPLE', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDING_GRAND_TEMPLE', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDING_PETRA', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDING_TERRACOTTA_ARMY', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDING_STATUE_ZEUS', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_HEROIC_EPIC', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_NATIONAL_EPIC', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_NATIONAL_COLLEGE', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_NATIONAL_TREASURY', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_CIRCUS_MAXIMUS', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_PYRAMID', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_GREAT_LIBRARY', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_STONEHENGE', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_HANGING_GARDEN', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_COLOSSUS', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_GREAT_LIGHTHOUSE', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_ORACLE', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_PARTHENON', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_WRITERS_GUILD', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_ARTISTS_GUILD', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_MUSICIANS_GUILD', NULL;
--Civilization_FreeBuildingClasses (CivilizationType, BuildingClassType)
INSERT INTO Civilization_FreeBuildingClasses
SELECT 'CIVILIZATION_ASSYRIA', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_CELTS', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_GREECE', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_HUNS', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_ROME', 'BUILDINGCLASS_PALACE' UNION ALL
SELECT 'CIVILIZATION_MINOR', 'BUILDINGCLASS_PALACE';
--Civilization_UnitClassOverrides (CivilizationType, UnitClassType, UnitType)
INSERT INTO Civilization_UnitClassOverrides
SELECT 'CIVILIZATION_ASSYRIA', 'UNITCLASS_CATAPULT', 'UNIT_ASSYRIAN_SIEGE_TOWER' UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'UNITCLASS_ARCHER', 'UNIT_BABYLONIAN_BOWMAN' UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'UNITCLASS_HORSEMAN', 'UNIT_CARTHAGINIAN_FOREST_ELEPHANT' UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'UNITCLASS_TRIREME', 'UNIT_CARTHAGINIAN_QUINQUEREME' UNION ALL
SELECT 'CIVILIZATION_CELTS', 'UNITCLASS_SPEARMAN', 'UNIT_CELT_PICTISH_WARRIOR' UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'UNITCLASS_CHARIOT_ARCHER', 'UNIT_EGYPTIAN_WARCHARIOT' UNION ALL
SELECT 'CIVILIZATION_GREECE', 'UNITCLASS_HORSEMAN', 'UNIT_GREEK_COMPANIONCAVALRY' UNION ALL
SELECT 'CIVILIZATION_GREECE', 'UNITCLASS_SPEARMAN', 'UNIT_GREEK_HOPLITE' UNION ALL
SELECT 'CIVILIZATION_HUNS', 'UNITCLASS_CHARIOT_ARCHER', 'UNIT_HUN_HORSE_ARCHER' UNION ALL
SELECT 'CIVILIZATION_HUNS', 'UNITCLASS_SPEARMAN', 'UNIT_HUN_BATTERING_RAM' UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'UNITCLASS_SPEARMAN', 'UNIT_PERSIAN_IMMORTAL' UNION ALL
SELECT 'CIVILIZATION_ROME', 'UNITCLASS_CATAPULT', 'UNIT_ROMAN_BALLISTA' UNION ALL
SELECT 'CIVILIZATION_ROME', 'UNITCLASS_SWORDSMAN', 'UNIT_ROMAN_LEGION' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_WARRIOR', 'UNIT_BARBARIAN_WARRIOR' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_ARCHER', 'UNIT_BARBARIAN_ARCHER' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_SPEARMAN', 'UNIT_BARBARIAN_SPEARMAN' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_SWORDSMAN', 'UNIT_BARBARIAN_SWORDSMAN' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_HORSEMAN', 'UNIT_BARBARIAN_HORSEMAN' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_SETTLER', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_SCOUT', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_CHARIOT_ARCHER', 'UNIT_BARBARIAN_AXMAN' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_CATAPULT', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_WORKBOAT', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_GALLEY', 'UNIT_GALLEY' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_ARTIST', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_SCIENTIST', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_MERCHANT', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_ENGINEER', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_WRITER', NULL UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'UNITCLASS_MUSICIAN', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'UNITCLASS_SCOUT', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'UNITCLASS_CARGO_SHIP', NULL UNION ALL
SELECT 'CIVILIZATION_MINOR', 'UNITCLASS_CARAVAN', NULL;
--Civilization_FreeUnits (CivilizationType, UnitClassType, UnitAIType, Count)
INSERT INTO Civilization_FreeUnits
SELECT 'CIVILIZATION_ASSYRIA', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_CELTS', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_GREECE', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_HUNS', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_ROME', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1 UNION ALL
SELECT 'CIVILIZATION_MINOR', 'UNITCLASS_SETTLER', 'UNITAI_SETTLE', 1;
--Civilization_DisableTechs (CivilizationType, TechType)
--Civilization_FreeTechs (CivilizationType, TechType)
INSERT INTO Civilization_FreeTechs
SELECT 'CIVILIZATION_ASSYRIA', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_CELTS', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_GREECE', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_HUNS', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_ROME', 'TECH_AGRICULTURE' UNION ALL
SELECT 'CIVILIZATION_MINOR', 'TECH_AGRICULTURE';
--Civilization_Leaders (CivilizationType, LeaderheadType)
INSERT INTO Civilization_Leaders;
SELECT 'CIVILIZATION_ASSYRIA', 'LEADER_ASHURBANIPAL' UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'LEADER_NEBUCHADNEZZAR' UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'LEADER_DIDO' UNION ALL
SELECT 'CIVILIZATION_CELTS', 'LEADER_BOUDICCA' UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'LEADER_RAMESSES' UNION ALL
SELECT 'CIVILIZATION_GREECE', 'LEADER_ALEXANDER' UNION ALL
SELECT 'CIVILIZATION_HUNS', 'LEADER_ATTILA' UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'LEADER_DARIUS' UNION ALL
SELECT 'CIVILIZATION_ROME', 'LEADER_AUGUSTUS' UNION ALL
SELECT 'CIVILIZATION_MINOR', 'LEADER_BARBARIAN' UNION ALL
SELECT 'CIVILIZATION_BARBARIAN', 'LEADER_BARBARIAN';
--Civilization_Religions (CivilizationType, ReligionType)
INSERT INTO Civilization_Religions
SELECT 'CIVILIZATION_ASSYRIA', 'RELIGION_ZOROASTRIANISM' UNION ALL
SELECT 'CIVILIZATION_BABYLON', 'RELIGION_ZOROASTRIANISM' UNION ALL
SELECT 'CIVILIZATION_CARTHAGE', 'RELIGION_ISLAM' UNION ALL
SELECT 'CIVILIZATION_CELTS', 'RELIGION_CHRISTIANITY' UNION ALL
SELECT 'CIVILIZATION_EGYPT', 'RELIGION_ISLAM' UNION ALL
SELECT 'CIVILIZATION_GREECE', 'RELIGION_ORTHODOXY' UNION ALL
SELECT 'CIVILIZATION_HUNS', 'RELIGION_TENGRIISM' UNION ALL
SELECT 'CIVILIZATION_PERSIA', 'RELIGION_ZOROASTRIANISM' UNION ALL
SELECT 'CIVILIZATION_ROME', 'RELIGION_CHRISTIANITY';
...and so on and so forth.
I also loaded this code immediately after the Overrides code to try and head off errors in my tests:
Spoiler :
Code:
<GameData>
<!--<DeleteMissingReferences table="" column=""/>-->
<DeleteMissingReferences table="Policy_BuildingClassYieldModifiers" column="BuildingClassType"/>
<DeleteMissingReferences table="Policy_BuildingClassYieldChanges" column="BuildingClassType"/>
<DeleteMissingReferences table="Policy_BuildingClassProductionModifiers" column="BuildingClassType"/>
<DeleteMissingReferences table="Policy_BuildingClassHappiness" column="BuildingClassType"/>
<DeleteMissingReferences table="Policy_FreeUnitClasses" column="UnitClassType"/>
<DeleteMissingReferences table="Policy_TourismOnUnitCreation" column="UnitClassType"/>
<DeleteMissingReferences table="Belief_BuildingClassYieldChanges" column="BuildingClassType"/>
<DeleteMissingReferences table="Belief_BuildingClassHappiness" column="BuildingClassType"/>
<DeleteMissingReferences table="Belief_BuildingClassTourism" column="BuildingClassType"/>
<DeleteMissingReferences table="Belief_BuildingClassFaithPurchase" column="BuildingClassType"/>
<DeleteMissingReferences table="Improvements" column="CivilizationType"/>
<DeleteMissingReferences table="Resources" column="CivilizationType"/>
</GameData>
(Continued in next post)