-- CivTables
-- Author: Voyevoda
-- DateCreated: 2/21/2021 12:03:42 AM
--------------------------------------------------------------

	<!-- Table definition -->
	<Table name="Civilizations">
		<Column name="ID" type="integer" primarykey="true" autoincrement="true"/>
		<Column name="Type" type="text" notnull="true" unique="true"/>
		<Column name="Description" type="text" reference="Language_en_US(Tag)"/>
		<Column name="Civilopedia" type="text" default="NULL"/>
		<!-- NOTE: This column is deprecated (for this table only). -->
		<Column name="CivilopediaTag" type="text"/>
		<Column name="Strategy" type="text" reference="Language_en_US(Tag)"/>
		<Column name="Playable" type="boolean" default="true"/>
		<Column name="AIPlayable" type="boolean" default="true"/>
		<Column name="ShortDescription" type="text" default="NULL" reference="Language_en_US(Tag)"/>
		<Column name="Adjective" type="text" default="NULL" reference="Language_en_US(Tag)"/>
		<Column name="DefaultPlayerColor" type="text" default="NULL" reference="PlayerColors(Type)"/>
		<Column name="ArtDefineTag" type="text" default="NULL"/>
		<Column name="ArtStyleType" type="text" default="NULL"/>
		<Column name="ArtStyleSuffix" type="text" default="NULL"/>
		<Column name="ArtStylePrefix" type="text" default="NULL"/>
		<Column name="DerivativeCiv" type="text" default="NULL"/>
		<!--NOTE: This column is deprecated (for this table only). -->
		<Column name="PortraitIndex" type="integer" default="-1"/>
		<Column name="IconAtlas" type="text" default="NULL" reference="IconTextureAtlases(Atlas)"/>
		<Column name="AlphaIconAtlas" type="text" default="NULL" reference="IconTextureAtlases(Atlas)"/>
		<Column name="MapImage" type="text" default="NULL"/>
		<Column name="DawnOfManQuote" type="text" default="NULL"/>
		<Column name="DawnOfManImage" type="text" default="NULL"/>
		<Column name="DawnOfManAudio" type="text" default="NULL"/>
		<Column name="PackageID" type="text" default="NULL"/>
		<Column name="SoundtrackTag" type="text" default="NULL"/>
	</Table>
	<Table name="Civilization_BuildingClassOverrides">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="BuildingClassType" type="text" notnull="true" reference="BuildingClasses(Type)"/>
		<Column name="BuildingType" type="text" reference="Buildings(Type)"/>
	</Table>
	<Table name="Civilization_CityNames">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="CityName" type="text" notnull="true" reference="Language_en_US(Tag)"/>
	</Table>
	<Table name="Civilization_DisableTechs">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="TechType" type="text" reference="Technologies(Type)"/>
	</Table>
	<Table name="Civilization_FreeBuildingClasses">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="BuildingClassType" type="text" reference="BuildingClasses(Type)"/>
	</Table>
	<Table name="Civilization_FreeTechs">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="TechType" type="text" reference="Technologies(Type)"/>
	</Table>
	<Table name="Civilization_FreeUnits">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="UnitClassType" type="text" reference="UnitClasses(Type)"/>
		<Column name="UnitAIType" type="text" reference="UnitAIInfos(Type)"/>
		<Column name="Count" type="integer"/>
	</Table>
	<Table name="Civilization_Leaders">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="LeaderheadType" type="text" reference="Leaders(Type)"/>
	</Table>
	<Table name="Civilization_Religions">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="ReligionType" type="text" reference="Religions(Type)"/>
	</Table>
	<Table name="Civilization_SpyNames">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="SpyName" type="text" notnull="true" reference="Language_en_US(Tag)"/>
	</Table>
	<Table name="Civilization_UnitClassOverrides">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="UnitClassType" type="text" notnull="true" reference="UnitClasses(Type)"/>
		<Column name="UnitType" type="text" reference="Units(Type)"/>
	</Table>
	<Table name="Civilization_Start_Along_Ocean">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="StartAlongOcean" type="boolean" default="false"/>
	</Table>
	<Table name="Civilization_Start_Along_River">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="StartAlongRiver" type="boolean" default="false"/>
	</Table>
	<Table name="Civilization_Start_Region_Priority">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="RegionType" type="text" reference="Regions(Type)"/>
	</Table>
	<Table name="Civilization_Start_Region_Avoid">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="RegionType" type="text" reference="Regions(Type)"/>
	</Table>
	<Table name="Civilization_Start_Place_First_Along_Ocean">
		<Column name="CivilizationType" type="text" reference="Civilizations(Type)"/>
		<Column name="PlaceFirst" type="boolean" default="false"/>
	</Table>
	<!-- Table data -->


		<!-- Table definition -->
	<Table name="Traits">
		<Column name="ID" type="integer" primarykey="true" autoincrement="true"/>
		<Column name="Type" type="text" notnull="true" unique="true"/>
		<Column name="Description" type="text" reference="Language_en_US(Tag)"/>
		<Column name="ShortDescription" type="text" reference="Language_en_US(Tag)"/>
		<Column name="LevelExperienceModifier" type="integer" default="0"/>
		<Column name="GreatPeopleRateModifier" type="integer" default="0"/>
		<Column name="GreatScientistRateModifier" type="integer" default="0"/>
		<Column name="GreatGeneralRateModifier" type="integer" default="0"/>
		<Column name="GreatGeneralExtraBonus" type="integer" default="0"/>
		<Column name="GreatPersonGiftInfluence" type="integer" default="0"/>
		<Column name="MaxGlobalBuildingProductionModifier" type="integer" default="0"/>
		<!-- World Wonders -->
		<Column name="MaxTeamBuildingProductionModifier" type="integer" default="0"/>
		<Column name="MaxPlayerBuildingProductionModifier" type="integer" default="0"/>
		<!-- National Wonders -->
		<Column name="CityUnhappinessModifier" type="integer" default="0"/>
		<Column name="PopulationUnhappinessModifier" type="integer" default="0"/>
		<Column name="CityStateBonusModifier" type="integer" default="0"/>
		<Column name="CityStateFriendshipModifier" type="integer" default="0"/>
		<Column name="CityStateCombatModifier" type="integer" default="0"/>
		<Column name="LandBarbarianConversionPercent" type="integer" default="0"/>
		<Column name="LandBarbarianConversionExtraUnits" type="integer" default="0"/>
		<Column name="SeaBarbarianConversionPercent" type="integer" default="0"/>
		<Column name="LandUnitMaintenanceModifier" type="integer" default="0"/>
		<Column name="NavalUnitMaintenanceModifier" type="integer" default="0"/>
		<Column name="CapitalBuildingModifier" type="integer" default="0"/>
		<Column name="PlotBuyCostModifier" type="integer" default="0"/>
		<Column name="PlotCultureCostModifier" type="integer" default="0"/>
		<Column name="CultureFromKills" type="integer" default="0"/>
		<Column name="FaithFromKills" type="integer" default="0"/>
		<Column name="CityCultureBonus" type="integer" default="0"/>
		<Column name="CapitalThemingBonusModifier" type="integer" default="0"/>
		<Column name="PolicyCostModifier" type="integer" default="0"/>
		<Column name="CityConnectionTradeRouteChange" type="integer" default="0"/>
		<!-- Flat gold bonus-->
		<Column name="WonderProductionModifier" type="integer" default="0"/>
		<Column name="PlunderModifier" type="integer" default="0"/>
		<Column name="ImprovementMaintenanceModifier" type="integer" default="0"/>
		<Column name="GoldenAgeDurationModifier" type="integer" default="0"/>
		<Column name="GoldenAgeMoveChange" type="integer" default="0"/>
		<Column name="GoldenAgeCombatModifier" type="integer" default="0"/>
		<Column name="GoldenAgeTourismModifier" type="integer" default="0"/>
		<Column name="GoldenAgeGreatArtistRateModifier" type="integer" default="0"/>
		<Column name="GoldenAgeGreatMusicianRateModifier" type="integer" default="0"/>
		<Column name="GoldenAgeGreatWriterRateModifier" type="integer" default="0"/>
		<Column name="ExtraEmbarkMoves" type="integer" default="0"/>
		<Column name="NaturalWonderFirstFinderGold" type="integer" default="0"/>
		<Column name="NaturalWonderSubsequentFinderGold" type="integer" default="0"/>
		<Column name="NaturalWonderYieldModifier" type="integer" default="0"/>
		<Column name="NaturalWonderHappinessModifier" type="integer" default="0"/>
		<Column name="NearbyImprovementCombatBonus" type="integer" default="0"/>
		<!-- Holy sites? -->
		<Column name="NearbyImprovementBonusRange" type="integer" default="0"/>
		<!-- Holy sites? -->
		<Column name="CultureBuildingYieldChange" type="integer" default="0"/>
		<!-- Additional Culture given to Buildings that generate at least 1 Culture -->
		<Column name="CombatBonusVsHigherTech" type="integer" default="0"/>
		<Column name="CombatBonusVsLargerCiv" type="integer" default="0"/>
		<Column name="RazeSpeedModifier" type="integer" default="0"/>
		<Column name="DOFGreatPersonModifier" type="integer" default="0"/>
		<Column name="LuxuryHappinessRetention" type="integer" default="0"/>
		<Column name="ExtraSpies" type="integer" default="0"/>
		<Column name="UnresearchedTechBonusFromKills" type="integer" default="0"/>
		<Column name="ExtraFoundedCityTerritoryClaimRange" type="integer" default="0"/>
		<Column name="FreeSocialPoliciesPerEra" type="integer" default="0"/>
		<Column name="NumTradeRoutesModifier" type="integer" default="0"/>
		<Column name="TradeRouteResourceModifier" type="integer" default="0"/>
		<Column name="UniqueLuxuryCities" type="integer" default="0"/>
		<Column name="UniqueLuxuryQuantity" type="integer" default="0"/>
		<Column name="WorkerSpeedModifier" type="integer" default="0"/>
		<Column name="AfraidMinorPerTurnInfluence" type="integer" default="0"/>
		<Column name="LandTradeRouteRangeBonus" type="integer" default="0"/>
		<Column name="TradeReligionModifier" type="integer" default="0"/>
		<Column name="TradeBuildingModifier" type="integer" default="0"/>
		<!-- Multiplier to buildings that add to Trade Route gold -->
		<Column name="FightWellDamaged" type="boolean" default="false"/>
		<Column name="MoveFriendlyWoodsAsRoad" type="boolean" default="false"/>
		<Column name="FasterAlongRiver" type="boolean" default="false"/>
		<Column name="FasterInHills" type="boolean" default="false"/>
		<Column name="EmbarkedAllWater" type="boolean" default="false"/>
		<Column name="EmbarkedToLandFlatCost" type="boolean" default="false"/>
		<Column name="NoHillsImprovementMaintenance" type="boolean" default="false"/>
		<Column name="TechBoostFromCapitalScienceBuildings" type="boolean" default="false"/>
		<Column name="StaysAliveZeroCities" type="boolean" default="false"/>
		<Column name="FaithFromUnimprovedForest" type="boolean" default="false"/>
		<Column name="BonusReligiousBelief" type="boolean" default="false"/>
		<Column name="AbleToAnnexCityStates" type="boolean" default="false"/>
		<Column name="CrossesMountainsAfterGreatGeneral" type="boolean" default="false"/>
		<Column name="MayaCalendarBonuses" type="boolean" default="false"/>
		<Column name="NoAnnexing" type="boolean" default="false"/>
		<Column name="TechFromCityConquer" type="boolean" default="false"/>
		<Column name="UniqueLuxuryRequiresNewArea" type="boolean" default="false"/>
		<Column name="RiverTradeRoad" type="boolean" default="false"/>
		<Column name="AngerFreeIntrusionOfCityStates" type="boolean" default="false"/>
		<Column name="FreeUnit" type="text" reference="UnitClasses(Type)" default="NULL"/>
		<Column name="FreeUnitPrereqTech" type="text" reference="Technologies(Type)" default="NULL"/>
		<Column name="CombatBonusImprovement" type="text" reference="Improvements(Type)" default="NULL"/>
		<!-- Holy sites? -->
		<Column name="FreeBuilding" type="text" reference="Buildings(Type)" default="NULL"/>
		<Column name="FreeBuildingOnConquest" type="text" reference="Buildings(Type)" default="NULL"/>
		<Column name="ObsoleteTech" type="text" reference="Technologies(Type)" default="NULL"/>
		<Column name="PrereqTech" type="text" reference="Technologies(Type)" default="NULL"/>
	</Table>
	<Table name="Trait_ExtraYieldThresholds">
		<!-- X or more gives +1 -->
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldChanges">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldChangesStrategicResources">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldChangesNaturalWonder">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldChangesPerTradePartner">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldChangesIncomingTradeRoute">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldModifiers">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_FreePromotions">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="PromotionType" type="text" reference="UnitPromotions(Type)"/>
	</Table>
	<Table name="Trait_FreePromotionUnitCombats">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="UnitCombatType" type="text" reference="UnitCombatInfos(Type)"/>
		<Column name="PromotionType" type="text" reference="UnitPromotions(Type)"/>
	</Table>
	<Table name="Trait_MovesChangeUnitCombats">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="UnitCombatType" type="text" reference="UnitCombatInfos(Type)"/>
		<Column name="MovesChange" type="int"/>
	</Table>
	<Table name="Trait_MaintenanceModifierUnitCombats">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="UnitCombatType" type="text" reference="UnitCombatInfos(Type)"/>
		<Column name="MaintenanceModifier" type="int"/>
	</Table>
	<Table name="Trait_Terrains">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="TerrainType" type="text"/>
		<Column name="StrategicResourceQuantityModifier" type="integer" default="0"/>
	</Table>
	<Table name="Trait_ResourceQuantityModifiers">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="ResourceType" type="text" reference="Resources(Type)"/>
		<Column name="ResourceQuantityModifier" type="integer" default="0"/>
	</Table>
	<Table name="Trait_FreeResourceFirstXCities">
		<!-- check against Indonesia for Navajo -->
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="ResourceType" type="text" reference="Resources(Type)"/>
		<Column name="ResourceQuantity" type="integer"/>
		<Column name="NumCities" type="integer"/>
	</Table>
	<Table name="Trait_ImprovementYieldChanges">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="ImprovementType" type="text" reference="Improvements(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_SpecialistYieldChanges">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="SpecialistType" type="text" reference="Specialists(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_UnimprovedFeatureYieldChanges">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="FeatureType" type="text" reference="Features(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_NoTrain">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="UnitClassType" type="text" notnull="true" reference="UnitClasses(Type)"/>
	</Table>


	<Table name="MinorCivilizations">
		<Column name="ID" type="integer" primarykey="true" autoincrement="true"/>
		<Column name="Type" type="text" notnull="true" unique="true"/>
		<Column name="Description" type="text" reference="Language_en_US(Tag)"/>
		<Column name="Civilopedia" type="text" reference="Language_en_US(Tag)"/>
		<Column name="ShortDescription" type="text" reference="Language_en_US(Tag)"/>
		<Column name="Adjective" type="text" reference="Language_en_US(Tag)"/>
		<Column name="ArtDefineTag" type="text"/>
		<Column name="DefaultPlayerColor" type="text" default="NULL"/>
		<Column name="ArtStyleType" type="text" default="NULL"/>
		<Column name="ArtStyleSuffix" type="text" default="NULL"/>
		<Column name="ArtStylePrefix" type="text" default="NULL"/>
		<Column name="MinorCivTrait" type="text" notnull="true" reference="MinorCivTraits(Type)"/>
	</Table>
	<Table name="MinorCivilization_Flavors">
		<Column name="MinorCivType" type="text" reference="MinorCivilizations(Type)"/>
		<Column name="FlavorType" type="text" reference="Flavors(Type)"/>
		<Column name="Flavor" type="integer" default="-1"/>
	</Table>
	<Table name="MinorCivilization_CityNames">
		<Column name="MinorCivType" type="text" reference="MinorCivilizations(Type)"/>
		<Column name="CityName" type="text" notnull="true"/>
	</Table>
	<!-- Table data -->
	<!-- Table data -->