[2891108.244] [Turn: 73] Created Requirement <58219:REQUIRES_ERA_ATLEASTEXPANSION_ATOMIC> with Context <Game> and Subject <PlotYields>.
[2891108.244] [Turn: 73] Created Requirement <58220:REQUIRES_PLOT_HAS_EYE_SAHARA> with Context <Game> and Subject <PlotYields>.
[2891108.244] [Turn: 73] Created Requirement Set <58221:GAME_HAS_ATOMIC_EYE_REQUIREMENTS> with Context <Game> and Subject <PlotYields>.
[2891108.244] [Turn: 73] Created Requirement <58222:REQUIRES_ERA_ATLEASTEXPANSION_ATOMIC> with Context <Game> and Subject <PlotYields>.
[2891108.244] [Turn: 73] Created Requirement <58223:REQUIRES_PLOT_HAS_EYE_SAHARA> with Context <Game> and Subject <PlotYields>.
[2891108.244] [Turn: 73] Created Requirement Set <58224:GAME_HAS_ATOMIC_EYE_REQUIREMENTS> with Context <Game> and Subject <PlotYields>.[2898980.803] [Turn: 85] Removing effect of <1003:AGENDA_HIGH_HAPPINESS> from <Player: 4>.
[2898980.804] [Turn: 85] Created Requirement <86914:REQUIRES_ERA_ATLEASTEXPANSION_ATOMIC> with Context <Game> and Subject <PlotYields>.
[2898980.804] [Turn: 85] Created Requirement <86915:REQUIRES_PLOT_HAS_EYE_SAHARA> with Context <Game> and Subject <PlotYields>.
[2898980.804] [Turn: 85] Created Requirement Set <86916:GAME_HAS_ATOMIC_EYE_REQUIREMENTS> with Context <Game> and Subject <PlotYields>.
[2898980.804] [Turn: 85] Created Requirement <86917:REQUIRES_ERA_ATLEASTEXPANSION_ATOMIC> with Context <Game> and Subject <PlotYields>.
[2898980.804] [Turn: 85] Created Requirement <86918:REQUIRES_PLOT_HAS_EYE_SAHARA> with Context <Game> and Subject <PlotYields>.
[2898980.804] [Turn: 85] Created Requirement Set <86919:GAME_HAS_ATOMIC_EYE_REQUIREMENTS> with Context <Game> and Subject <PlotYields>.
[2952735.653] [Localization]: StartupErrorMessages.xml
[2952735.653] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2952755.410] [Localization]: Validating Foreign Key Constraints...
[2952755.411] [Localization]: Passed Validation.
[2952755.453] [Configuration]: Validating Foreign Key Constraints...
[2952755.454] [Configuration]: Passed Validation.
[2952780.216] [FullTextSearch]: Initializing FullTextSearch
[2952784.497] [Gameplay]: Validating Foreign Key Constraints...
[2952784.513] [Gameplay]: Passed Validation.
[2952788.958] [Configuration]: Validating Foreign Key Constraints...
[2952788.959] [Configuration]: Passed Validation.
[2952794.069] [HallofFame]: Database found. Checking versions...
[2952794.102] [HallofFame]: Database is up-to-date!
[2952818.765] [FullTextSearch]: FTS - Creating Context
[2952924.283] [Configuration]: Validating Foreign Key Constraints...
[2952924.284] [Configuration]: Passed Validation.
[2952932.593] [Gameplay] ERROR: UNIQUE constraint failed: BarbarianAttackForces.AttackForceType
[2952932.593] [Gameplay]: While executing - 'insert into BarbarianAttackForces('AttackForceType', 'MaxTargetDifficulty', 'SpawnRate', 'MeleeTag', 'NumMeleeUnits', 'RaidingForce') values (?, ?, ?, ?, ?, ?);'
[2952932.593] [Gameplay]: In XMLSerializer while inserting row into table insert into BarbarianAttackForces('AttackForceType', 'MaxTargetDifficulty', 'SpawnRate', 'MeleeTag', 'NumMeleeUnits', 'RaidingForce') with values (LowDifficultyStandardRaid, DIFFICULTY_CHIEFTAIN, 2, CLASS_INFANTRY, 1, 1, ).
[2952932.593] [Gameplay]: In XMLSerializer while updating table BarbarianAttackForces from file ZaabSpicey_BarbariansUpdated.xml.
[2952932.593] [Gameplay] ERROR: UNIQUE constraint failed: BarbarianAttackForces.AttackForceType
[2952932.633] [Gameplay] ERROR: Database::XMLSerializer (ZaabSpicey_TechnologyGameplay.xml): Duplicate column names detected in <Row>. Name: Row, Value:
[2952932.633] [Gameplay]: In XMLSerializer while updating table Boosts from file ZaabSpicey_TechnologyGameplay.xml.
[2952933.229] [Gameplay] ERROR: Database::XMLSerializer (ZaabSpicey_UnitGameplay.xml): 'Row' or 'Delete' expected, got 'Upgrade'.
[2952933.229] [Gameplay]: In XMLSerializer while updating table UnitUpgrades from file ZaabSpicey_UnitGameplay.xml.
[2952933.250] [Gameplay] ERROR: UNIQUE constraint failed: UnitPromotions.UnitPromotionType
[2952933.250] [Gameplay]: While executing - 'insert into UnitPromotions('UnitPromotionType', 'Name', 'Description', 'Level', 'Column', 'Specialization', 'PromotionClass') values (?, ?, ?, ?, ?, ?, ?);'
[2952933.250] [Gameplay]: In XMLSerializer while inserting row into table insert into UnitPromotions('UnitPromotionType', 'Name', 'Description', 'Level', 'Column', 'Specialization', 'PromotionClass') with values (PROMOTION_COMMANDO, LOC_PROMOTION_COMMANDO_NAME, LOC_PROMOTION_COMMANDO_DESCRIPTION, 2, 1, , PROMOTION_CLASS_INFANTRY, ).
[2952933.250] [Gameplay]: In XMLSerializer while updating table UnitPromotions from file ZaabSpicey_UnitPromotions.xml.
[2952933.250] [Gameplay] ERROR: UNIQUE constraint failed: UnitPromotions.UnitPromotionType
[2952933.337] [Localization] ERROR: NOT NULL constraint failed: LocalizedText.Language
[2952933.337] [Localization]: While executing - 'insert into LocalizedText('Tag', 'Text') values (?, ?);'
[2952933.337] [Localization]: In XMLSerializer while inserting row into table insert into LocalizedText('Tag', 'Text') with values (LOC_UNIT_INFANTRY_DESCRIPTION, Modern era infantry unit., ).
[2952933.337] [Localization]: In XMLSerializer while updating table LocalizedText from file ZaabSpicey_UnitText.xml.
[2952933.337] [Localization] ERROR: NOT NULL constraint failed: LocalizedText.Language
[2952935.324] [Gameplay]: Validating Foreign Key Constraints...
[2952935.344] [Gameplay]: Passed Validation.
[2952958.041] [FullTextSearch]: FTS - Creating Context
[2952958.042] [FullTextSearch]: FTS - Creating Context
[2952959.761] [FullTextSearch]: FTS - Creating Context
[2952960.788] [FullTextSearch]: FTS - Creating Context
[2952964.204] [FullTextSearch]: FTS - Creating Context <BarbarianAttackForces>
<Row AttackForceType="LowDifficultyStandardRaid" MaxTargetDifficulty="DIFFICULTY_CHIEFTAIN" SpawnRate="2" MeleeTag="CLASS_MELEE" NumMeleeUnits="1" RaidingForce="true"/>
........This means this "LowDifficultyStandardRaid" can't be updated to include CLASS_INFANTRY without losing CLASS_MELEE then?
When using SQL this becomes quite easy
DELETE FROM Buildings WHERE BuildingType NOT IN ("BUILDING_LIBRARY", "BUILDING_TEMPLE", "BUILDING_BANK");
<?xml version="1.0" encoding="UTF-8" ?>
<AssetObjects..AssetInstance>
<m_BehaviorData>
<m_behaviorDataSets>
<m_animationBindings>
<m_Bindings>
<Element>
<m_SlotName text="ATTACK_P"/>
<m_AnimationName text="u_portugal_carrack_attackb"/>
</Element>
<Element>
<m_SlotName text="ATTACK_S"/>
<m_AnimationName text="u_portugal_carrack_attacka"/>
</Element>
<Element>
<m_SlotName text="DEATH_1"/>
<m_AnimationName text="u_portugal_carrack_deatha"/>
</Element>
<Element>
<m_SlotName text="DEATH_2"/>
<m_AnimationName text="u_portugal_carrack_deatha_idle"/>
</Element>
<Element>
<m_SlotName text="HERO_LEFT"/>
<m_AnimationName text="u_portugal_carrack_attackb"/>
</Element>
<Element>
<m_SlotName text="HERO_RIGHT"/>
<m_AnimationName text="u_portugal_carrack_attacka"/>
</Element>
<Element>
<m_SlotName text="IDLE_A"/>
<m_AnimationName text="u_portugal_carrack_idlea"/>
</Element>
<Element>
<m_SlotName text="IDLE_COMBAT_A"/>
<m_AnimationName text="u_portugal_carrack_idlea"/>
</Element>
<Element>
<m_SlotName text="REACT_RANGED"/>
<m_AnimationName text="u_portugal_carrack_bombard_defense"/>
</Element>
<Element>
<m_SlotName text="RUN_STOP"/>
<m_AnimationName text="u_portugal_carrack_stop_run"/>
</Element>
<Element>
<m_SlotName text="RUN_COMBAT"/>
<m_AnimationName text="u_portugal_carrack_run"/>
</Element>
<Element>
<m_SlotName text="RUN_COMBAT_STOP"/>
<m_AnimationName text="u_portugal_carrack_stop_run"/>
</Element>
<Element>
<m_SlotName text="RUN_A"/>
<m_AnimationName text="u_portugal_carrack_run"/>
</Element>
<Element>
<m_SlotName text="VICTORY"/>
<m_AnimationName text="u_portugal_carrack_victory"/>
</Element>
<Element>
<m_SlotName text="SPAWN"/>
<m_AnimationName text="u_portugal_carrack_combat_ready_idle"/>
</Element>
<Element>
<m_SlotName text="REACT_A"/>
<m_AnimationName text="u_portugal_carrack_bombard_defense_idle"/>
</Element>
<Element>
<m_SlotName text="DEFEND_P"/>
<m_AnimationName text="u_portugal_carrack_attackb"/>
</Element>
<Element>
<m_SlotName text="DEFEND_S"/>
<m_AnimationName text="u_portugal_carrack_attacka"/>
</Element>
</m_Bindings>
</m_animationBindings>
<m_timelineBindings>
[ATTACH=full]566003[/ATTACH]
<m_Bindings/>
</m_timelineBindings>
<m_timelines>
<Element>
<m_Name text="ATTACK_P"/>
<m_Description text=""/>
<m_AnimationName text="u_portugal_carrack_attackb"/>
<m_fDuration>0.000000</m_fDuration>
<m_Triggers>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="1"/>
<m_Description text=""/>
<m_FXName text="Frigate_Cannon_Volley"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.415182</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="2"/>
<m_Description text=""/>
<m_FXName text="Frigate_Cannon_Volley"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.455419</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="3"/>
<m_Description text=""/>
<m_FXName text="Frigate_Cannon_Volley_Final_Shot"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.527729</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="7"/>
<m_Description text=""/>
<m_FXName text="ShipWoodCreak"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>1.086957</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="10"/>
<m_Description text=""/>
<m_FXName text="ShipRunSplash"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.595391</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="47"/>
<m_Description text=""/>
<m_FXName text="FX_CannonBronze"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_PCannon_B"/>
<m_fStartTime>0.415179</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="46"/>
<m_Description text=""/>
<m_FXName text="FX_CannonBronze"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_PCannon_A"/>
<m_fStartTime>0.472525</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>1</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="84"/>
<m_Description text=""/>
<m_FXName text="FX_Cannonball_Trail"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_PCannon_B"/>
<m_fStartTime>0.415179</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>2</m_nTrackIndex>
</Element>
<Element>
<m_eType>TRANSFER</m_eType>
<m_Name text="85"/>
<m_Description text=""/>
<m_FXName text="84"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.420768</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="89"/>
<m_Description text=""/>
<m_FXName text="FX_Cannonball_Trail"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_PCannon_A"/>
<m_fStartTime>0.472525</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>2</m_nTrackIndex>
</Element>
<Element>
<m_eType>TRANSFER</m_eType>
<m_Name text="92"/>
<m_Description text=""/>
<m_FXName text="89"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.477493</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>TRANSFER</m_eType>
<m_Name text="101"/>
<m_Description text=""/>
<m_FXName text="100"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.461543</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
</m_Triggers>
</Element>
<Element>
<m_Name text="ATTACK_S"/>
<m_Description text=""/>
<m_AnimationName text="u_portugal_carrack_attacka"/>
<m_fDuration>0.000000</m_fDuration>
<m_Triggers>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="4"/>
<m_Description text=""/>
<m_FXName text="Frigate_Cannon_Volley"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.416484</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="5"/>
<m_Description text=""/>
<m_FXName text="Frigate_Cannon_Volley"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.464592</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="6"/>
<m_Description text=""/>
<m_FXName text="Frigate_Cannon_Volley_Final_Shot"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.527337</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="8"/>
<m_Description text=""/>
<m_FXName text="ShipWoodCreak"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>1.086957</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>SOUND</m_eType>
<m_Name text="9"/>
<m_Description text=""/>
<m_FXName text="ShipRunSplash"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.595334</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="53"/>
<m_Description text=""/>
<m_FXName text="FX_CannonBronze"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_SCannon_B"/>
<m_fStartTime>0.416481</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="55"/>
<m_Description text=""/>
<m_FXName text="FX_CannonBronze"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_SCannon_A"/>
<m_fStartTime>0.473363</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>1</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="86"/>
<m_Description text=""/>
<m_FXName text="FX_Cannonball_Trail"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_SCannon_B"/>
<m_fStartTime>0.416481</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>2</m_nTrackIndex>
</Element>
<Element>
<m_eType>TRANSFER</m_eType>
<m_Name text="87"/>
<m_Description text=""/>
<m_FXName text="86"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.419634</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>TRANSFER</m_eType>
<m_Name text="96"/>
<m_Description text=""/>
<m_FXName text="97"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.483426</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
<Element>
<m_eType>ASSET_FX</m_eType>
<m_Name text="97"/>
<m_Description text=""/>
<m_FXName text="FX_Cannonball_Trail"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text="AP_SCannon_A"/>
<m_fStartTime>0.473363</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>2</m_nTrackIndex>
</Element>
<Element>
<m_eType>TRANSFER</m_eType>
<m_Name text="109"/>
<m_Description text=""/>
<m_FXName text="108"/>
<m_CollectionName text=""/>
<m_AttachmentPointName text=""/>
<m_fStartTime>0.462129</m_fStartTime>
<m_fDuration>0.000000</m_fDuration>
<m_nTrackIndex>0</m_nTrackIndex>
</Element>
</m_Triggers>
</Element>
</m_timelines>
<m_attachmentPoints>
<m_Points>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_position>
<m_orientation>
<x>-1.570796</x>
<y>3.141593</y>
<z>3.141593</z>
</m_orientation>
<m_Name text="AP_SCannon_A"/>
<m_BoneName text="point_PROJECTILE_03"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_position>
<m_orientation>
<x>-1.570796</x>
<y>3.141593</y>
<z>3.141593</z>
</m_orientation>
<m_Name text="AP_SCannon_B"/>
<m_BoneName text="point_PROJECTILE_04"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>-5.000000</y>
<z>4.500000</z>
</m_position>
<m_orientation>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_orientation>
<m_Name text="FX_Hitloc_01"/>
<m_BoneName text="Bone_Root"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>0.000000</y>
<z>4.500000</z>
</m_position>
<m_orientation>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_orientation>
<m_Name text="FX_Hitloc_02"/>
<m_BoneName text="Bone_Root"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>5.000000</y>
<z>5.500000</z>
</m_position>
<m_orientation>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_orientation>
<m_Name text="FX_Hitloc_03"/>
<m_BoneName text="Bone_Root"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_position>
<m_orientation>
<x>-1.570796</x>
<y>3.141593</y>
<z>0.000000</z>
</m_orientation>
<m_Name text="AP_PCannon_A"/>
<m_BoneName text="point_PROJECTILE_07"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
<Element>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_position>
<x>0.000000</x>
<y>0.000000</y>
<z>0.000000</z>
</m_position>
<m_orientation>
<x>-1.570796</x>
<y>3.141593</y>
<z>0.000000</z>
</m_orientation>
<m_Name text="AP_PCannon_B"/>
<m_BoneName text="point_PROJECTILE_08"/>
<m_ModelInstanceName text="World_Center"/>
<m_scale>1.000000</m_scale>
</Element>
</m_Points>
</m_attachmentPoints>
<m_stateSet/>
</m_behaviorDataSets>
<m_behaviorInstances/>
<m_dsgName text="Standard_Naval"/>
<m_referenceGeometryNames/>
</m_BehaviorData>
<m_GeometrySet>
<m_ModelInstances>
<Element>
<m_Name text="World_Center"/>
<m_GeoName text="u_portugal_carrack"/>
<m_GroupStates>
<Element>
<m_Values>
<m_Values>
<Element class="AssetObjects..ObjectValue">
<m_ObjectName text="U_Portugal_Carrack_DIFF"/>
<m_eObjectType>MATERIAL</m_eObjectType>
<m_ParamName text="Material"/>
</Element>
</m_Values>
</m_Values>
<m_GroupName text="U_Portugal_Carrack_DIFF.dds"/>
<m_MeshName text="Portuguese_Carrack"/>
<m_StateName text="Default"/>
</Element>
<Element>
<m_Values>
<m_Values>
<Element class="AssetObjects..ObjectValue">
<m_ObjectName text="U_Portugal_Carrack_DAMG_DIFF"/>
<m_eObjectType>MATERIAL</m_eObjectType>
<m_ParamName text="Material"/>
</Element>
</m_Values>
</m_Values>
<m_GroupName text="U_Portugal_Carrack_DAMG_DIFF.dds"/>
<m_MeshName text="Portuguese_Carrack_DAM"/>
<m_StateName text="Default"/>
</Element>
</m_GroupStates>
</Element>
</m_ModelInstances>
</m_GeometrySet>
<m_SplineSet>
<m_Splines/>
</m_SplineSet>
<m_CookParams>
<m_Values/>
</m_CookParams>
<m_Version>
<major>1</major>
<minor>0</minor>
<build>0</build>
<revision>0</revision>
</m_Version>
<m_ParticleEffects/>
<m_Geometries/>
<m_Animations/>
<m_Materials/>
<m_ClassName text="Unit"/>
<m_DataFiles/>
<m_Name text="Carrack"/>
<m_Description text=""/>
<m_Tags/>
</AssetObjects..AssetInstance>See this thread https://forums.civfanatics.com/threads/tutorial-modding-with-sqllite-studio-pc.608352/
<?xml version="1.0" encoding="utf-8"?>
<Mod id="d9d0aaf9-5d01-4873-94a3-1253f34b61fb" version="1">
<Properties>
<Name>More Nukes</Name>
<Description>Decreases the production, uranium, and gold maintenance costs of nuclear weapons by 50%. Increases range of thermonuclear ICBMs to unlimited.</Description>
<Created>1597725307</Created>
<Teaser>Half cost for nuclear weapons.</Teaser>
<Authors>Alex Lamoureux</Authors>
<CompatibleVersions>1.2,2.0</CompatibleVersions>
</Properties>
<Dependencies>
<Mod id="4873eb62-8ccc-4574-b784-dda455e74e68" title="Expansion: Gathering Storm" />
</Dependencies>
<InGameActions>
<UpdateDatabase id="WMDs">
<Properties>
<LoadOrder>300</LoadOrder>
</Properties>
<File>ModifyWMDs.sql</File>
</UpdateDatabase>
<UpdateDatabase id="Projects">
<Properties>
<LoadOrder>300</LoadOrder>
</Properties>
<File>ModifyProjects.sql</File>
</UpdateDatabase>
<UpdateDatabase id="Expansion2_Projects">
<Properties>
<LoadOrder>300</LoadOrder>
</Properties>
<File>ModifyExpansion2_Projects.sql</File>
</UpdateDatabase>
</InGameActions>
<Files>
<File>ModifyExpansion2_Projects.sql</File>
<File>ModifyProjects.sql</File>
<File>ModifyWMDs.sql</File>
<File>MoreNukes.xml</File>
</Files>
</Mod>UPDATE WMDs SET Maintenance=7 WHERE WeaponType='WMD_NUCLEAR_DEVICE';
UPDATE WMDs SET Maintenance=8, ICBMStrikeRange=100 WHERE WeaponType='WMD_THERMONUCLEAR_DEVICE'UPDATE Projects SET Cost=400 WHERE ProjectType='PROJECT_BUILD_NUCLEAR_DEVICE';
UPDATE Projects SET Cost=500 WHERE ProjectType='PROJECT_BUILD_THERMONUCLEAR_DEVICE'UPDATE Expansion2_Projects SET StartProductionCost=5 WHERE ProjectType='PROJECT_BUILD_NUCLEAR_DEVICE';
UPDATE Expansion2_Projects SET StartProductionCost=10 WHERE ProjectType='PROJECT_BUILD_THERMONUCLEAR_DEVICE'[67653.464] [Gameplay] ERROR: no such table: Expansion2_ProjectsCREATE TABLE "Projects_XP2" (
"ProjectType" TEXT NOT NULL,
"RequiredPowerWhileActive" INTEGER NOT NULL DEFAULT 0,
"ReligiousPressureModifier" INTEGER NOT NULL DEFAULT 0,
"UnlocksFromEffect" BOOLEAN NOT NULL CHECK (UnlocksFromEffect IN (0,1)) DEFAULT 0,
"RequiredBuilding" TEXT,
"CreateBuilding" TEXT,
"FullyPoweredWhileActive" BOOLEAN CHECK (FullyPoweredWhileActive IN (0,1)),
"MaxSimultaneousInstances" INTEGER,
PRIMARY KEY(ProjectType),
FOREIGN KEY (ProjectType) REFERENCES Projects(ProjectType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (RequiredBuilding) REFERENCES Buildings(BuildingType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (CreateBuilding) REFERENCES Buildings(BuildingType) ON DELETE CASCADE ON UPDATE CASCADE);UPDATE WMDs SET Maintenance=7 WHERE WeaponType='WMD_NUCLEAR_DEVICE';
UPDATE WMDs SET Maintenance=8, ICBMStrikeRange=100 WHERE WeaponType='WMD_THERMONUCLEAR_DEVICE';
UPDATE Projects SET Cost=400 WHERE ProjectType='PROJECT_BUILD_NUCLEAR_DEVICE';
UPDATE Projects SET Cost=500 WHERE ProjectType='PROJECT_BUILD_THERMONUCLEAR_DEVICE';UPDATE Project_ResourceCosts SET StartProductionCost=5 WHERE ProjectType='PROJECT_BUILD_NUCLEAR_DEVICE';
UPDATE Project_ResourceCosts SET StartProductionCost=10 WHERE ProjectType='PROJECT_BUILD_THERMONUCLEAR_DEVICE';
