albie_123
Modding In Secret
Still just as hyped as I was back in 2012. Take all the time you need, we'll be waiting!
You actually made a new game with Civ5 as base!
I look forward to seeing more modern wars with this system!
Like the WW2 Chinese/Japan Theatre, the Korean War and the Vietnam War!
-- WARNING TO MODDERS:
-- Trying to make 'super-duper' buildings such as a 'steel producing power plant that also build medium tanks!' might
-- be possible, but the code has not been designed or tested for such exotic configurations...so don't be suprised if a few
-- runtime errors spit out in the FireTuner!
-- Levels for each building indicate what the building produces at various stages of the scenario based on projects
-- Level 0 indicates the building consumes production resources but does not produce actual equipment
-- Level 1, 2, 3 indicate different types of equipment produced based on built projects
-- Power is calculated for hydroplants using the following formula (MW Output * 8760 hours (1 year) / 1000). Example: Dnieper hydroplant is noted as having output of 650 MW when started. (650 x 8760 = 5694000 kWh). This is divided by 1000 to give us GWh (5694 GWh)
-- Koepchenwerk hydro-plant output has been ahistorically increased by 12000GWh to balance the production requirements of larger German cities. This also allows representation for German cities providing power not on the map!
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- SUPPORT BUILDINGS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO EF_SupplyBuildings (Type, IndustrialFactor)
-- Type IndustrialFactor
SELECT 'SUPPLY_BUILDING_LIGHT_ASSEMBLY_WORKS', 2 UNION ALL
SELECT 'SUPPLY_BUILDING_MEDIUM_ASSEMBLY_WORKS', 4 UNION ALL
SELECT 'SUPPLY_BUILDING_HEAVY_ASSEMBLY_WORKS', 6 ;
INSERT INTO EF_SupplyBuildings (Type, Modifier, AgriculturalFactor, OutputImpactedModifier, IndustrialFactor, BaseWorkerModifier, FoodRequired)
-- Type Modifier AgricFactor ImpactedMod IndustrialFactor BaseWorkerMod FoodRequired
SELECT 'SUPPLY_BUILDING_FARM', 10, 4, 5, 0, 0.9, 0 UNION ALL -- 25% extra food
SELECT 'SUPPLY_BUILDING_GRAIN_SILO', 20, 4, 10, 0, 0.12, 0 UNION ALL -- 25% extra food
SELECT 'SUPPLY_BUILDING_HARBOR', 10, 2, 10, 0, 0.2, 0 UNION ALL -- 25% extra food
SELECT 'SUPPLY_BUILDING_WATER_SUPPLY', 15, 2, 10, 0, 0, 0 UNION ALL -- 25% extra food
SELECT 'SUPPLY_BUILDING_FOOD_WAREHOUSE', 20, 2, 10, 0, 0.001, 0 UNION ALL -- 25% extra food
SELECT 'SUPPLY_BUILDING_WORKERS_QUARTERS', 25, 0, 0, 2, 0, 0 UNION ALL -- 25% extra production output for supply resource
SELECT 'SUPPLY_BUILDING_RAIL_WORKSHOP', 25, 0, 10, 2, 0.03, 1 UNION ALL -- 25% extra rail points
SELECT 'SUPPLY_BUILDING_RUHR_STEELWORKS', -81, 0, 0, 8, 0, 0 UNION ALL -- Reduces steel output by 74% for Germany as base output is way too high because of high production values in German cities!
SELECT 'SUPPLY_BUILDING_ACADEMY', 10, 0, 0, 0, 0.01, 0 UNION ALL -- 10% extra personnel
SELECT 'SUPPLY_BUILDING_BARRACKS', 25, 0, 0, 0, 0, 0 ; -- 25% extra personnel
INSERT INTO SQLCheckpoints(Type) VALUES ('GPW_SupplyData_Buildings_1');
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- RESOURCE/TRANSPORT PRODUCING BUILDINGS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO EF_SupplyBuildings (Type, BaseWorkerModifier, IndustrialFactor, BaseEvacRailPointsRequired, RailInput, FoodRequired, RailRequired, ResourceOutputType, ResourceOutput, PrimaryResource, SecondaryResource, OutputImpactedModifier, OutputModBuilding1, OutputModBuilding2)
-- Type BaseWorkerMod IndFct EvacRP RIn FRq RRq ResourceType ResOutput PrimaryRes SecondaryRes ImpactedModifier OutputModBuilding1 OutputModBuilding2
SELECT 'SUPPLY_BUILDING_RAIL_STATION', 0.1, 0.5, 0, 0, 0, 1, 'Rail', 35, NULL, NULL, 50, 'BUILDING_RAIL_WORKSHOP', NULL UNION ALL
SELECT 'SUPPLY_BUILDING_STEEL_MILL', 0.89, 2, 40, 11, 0, 1, 'Steel', 3.017, 'RESOURCE_IRON', 'RESOURCE_COAL', 50, 'BUILDING_WORKERS_QUARTERS', NULL UNION ALL
SELECT 'SUPPLY_BUILDING_ALUMINIUM_PLANT', 0.84, 2, 40, 10, 0, 1, 'Aluminium', 0.75, 'RESOURCE_ALUMINUM','RESOURCE_COAL', 50, 'BUILDING_WORKERS_QUARTERS', NULL UNION ALL
SELECT 'SUPPLY_BUILDING_POWER_PLANT', 0.4, 2, 30, 9, 0, 1, 'Power', 650.0, 'RESOURCE_COAL', NULL, 0, NULL, NULL UNION ALL
SELECT 'SUPPLY_BUILDING_RYBINSK_HYDRO_POWER', 0.2, 6, 0, 0, 0, 0, 'Power', 3035.0, NULL, NULL, 75, NULL, NULL UNION ALL
SELECT 'SUPPLY_BUILDING_DNIEPER_HYDRO_POWER', 0.2, 6, 0, 0, 0, 0, 'Power', 5694.0, NULL, NULL, 75, NULL, NULL UNION ALL
SELECT 'SUPPLY_BUILDING_VOLKHOV_HYDRO_POWER', 0.2, 6, 0, 0, 0, 0, 'Power', 753.0, NULL, NULL, 75, NULL, NULL UNION ALL
SELECT 'SUPPLY_BUILDING_KOEPCHENWERK_HYDRO_POWER', 0.2, 6, 0, 0, 0, 0, 'Power', 13156.32, NULL, NULL, 75, NULL, NULL UNION ALL
SELECT 'SUPPLY_BUILDING_OIL_REFINERY', 0.4, 2, 0, 7, 0, 1, 'Fuel', 2.194, 'RESOURCE_OIL', NULL, 50, 'BUILDING_WORKERS_QUARTERS', NULL UNION ALL
SELECT 'SUPPLY_BUILDING_BAKU_OIL_REFINERY', 0.8, 2, 0, 11, 0, 1, 'Fuel', 4.1101, 'RESOURCE_OIL', NULL, 50, 'BUILDING_WORKERS_QUARTERS', NULL UNION ALL
SELECT 'SUPPLY_BUILDING_SYNTHETIC_FUEL_PLANT', 0.2, 2, 0, 5, 0, 1, 'Fuel', 1.42, 'RESOURCE_COAL', NULL, 0, 'BUILDING_WORKERS_QUARTERS', NULL ;
INSERT INTO SQLCheckpoints(Type) VALUES ('GPW_SupplyData_Buildings_2');
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- E BUILDINGS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO EF_SupplyBuildings (Type, BaseWorkerModifier, Modifier, BaseEvacRailPointsRequired, ResourceOutputType, ResourceOutput, RailInput, PowerInput, L0_SteelInput, L0_AlumInput, L1_SteelInput1, L1_AlumInput1, L1_SteelInput2, L1_AlumInput2, L2_SteelInput1, L2_AlumInput1, L2_SteelInput2, L2_AlumInput2, L3_SteelInput1, L3_AlumInput1, L3_SteelInput2, L3_AlumInput2, ProducesEquipment, FoodRequired, SteelRequired, AlumRequired, PowerRequired, RailRequired, ProdLevels, L1_EqType1, L1_EqQty1, L1_EqType2, L1_EqQty2, L2_ProjPrereq, L2_EqType1, L2_EqQty1, L2_EqType2, L2_EqQty2, L3_ProjPrereq, L3_EqType1, L3_EqQty1, L3_EqType2, L3_EqQty2)
-- Type Wkrs Modifier EvacRP ResourceType ResOutput RIn PIn L0SIn L0AIn L1SIn1 L1AIn1 L1SIn2 L1AIn2 L2SIn1 L2AIn1 L2SIn2 L2AIn2 L3SIn1 L3AIn1 L3SIn2 L3AIn2 Eq? FRq SRq ARq PRq RRq ProdLvls L1EqT1 L1EqQ1 L1EqT2 L1EqQ2 L2_ProjPrereq L2EqT1 L2EqQ1 L2EqT2 L2EqQ2 L3_ProjPrereq L3EqT1 L3EqQ1 L3EqT2 L3EqQ2
SELECT 'SUPPLY_BUILDING_ARMAMENTS_PLANT', 0.85, 0, 18, NULL, 0, 6, 10, 0, 0, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'FG', 0.45, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
--SELECT 'SUPPLY_BUILDING_SOVIET_VEHICLE_WORKS', 0.81, 25, 20, NULL, 0, 6, 9.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
--SELECT 'SUPPLY_BUILDING_GERMAN_VEHICLE_WORKS', 0.81, 25, 0, NULL, 0, 6, 9.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_VEHICLE_WORKS', 0.81, 25, 0, NULL, 0, 4, 10, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'LT', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_AIRCRAFT_WORKS', 0.8, 0, 0, NULL, 0, 4, 10, 0, 0, 0.1, 2.5, 0.1, 4.0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'FB', 0.1, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 ;
INSERT INTO EF_SupplyBuildings (Type, BaseWorkerModifier, BaseEvacRailPointsRequired, RailInput, PowerInput, L0_SteelInput, L0_AlumInput, L1_SteelInput1, L1_AlumInput1, L1_SteelInput2, L1_AlumInput2, L2_SteelInput1, L2_AlumInput1, L2_SteelInput2, L2_AlumInput2, L3_SteelInput1, L3_AlumInput1, L3_SteelInput2, L3_AlumInput2, ProducesEquipment, FoodRequired, SteelRequired, AlumRequired, PowerRequired, RailRequired, ProdLevels, L1_EqType1, L1_EqQty1, L1_EqType2, L1_EqQty2, L2_ProjPrereq, L2_EqType1, L2_EqQty1, L2_EqType2, L2_EqQty2, L3_ProjPrereq, L3_EqType1, L3_EqQty1, L3_EqType2, L3_EqQty2)
-- Type Wkrs EvacRP RIn PIn L0SIn L0AIn L1SIn1 L1AIn1 L1SIn2 L1AIn2 L2SIn1 L2AIn1 L2SIn2 L2AIn2 L3SIn1 L3AIn1 L3SIn2 L3AIn2 Eq? FRq SRq ARq PRq RRq ProdLvls L1EqT1 L1EqQ1 L1EqT2 L1EqQ2 L2_ProjPrereq L2EqT1 L2EqQ1 L2EqT2 L2EqQ2 L3_ProjPrereq L3EqT1 L3EqQ1 L3EqT2 L3EqQ2
SELECT 'SUPPLY_BUILDING_CITY_GARRISON', 0.21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
--SELECT 'SUPPLY_BUILDING_DESIGN_BUREAU', 0.005, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, None', 0 UNION ALL
-- Type Wkrs EvacRP RIn PIn L0SIn L0AIn L1SIn1 L1AIn1 L1SIn2 L1AIn2 L2SIn1 L2AIn1 L2SIn2 L2AIn2 L3SIn1 L3AIn1 L3SIn2 L3AIn2 Eq? FRq SRq ARq PRq RRq ProdLvls L1EqT1 L1EqQ1 L1EqT2 L1EqQ2 L2_ProjPrereq L2EqT1 L2EqQ1 L2EqT2 L2EqQ2 L3_ProjPrereq L3EqT1 L3EqQ1 L3EqT2 L3EqQ2
SELECT 'SUPPLY_BUILDING_ZAVOD_KATYUSHA', 0.5, 18, 5, 11, 4.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_LIGHT', 0.7, 24, 7, 13, 0, 0, 10, 0, 0, 0, 10, 0, 10, 0, 10, 0, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.35, 'None', 0, 'PROJECT_SOV_SU_76', 'LT', 0.1, 'LSP', 0.25, 'PROJECT_SOV_TANK_500', 'LSP', 0.35, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_T34', 0.83, 28, 9, 13, 0, 0, 34, 0.08, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'MT', 0.15, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_KV_IS', 0.82, 32, 11, 15, 0, 0, 52, 0.08, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2, 'HT', 0.009, 'None', 0, 'PROJECT_SOV_IS_2', 'HT', 0.009, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_SU', 0.76, 0, 9, 13, 0, 0, 34, 0.08, 0, 0, 34, 0.08, 32, 0.08, 31, 0.08, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'MSP', 0.05, 'None', 0, 'PROJECT_SOV_SU_85', 'MSP', 0.015, 'MTD', 0.035, 'PROJECT_SOV_SU_100', 'MTD', 0.05, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_ISU', 0.73, 0, 11, 15, 0, 0, 53, 0.08, 0, 0, 47, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2, 'HSP', 0.02, 'None', 0, 'PROJECT_SOV_ISU', 'HSP', 0.02, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_YAK', 0.78, 24, 7, 13, 0, 0, 0.1, 1.14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.05, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_LA', 0.77, 24, 7, 13, 0, 0, 0.1, 0.05, 0, 0, 0.1, 0.2, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2, 'F', 0.05, 'None', 0, 'PROJECT_SOV_LA_5N', 'F', 0.05, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_IL2', 0.79, 28, 9, 13, 0, 0, 0.8, 3.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'GA', 0.05, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_IL4', 0.71, 32, 11, 14, 0, 0, 0.2, 3.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'MB', 0.02, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ZAVOD_PE2', 0.74, 32, 11, 15, 0, 0, 0.2, 5.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'FB', 0.025, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 ;
INSERT INTO SQLCheckpoints(Type) VALUES ('GPW_SupplyData_Buildings_3');
INSERT INTO EF_SupplyBuildings (Type, BaseWorkerModifier, IndustrialFactor, RailInput, PowerInput, L0_SteelInput, L0_AlumInput, L1_SteelInput1, L1_AlumInput1, L1_SteelInput2, L1_AlumInput2, L2_SteelInput1, L2_AlumInput1, L2_SteelInput2, L2_AlumInput2, L3_SteelInput1, L3_AlumInput1, L3_SteelInput2, L3_AlumInput2, ProducesEquipment, FoodRequired, SteelRequired, AlumRequired, PowerRequired, RailRequired, ProdLevels, L1_EqType1, L1_EqQty1, L1_EqType2, L1_EqQty2, L2_ProjPrereq, L2_EqType1, L2_EqQty1, L2_EqType2, L2_EqQty2, L3_ProjPrereq, L3_EqType1, L3_EqQty1, L3_EqType2, L3_EqQty2)
-- Type Wkrs IndFactor RIn PIn L0SIn L0AIn L1SIn1 L1AIn1 L1SIn2 L1AIn2 L2SIn1 L2AIn1 L2SIn2 L2AIn2 L3SIn1 L3AIn1 L3SIn2 L3AIn2 Eq? FRq SRq ARq PRq RRq ProdLvls L1EqT1 L1EqQ1 L1EqT2 L1EqQ2 L2_ProjPrereq L2EqT1 L2EqQ1 L2EqT2 L2EqQ2 L3_ProjPrereq L3EqT1 L3EqQ1 L3EqT2 L3EqQ2
SELECT 'SUPPLY_BUILDING_KRUPP', 0.8, 16, 7, 12, 0, 0, 26, 0, 0, 0, 26, 0, 26, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2, 'MT', 0.25, 'None', 0, 'PROJECT_GER_STUG_IV', 'MT', 0.15, 'MSP', 0.1, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_MAN', 0.8, 14, 7, 12, 0, 0, 25, 0, 0, 0, 25, 0, 11, 0, 50, 0.08, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.15, 'None', 0, 'PROJECT_GER_MARDER', 'LT', 0.05, 'LTD', 0.1, 'PROJECT_GER_PANZER_43', 'MT', 0.08, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_MIAG', 0.8, 12, 7, 12, 0, 0, 25, 0, 26, 0, 26, 0, 0, 0, 26, 0, 51, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.05, 'LSP', 0.05, 'PROJECT_GER_STUG_III_G', 'LSP', 0.1, 'None', 0, 'PROJECT_GER_JAGDPANTHER', 'LSP', 0.05, 'MTD', 0.025 UNION ALL
SELECT 'SUPPLY_BUILDING_HENSCHEL', 0.8, 12, 9, 15, 0, 0, 25, 0, 0, 0, 25, 0, 62, 0.08, 76, 0.08, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.1, 'None', 0, 'PROJECT_GER_TIGER', 'LT', 0.05, 'HT', 0.005, 'PROJECT_GER_PANZER_43', 'HT', 0.006, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ALKETT', 0.8, 14, 7, 12, 0, 0, 26, 0, 8, 0, 26, 0, 18, 0, 26, 0, 27, 0, 1, 1, 1, 1, 1, 1, 3, 'LSP', 0.1, 'LTD', 0.1, 'PROJECT_GER_WESPE_HUMMEL', 'LSP', 0.1, 'LSP2', 0.05, 'PROJECT_GER_JAGDPANZER_IV', 'LSP', 0.05, 'MTD', 0.05 UNION ALL
SELECT 'SUPPLY_BUILDING_DAIMLER', 0.8, 16, 7, 12, 0, 0, 25, 0, 0, 0, 25, 0, 11, 0, 50, 0.08, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.15, 'None', 0, 'PROJECT_GER_MARDER', 'LT', 0.075, 'LTD', 0.05, 'PROJECT_GER_PANZER_43', 'MT', 0.05, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_SKODA', 0.7, 10, 5, 9.5, 0, 0, 10, 0, 0, 0, 11, 0, 0, 0, 17, 0, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.05, 'None', 0, 'PROJECT_GER_MARDER', 'LTD', 0.05, 'None', 0, 'PROJECT_GER_HETZER', 'LTD', 0.05, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_BMM', 0.7, 10, 5, 9.5, 0, 0, 10, 0, 0, 0, 11, 0, 0, 0, 17, 0, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.05, 'None', 0, 'PROJECT_GER_MARDER', 'LTD', 0.05, 'None', 0, 'PROJECT_GER_HETZER', 'LTD', 0.05, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_NIBELUNGEN_WORKS', 0.9, 20, 9, 10, 0, 0, 26, 0, 0, 0, 26, 0, 27, 0, 26, 0, 79, 0, 1, 1, 1, 1, 1, 1, 2, 'MT', 0.3, 'None', 0, 'PROJECT_GER_JAGDPANZER_IV', 'MT', 0.2, 'MTD', 0.1, 'PROJECT_GER_JAGDTIGER', 'MT', 0.1, 'HTD', 0.025 UNION ALL
SELECT 'SUPPLY_BUILDING_VOMAG', 0.7, 10, 7, 10, 0, 0, 26, 0, 0, 0, 26, 0, 27, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2, 'MT', 0.2, 'None', 0, 'PROJECT_GER_JAGDPANZER_IV', 'MT', 0.1, 'MTD', 0.05, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_MNH', 0.8, 10, 7, 10, 0, 0, 25, 0, 0, 0, 50, 0.08, 0, 0, 50, 0.08, 51, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.2, 'None', 0, 'PROJECT_GER_PANZER_43', 'MT', 0.05, 'None', 0, 'PROJECT_GER_JADPANTHER', 'MT', 0.025, 'MTD', 0.01 UNION ALL
SELECT 'SUPPLY_BUILDING_DEW', 0.6, 8, 7, 9.5, 0, 0, 26, 0, 0, 0, 26, 0, 18, 0, 26, 0, 26, 0, 1, 1, 1, 1, 1, 1, 3, 'MT', 0.1, 'None', 0, 'PROJECT_GER_WESPE_HUMMEL', 'MT', 0.05, 'LSP2', 0.025, 'PROJECT_GER_NASHORN', 'MT', 0.05, 'MTD', 0.025 UNION ALL
SELECT 'SUPPLY_BUILDING_FAMO', 0.6, 10, 5, 9.5, 0, 0, 25, 0, 26, 0, 26, 0, 18, 0, 51, 0, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.05, 'LSP', 0.04, 'PROJECT_GER_WESPE_HUMMEL', 'LSP', 0.05, 'LSP2', 0.025, 'PROJECT_GER_JADPANTHER', 'LSP', 0.04, 'LT', 0.5 UNION ALL
SELECT 'SUPPLY_BUILDING_WWAG', 0.6, 10, 5, 10, 0, 0, 25, 0, 26, 0, 26, 0, 11, 0, 26, 0, 0, 0, 1, 1, 1, 1, 1, 1, 3, 'LT', 0.1, 'LSP', 0.1, 'PROJECT_GER_MARDER', 'LSP', 0.1, 'LTD', 0.1, 'PROJECT_GER_STUG_III_G', 'LSP', 0.15, 'LT', 0.5 UNION ALL
-- Type Wkrs IndFactor RIn PIn L0SIn L0AIn L1SIn1 L1AIn1 L1SIn2 L1AIn2 L2SIn1 L2AIn1 L2SIn2 L2AIn2 L3SIn1 L3AIn1 L3SIn2 L3AIn2 Eq? FRq SRq ARq PRq RRq ProdLvls L1EqT1 L1EqQ1 L1EqT2 L1EqQ2 L2_ProjPrereq L2EqT1 L2EqQ1 L2EqT2 L2EqQ2 L3_ProjPrereq L3EqT1 L3EqQ1 L3EqT2 L3EqQ2
SELECT 'SUPPLY_BUILDING_FOCKE_WULF', 0.8, 12, 5, 9, 0, 0, 0.1, 2.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_AGO', 0.8, 10, 4, 9, 0, 0, 0.1, 2.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_FIESLER', 0.5, 10, 4, 9, 0, 0, 0.1, 2.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_KURT', 0.4, 10, 3, 8, 0, 0, 0.1, 2.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_MESSERSCHMITT', 0.9, 12, 5, 9, 0, 0, 0.1, 2.2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.2, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ERLA_I', 0.8, 10, 5, 9, 0, 0, 0.1, 2.2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ERLA_II', 0.8, 10, 6, 9, 0, 0, 0.1, 2.2, 0.1, 3.8, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2, 'F', 0.1, 'None', 0, 'PROJECT_GER_ME_262', 'JF', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ERLA_III', 0.8, 10, 7, 9.5, 0, 0, 0.1, 4.3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'F', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_JUNKERS_I', 0.7, 12, 7, 9.5, 0, 0, 0.1, 3.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'GA', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_JUNKERS_II', 0.7, 12, 9, 9.5, 0, 0, 0.2, 7.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'FB', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_ATG', 0.5, 10, 9, 9.5, 0, 0, 0.2, 7.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'FB', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_WESERFLUG_I', 0.7, 12, 7, 9.5, 0, 0, 0.1, 3.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'GA', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_WESERFLUG_II', 0.7, 12, 9, 9.5, 0, 0, 0.2, 7.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'FB', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 UNION ALL
SELECT 'SUPPLY_BUILDING_HEINKEL', 0.7, 12, 9, 10, 0, 0, 0.2, 7.8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'MB', 0.1, 'None', 0, 'None', 'None', 0, 'None', 0, 'None', 'None', 0, 'None', 0 ;
INSERT INTO SQLCheckpoints(Type) VALUES ('GPW_SupplyData_Buildings_4_DONE');