CREATE TABLE Buildings ('ID' integer primary key autoincrement , 'Type' text not null unique , 'Description' text , 'Civilopedia' text , 'Strategy' text , 'Help' text , 'Quote' text , 'GoldMaintenance' integer default 0 , 'MutuallyExclusiveGroup' integer default '-1' , 'TeamShare' boolean default 0 , 'Water' boolean default 0 , 'River' boolean default 0 , 'FreshWater' boolean default 0 , 'Mountain' boolean default 0 , 'NearbyMountainRequired' boolean default 0 , 'Hill' boolean default 0 , 'Flat' boolean default 0 , 'FoundsReligion' boolean default 0 , 'IsReligious' boolean default 0 , 'BorderObstacle' boolean default 0 , 'PlayerBorderObstacle' boolean default 0 , 'Capital' boolean default 0 , 'GoldenAge' boolean default 0 , 'MapCentering' boolean default 0 , 'NeverCapture' boolean default 0 , 'NukeImmune' boolean default 0 , 'AllowsWaterRoutes' boolean default 0 , 'ExtraLuxuries' boolean default 0 , 'DiplomaticVoting' boolean default 0 , 'Cost' integer default 0 , 'NumCityCostMod' integer default 0 , 'HurryCostModifier' integer default 0 , 'MinAreaSize' integer default 0 , 'ConquestProb' integer default 0 , 'CitiesPrereq' integer default 0 , 'LevelPrereq' integer default 0 , 'Culture' integer default 0 , 'CultureRateModifier' integer default 0 , 'GlobalCultureRateModifier' integer default 0 , 'GreatPeopleRateModifier' integer default 0 , 'GlobalGreatPeopleRateModifier' integer default 0 , 'GreatGeneralRateModifier' integer default 0 , 'GreatPersonExpendGold' integer default 0 , 'GoldenAgeModifier' integer default 0 , 'UnitUpgradeCostMod' integer default 0 , 'Experience' integer default 0 , 'GlobalExperience' integer default 0 , 'FoodKept' integer default 0 , 'Airlift' integer default 0 , 'AirModifier' integer default 0 , 'NukeModifier' integer default 0 , 'NukeExplosionRand' integer default 0 , 'HealRateChange' integer default 0 , 'Happiness' integer default 0 , 'UnmoddedHappiness' integer default 0 , 'UnhappinessModifier' integer default 0 , 'HappinessPerCity' integer default 0 , 'HappinessPerXPolicies' integer default 0 , 'CityCountUnhappinessMod' integer default 0 , 'NoOccupiedUnhappiness' boolean default 0 , 'WorkerSpeedModifier' integer default 0 , 'MilitaryProductionModifier' integer default 0 , 'SpaceProductionModifier' integer default 0 , 'BuildingProductionModifier' integer default 0 , 'WonderProductionModifier' integer default 0 , 'TradeRouteModifier' integer default 0 , 'CapturePlunderModifier' integer default 0 , 'PolicyCostModifier' integer default 0 , 'PlotCultureCostModifier' integer default 0 , 'GlobalPlotCultureCostModifier' integer default 0 , 'PlotBuyCostModifier' integer default 0 , 'GlobalPlotBuyCostModifier' integer default 0 , 'GlobalPopulationChange' integer default 0 , 'TechShare' integer default 0 , 'FreeTechs' integer default 0 , 'FreePolicies' integer default 0 , 'FreeGreatPeople' integer default 0 , 'MedianTechPercentChange' integer default 0 , 'Gold' integer default 0 , 'AllowsRangeStrike' boolean default 0 , 'Defense' integer default 0 , 'GlobalDefenseMod' integer default 0 , 'MinorFriendshipChange' integer default 0 , 'VictoryPoints' integer default 0 , 'BuildingClass' text default NULL , 'ArtDefineTag' text default NULL , 'NearbyTerrainRequired' text default NULL , 'ProhibitedCityTerrain' text default NULL , 'VictoryPrereq' text default NULL , 'FreeStartEra' text default NULL , 'MaxStartEra' text default NULL , 'ObsoleteTech' text default NULL , 'EnhancedYieldTech' text default NULL , 'FreeBuilding' text default NULL , 'FreeBuildingThisCity' text default NULL , 'FreePromotion' text default NULL , 'TrainedFreePromotion' text default NULL , 'FreePromotionRemoved' text default NULL , 'ReplacementBuildingClass' text default NULL , 'PrereqTech' text default NULL , 'SpecialistType' text default NULL , 'SpecialistCount' integer default 0 , 'SpecialistExtraCulture' integer default 0 , 'GreatPeopleRateChange' integer default 0 , 'CityWall' boolean default 0 , 'DisplayPosition' integer default 0 , 'PortraitIndex' integer default '-1' , 'WonderSplashImage' text default NULL , 'WonderSplashAnchor' text default 'R,T' , 'WonderSplashAudio' text , 'IconAtlas' text default NULL , 'ArtInfoCulturalVariation' boolean default 0 , 'ArtInfoEraVariation' boolean default 0 , 'ArtInfoRandomVariation' boolean default 0 , foreign key (Description) references Language_en_US(Tag), foreign key (Civilopedia) references Language_en_US(Tag), foreign key (Strategy) references Language_en_US(Tag), foreign key (Help) references Language_en_US(Tag), foreign key (Quote) references Language_en_US(Tag), foreign key (BuildingClass) references BuildingClasses(Type), foreign key (NearbyTerrainRequired) references Terrains(Type), foreign key (ProhibitedCityTerrain) references Terrains(Type), foreign key (VictoryPrereq) references Victories(Type), foreign key (FreeStartEra) references Eras(Type), foreign key (MaxStartEra) references Eras(Type), foreign key (ObsoleteTech) references Technologies(Type), foreign key (EnhancedYieldTech) references Technologies(Type), foreign key (FreeBuilding) references BuildingClasses(Type), foreign key (FreeBuildingThisCity) references BuildingClasses(Type), foreign key (FreePromotion) references UnitPromotions(Type), foreign key (TrainedFreePromotion) references UnitPromotions(Type), foreign key (FreePromotionRemoved) references UnitPromotions(Type), foreign key (ReplacementBuildingClass) references BuildingClasses(Type), foreign key (PrereqTech) references Technologies(Type), foreign key (SpecialistType) references Specialists(Type), foreign key (IconAtlas) references IconTextureAtlases(Atlas))