"Good For" Priorities

	A	B	C	D
1				-- This CEAI_Buildings.sql generated by the Buildings tab of 'Leaders' spreadsheet. -- https://docs.google.com/spreadsheet/ccc?key=0Ap8Ehya83q19dFpPbnNDMFhmM2I2YjVXR04tQWN0V2c&usp=drive_web#gid=4
2			Building_AreaYieldModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_AreaYieldModifiers Building, Yields yield WHERE Building.YieldType = yield.Type;
3			Building_BuildingClassYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_BuildingClassYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
4			Building_GlobalYieldModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_GlobalYieldModifiers Building, Yields yield WHERE Building.YieldType = yield.Type;
5			Building_ResourceYieldModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_ResourceYieldModifiers Building, Yields yield WHERE Building.YieldType = yield.Type;
6			Building_RiverPlotYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_RiverPlotYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
7			Building_SeaPlotYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_SeaPlotYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
8			Building_LakePlotYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_LakePlotYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
9			Building_SeaResourceYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_SeaResourceYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
10			Building_ResourceYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_ResourceYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
11			Building_FeatureYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_FeatureYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
12			Building_TerrainYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_TerrainYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
13			Building_SpecialistYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_SpecialistYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
14			Building_YieldChangesPerPop	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_YieldChangesPerPop Building, Yields yield WHERE Building.YieldType = yield.Type;
15			Building_YieldChangesPerReligion	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_YieldChangesPerReligion Building, Yields yield WHERE Building.YieldType = yield.Type;
16			Building_TechEnhancedYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_TechEnhancedYieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
17			Building_YieldModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_YieldModifiers Building, Yields yield WHERE Building.YieldType = yield.Type;
18			Building_YieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, yield.FlavorType, 16 FROM Building_YieldChanges Building, Yields yield WHERE Building.YieldType = yield.Type;
19
20			Building_UnitCombatFreeExperiences	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, combat.FlavorType, 16 FROM Building_UnitCombatFreeExperiences Building, UnitCombatInfos combat WHERE Building.UnitCombatType = combat.Type;
21			Building_UnitCombatProductionModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT Building.BuildingType, combat.FlavorType, 16 FROM Building_UnitCombatProductionModifiers Building, UnitCombatInfos combat WHERE Building.UnitCombatType = combat.Type;
22
23	Happiness	16	Building_BuildingClassHappiness	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_HAPPINESS' , 16 FROM Building_BuildingClassHappiness;
24	Expansion	16	Building_BuildingClassHappiness	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_EXPANSION' , 16 FROM Building_BuildingClassHappiness;
25	Military_training	16	Building_DomainFreeExperiences	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_MILITARY_TRAINING' , 16 FROM Building_DomainFreeExperiences;
26	Military_training	16	Building_DomainFreeExperiencePerGreatWork	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_MILITARY_TRAINING' , 16 FROM Building_DomainFreeExperiencePerGreatWork;
27	Military_training	8	Building_DomainProductionModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_MILITARY_TRAINING' , 8 FROM Building_DomainProductionModifiers;
28	Great_People	16	Building_FreeSpecialistCounts	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_GREAT_PEOPLE' , 16 FROM Building_FreeSpecialistCounts;
29	Gold	16	Building_HurryModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_GOLD' , 16 FROM Building_HurryModifiers;
30	Culture	16	Building_ResourceCultureChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_CULTURE' , 16 FROM Building_ResourceCultureChanges;
31	Religion	16	Building_ResourceFaithChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_RELIGION' , 16 FROM Building_ResourceFaithChanges;
32	Military_training	16	Building_UnitCombatFreeExperiences	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_MILITARY_TRAINING' , 16 FROM Building_UnitCombatFreeExperiences;
33	Military_training	8	Building_UnitCombatProductionModifiers	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_MILITARY_TRAINING' , 8 FROM Building_UnitCombatProductionModifiers;
34	Tourism	16	Building_ThemingBonuses	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_TOURISM' , 16 FROM Building_ThemingBonuses;
35	Naval_Growth	16	Building_SeaPlotYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_NAVAL_GROWTH' , 16 FROM Building_SeaPlotYieldChanges;
36	Naval_Growth	16	Building_SeaResourceYieldChanges	INSERT INTO Building_Flavors (BuildingType, FlavorType, Flavor) SELECT BuildingType, 'FLAVOR_NAVAL_GROWTH' , 16 FROM Building_SeaResourceYieldChanges;
37
38
39
40
41