GoldenAge_Milestone.sql

INSERT OR REPLACE INTO Types (Type,					Kind) VALUES	
('TECH_ANCIENT_MILESTONE',		'KIND_TECH'),
('TECH_CLASSICAL_MILESTONE',	'KIND_TECH'),
('TECH_MEDIEVAL_MILESTONE',		'KIND_TECH'),
('TECH_RENAISSANCE_MILESTONE',	'KIND_TECH'),
('TECH_INDUSTRIAL_MILESTONE',	'KIND_TECH'),
('TECH_MODERN_MILESTONE',		'KIND_TECH'),
('TECH_ATOMIC_MILESTONE',		'KIND_TECH'),
('TECH_INFORMATION_MILESTONE',	'KIND_TECH');

INSERT OR REPLACE INTO Technologies 
(TechnologyType,					Name,								Description,								Cost,	AdvisorType,		EraType,			UITreeRow) VALUES	
('TECH_ANCIENT_MILESTONE',			'LOC_ANCIENT_MILESTONE_NAME',		'LOC_TECH_MILESTONE_DESCRIPTION',			100, 	'ADVISOR_GENERIC',	'ERA_ANCIENT', 		0),
('TECH_CLASSICAL_MILESTONE',		'LOC_CLASSICAL_MILESTONE_NAME',		'LOC_TECH_MILESTONE_DESCRIPTION',			350, 	'ADVISOR_GENERIC',	'ERA_CLASSICAL', 	0),
('TECH_MEDIEVAL_MILESTONE',			'LOC_MEDIEVAL_MILESTONE_NAME',		'LOC_TECH_MILESTONE_DESCRIPTION',			1050, 	'ADVISOR_GENERIC',	'ERA_MEDIEVAL', 	0),
('TECH_RENAISSANCE_MILESTONE',		'LOC_RENAISSANCE_MILESTONE_NAME',	'LOC_TECH_MILESTONE_DESCRIPTION',			2800, 	'ADVISOR_GENERIC',	'ERA_RENAISSANCE', 	0),
('TECH_INDUSTRIAL_MILESTONE',		'LOC_INDUSTRIAL_MILESTONE_NAME',	'LOC_TECH_MILESTONE_DESCRIPTION',			5000, 	'ADVISOR_GENERIC',	'ERA_INDUSTRIAL', 	0),
('TECH_MODERN_MILESTONE',			'LOC_MODERN_MILESTONE_NAME',		'LOC_TECH_MILESTONE_DESCRIPTION',			7800, 	'ADVISOR_GENERIC',	'ERA_MODERN', 		0),
('TECH_ATOMIC_MILESTONE',			'LOC_ATOMIC_MILESTONE_NAME',		'LOC_TECH_MILESTONE_DESCRIPTION',			11000, 	'ADVISOR_GENERIC',	'ERA_ATOMIC', 		0),
('TECH_INFORMATION_MILESTONE',		'LOC_INFORMATION_MILESTONE_NAME',	'LOC_TECH_MILESTONE_DESCRIPTION',			17000, 	'ADVISOR_GENERIC',	'ERA_INFORMATION', 	0);

INSERT OR REPLACE INTO Types (Type,					Kind) VALUES	
('CIVIC_ANCIENT_MILESTONE',		'KIND_CIVIC'),
('CIVIC_CLASSICAL_MILESTONE',	'KIND_CIVIC'),
('CIVIC_MEDIEVAL_MILESTONE',	'KIND_CIVIC'),
('CIVIC_RENAISSANCE_MILESTONE',	'KIND_CIVIC'),
('CIVIC_INDUSTRIAL_MILESTONE',	'KIND_CIVIC'),
('CIVIC_MODERN_MILESTONE',		'KIND_CIVIC'),
('CIVIC_ATOMIC_MILESTONE',		'KIND_CIVIC'),
('CIVIC_INFORMATION_MILESTONE',	'KIND_CIVIC');

INSERT OR REPLACE INTO Civics 
(CivicType,							Name,								Description,								Cost,	AdvisorType,		EraType,			UITreeRow) VALUES	
('CIVIC_ANCIENT_MILESTONE',			'LOC_ANCIENT_MILESTONE_NAME',		'LOC_CIVIC_MILESTONE_DESCRIPTION',			100, 	'ADVISOR_GENERIC',	'ERA_ANCIENT', 		0),
('CIVIC_CLASSICAL_MILESTONE',		'LOC_CLASSICAL_MILESTONE_NAME',		'LOC_CIVIC_MILESTONE_DESCRIPTION',			200, 	'ADVISOR_GENERIC',	'ERA_CLASSICAL', 	0),
('CIVIC_MEDIEVAL_MILESTONE',		'LOC_MEDIEVAL_MILESTONE_NAME',		'LOC_CIVIC_MILESTONE_DESCRIPTION',			600, 	'ADVISOR_GENERIC',	'ERA_MEDIEVAL', 	0),
('CIVIC_RENAISSANCE_MILESTONE',		'LOC_RENAISSANCE_MILESTONE_NAME',	'LOC_CIVIC_MILESTONE_DESCRIPTION',			1800, 	'ADVISOR_GENERIC',	'ERA_RENAISSANCE', 	0),
('CIVIC_INDUSTRIAL_MILESTONE',		'LOC_INDUSTRIAL_MILESTONE_NAME',	'LOC_CIVIC_MILESTONE_DESCRIPTION',			3200, 	'ADVISOR_GENERIC',	'ERA_INDUSTRIAL', 	0),
('CIVIC_MODERN_MILESTONE',			'LOC_MODERN_MILESTONE_NAME',		'LOC_CIVIC_MILESTONE_DESCRIPTION',			7000, 	'ADVISOR_GENERIC',	'ERA_MODERN', 		0),
('CIVIC_ATOMIC_MILESTONE',			'LOC_ATOMIC_MILESTONE_NAME',		'LOC_CIVIC_MILESTONE_DESCRIPTION',			13000, 	'ADVISOR_GENERIC',	'ERA_ATOMIC', 		0),
('CIVIC_INFORMATION_MILESTONE',		'LOC_INFORMATION_MILESTONE_NAME',	'LOC_CIVIC_MILESTONE_DESCRIPTION',			21000, 	'ADVISOR_GENERIC',	'ERA_INFORMATION', 	0);

--TechnologyPrereqs
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_CELESTIAL_NAVIGATION';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_CURRENCY';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_HORSEBACK_RIDING';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_IRON_WORKING';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_ENGINEERING';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_ASTROLOGY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_IRRIGATION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_WRITING';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_THE_WHEEL';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_MASONRY';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_CELESTIAL_NAVIGATION' , 	'TECH_ANCIENT_MILESTONE' ),
('TECH_CURRENCY' , 				'TECH_ANCIENT_MILESTONE' ),
('TECH_HORSEBACK_RIDING' , 		'TECH_ANCIENT_MILESTONE' ),
('TECH_IRON_WORKING' , 			'TECH_ANCIENT_MILESTONE' ),
('TECH_ENGINEERING' , 			'TECH_ANCIENT_MILESTONE' ),
('TECH_ANCIENT_MILESTONE' , 	'TECH_ASTROLOGY' ),
('TECH_ANCIENT_MILESTONE' , 	'TECH_SAILING' ),
('TECH_ANCIENT_MILESTONE' , 	'TECH_IRRIGATION' ),
('TECH_ANCIENT_MILESTONE' , 	'TECH_WRITING' ),
('TECH_ANCIENT_MILESTONE' , 	'TECH_THE_WHEEL' ),
('TECH_ANCIENT_MILESTONE' , 	'TECH_MASONRY' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_BUTTRESS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_APPRENTICESHIP';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_MILITARY_TACTICS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_MACHINERY';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_CASTLES';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_SHIPBUILDING';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_MATHEMATICS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_HORSEBACK_RIDING';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_CONSTRUCTION';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_BUTTRESS' , 				'TECH_CLASSICAL_MILESTONE' ),
('TECH_APPRENTICESHIP' , 		'TECH_CLASSICAL_MILESTONE' ),
('TECH_MILITARY_TACTICS' , 		'TECH_CLASSICAL_MILESTONE' ),
('TECH_MACHINERY' , 			'TECH_CLASSICAL_MILESTONE' ),
('TECH_CASTLES' , 				'TECH_CLASSICAL_MILESTONE' ),
('TECH_CLASSICAL_MILESTONE' , 	'TECH_SHIPBUILDING' ),
('TECH_CLASSICAL_MILESTONE' , 	'TECH_MATHEMATICS' ),
('TECH_CLASSICAL_MILESTONE' , 	'TECH_HORSEBACK_RIDING' ),
('TECH_CLASSICAL_MILESTONE' , 	'TECH_CONSTRUCTION' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_CARTOGRAPHY';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_PRINTING';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_BANKING';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_GUNPOWDER';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_SIEGE_TACTICS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_BUTTRESS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_EDUCATION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_STIRRUPS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_MILITARY_ENGINEERING';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_CARTOGRAPHY' , 			'TECH_MEDIEVAL_MILESTONE' ),
('TECH_PRINTING' , 				'TECH_MEDIEVAL_MILESTONE' ),
('TECH_BANKING' , 				'TECH_MEDIEVAL_MILESTONE' ),
('TECH_GUNPOWDER' , 			'TECH_MEDIEVAL_MILESTONE' ),
('TECH_SIEGE_TACTICS' , 		'TECH_MEDIEVAL_MILESTONE' ),
('TECH_MEDIEVAL_MILESTONE' , 	'TECH_BUTTRESS' ),
('TECH_MEDIEVAL_MILESTONE' , 	'TECH_EDUCATION' ),
('TECH_MEDIEVAL_MILESTONE' , 	'TECH_STIRRUPS' ),
('TECH_MEDIEVAL_MILESTONE' , 	'TECH_MILITARY_ENGINEERING' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_INDUSTRIALIZATION';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_SCIENTIFIC_THEORY';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_RIFLING';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_BALLISTICS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_SQUARE_RIGGING';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_MASS_PRODUCTION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_ASTRONOMY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_METAL_CASTING';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_BANKING';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_INDUSTRIALIZATION' , 		'TECH_RENAISSANCE_MILESTONE' ),
('TECH_SCIENTIFIC_THEORY' , 		'TECH_RENAISSANCE_MILESTONE' ),
('TECH_RIFLING' , 					'TECH_RENAISSANCE_MILESTONE' ),
('TECH_BALLISTICS' , 				'TECH_RENAISSANCE_MILESTONE' ),
('TECH_RENAISSANCE_MILESTONE' , 	'TECH_SQUARE_RIGGING' ),
('TECH_RENAISSANCE_MILESTONE' , 	'TECH_MASS_PRODUCTION' ),
('TECH_RENAISSANCE_MILESTONE' , 	'TECH_ASTRONOMY' ),
('TECH_RENAISSANCE_MILESTONE' , 	'TECH_BANKING' ),
('TECH_RENAISSANCE_MILESTONE' , 	'TECH_METAL_CASTING' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_FLIGHT';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_REFINING';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_REPLACEABLE_PARTS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_STEEL';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_STEAM_POWER';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_SANITATION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_ECONOMICS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_MILITARY_SCIENCE';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_FLIGHT' , 				'TECH_INDUSTRIAL_MILESTONE' ),
('TECH_REFINING' , 				'TECH_INDUSTRIAL_MILESTONE' ),
('TECH_REPLACEABLE_PARTS' , 	'TECH_INDUSTRIAL_MILESTONE' ),
('TECH_STEEL' , 				'TECH_INDUSTRIAL_MILESTONE' ),
('TECH_ELECTRICITY' , 			'TECH_INDUSTRIAL_MILESTONE' ),
('TECH_INDUSTRIAL_MILESTONE' , 	'TECH_STEAM_POWER' ),
('TECH_INDUSTRIAL_MILESTONE' , 	'TECH_SANITATION' ),
('TECH_INDUSTRIAL_MILESTONE' , 	'TECH_ECONOMICS' ),
('TECH_INDUSTRIAL_MILESTONE' , 	'TECH_MILITARY_SCIENCE' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_ADVANCED_FLIGHT';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_ADVANCED_BALLISTICS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_COMBINED_ARMS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_PLASTICS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_ELECTRICITY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_RADIO';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_CHEMISTRY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_COMBUSTION';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_ADVANCED_FLIGHT' , 		'TECH_MODERN_MILESTONE' ),
('TECH_ADVANCED_BALLISTICS' , 	'TECH_MODERN_MILESTONE' ),
('TECH_COMBINED_ARMS' , 		'TECH_MODERN_MILESTONE' ),
('TECH_PLASTICS' , 				'TECH_MODERN_MILESTONE' ),
('TECH_MODERN_MILESTONE' , 		'TECH_ELECTRICITY' ),
('TECH_MODERN_MILESTONE' , 		'TECH_RADIO' ),
('TECH_MODERN_MILESTONE' , 		'TECH_CHEMISTRY' ),
('TECH_MODERN_MILESTONE' , 		'TECH_COMBUSTION' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_TELECOMMUNICATIONS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_SATELLITES';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_GUIDANCE_SYSTEMS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_LASERS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_COMPOSITES';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_COMPUTERS';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_ROCKETRY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_NUCLEAR_FISSION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_SYNTHETIC_MATERIALS';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_TELECOMMUNICATIONS' , 	'TECH_ATOMIC_MILESTONE' ),
('TECH_SATELLITES' , 			'TECH_ATOMIC_MILESTONE' ),
('TECH_GUIDANCE_SYSTEMS' , 		'TECH_ATOMIC_MILESTONE' ),
('TECH_LASERS' , 				'TECH_ATOMIC_MILESTONE' ),
('TECH_COMPOSITES' , 			'TECH_ATOMIC_MILESTONE' ),
('TECH_ATOMIC_MILESTONE' , 		'TECH_COMPUTERS' ),
('TECH_ATOMIC_MILESTONE' , 		'TECH_ROCKETRY' ),
('TECH_ATOMIC_MILESTONE' , 		'TECH_NUCLEAR_FISSION' ),
('TECH_ATOMIC_MILESTONE' , 		'TECH_SYNTHETIC_MATERIALS' );

DELETE FROM TechnologyPrereqs WHERE Technology='TECH_SEASTEADS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_ADVANCED_AI';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_ADVANCED_POWER_CELLS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_CYBERNETICS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_SMART_MATERIALS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_PREDICTIVE_SYSTEMS';
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_OFFWORLD_MISSION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_STEALTH_TECHNOLOGY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_NANOTECHNOLOGY';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_NUCLEAR_FUSION';
DELETE FROM TechnologyPrereqs WHERE PrereqTech='TECH_ROBOTICS';
INSERT OR REPLACE INTO TechnologyPrereqs
(Technology , 					PrereqTech) VALUES
('TECH_SEASTEADS' , 				'TECH_INFORMATION_MILESTONE' ),
('TECH_ADVANCED_AI' , 				'TECH_INFORMATION_MILESTONE' ),
('TECH_ADVANCED_POWER_CELLS' , 		'TECH_INFORMATION_MILESTONE' ),
('TECH_CYBERNETICS' , 				'TECH_INFORMATION_MILESTONE' ),
('TECH_SMART_MATERIALS' , 			'TECH_INFORMATION_MILESTONE' ),
('TECH_PREDICTIVE_SYSTEMS' , 		'TECH_INFORMATION_MILESTONE' ),
('TECH_OFFWORLD_MISSION' , 			'TECH_INFORMATION_MILESTONE' ),
('TECH_INFORMATION_MILESTONE' , 	'TECH_STEALTH_TECHNOLOGY' ),
('TECH_INFORMATION_MILESTONE' , 	'TECH_NANOTECHNOLOGY' ),
('TECH_INFORMATION_MILESTONE' , 	'TECH_NUCLEAR_FUSION' ),
('TECH_INFORMATION_MILESTONE' , 	'TECH_ROBOTICS' );

--CivicPrereqs
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_GAMES_RECREATION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_POLITICAL_PHILOSOPHY';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_DRAMA_POETRY';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_MILITARY_TRADITION';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_STATE_WORKFORCE';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_EARLY_EMPIRE';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_MYSTICISM';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_GAMES_RECREATION' , 	'CIVIC_ANCIENT_MILESTONE' ),
('CIVIC_POLITICAL_PHILOSOPHY' , 'CIVIC_ANCIENT_MILESTONE' ),
('CIVIC_DRAMA_POETRY' , 		'CIVIC_ANCIENT_MILESTONE' ),
('CIVIC_ANCIENT_MILESTONE' , 	'CIVIC_MILITARY_TRADITION' ),
('CIVIC_ANCIENT_MILESTONE' , 	'CIVIC_STATE_WORKFORCE' ),
('CIVIC_ANCIENT_MILESTONE' , 	'CIVIC_EARLY_EMPIRE' ),
('CIVIC_ANCIENT_MILESTONE' , 	'CIVIC_MYSTICISM' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_NAVAL_TRADITION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_FEUDALISM';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_CIVIL_SERVICE';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_MILITARY_TRAINING';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_DEFENSIVE_TACTICS';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_RECORDED_HISTORY';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_THEOLOGY';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_NAVAL_TRADITION' , 		'CIVIC_CLASSICAL_MILESTONE' ),
('CIVIC_FEUDALISM' , 			'CIVIC_CLASSICAL_MILESTONE' ),
('CIVIC_CIVIL_SERVICE' , 		'CIVIC_CLASSICAL_MILESTONE' ),
('CIVIC_CLASSICAL_MILESTONE' , 	'CIVIC_MILITARY_TRAINING' ),
('CIVIC_CLASSICAL_MILESTONE' , 	'CIVIC_DEFENSIVE_TACTICS' ),
('CIVIC_CLASSICAL_MILESTONE' , 	'CIVIC_RECORDED_HISTORY' ),
('CIVIC_CLASSICAL_MILESTONE' , 	'CIVIC_THEOLOGY' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_EXPLORATION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_HUMANISM';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_DIVINE_RIGHT';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_DIPLOMATIC_SERVICE';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_REFORMED_CHURCH';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_MEDIEVAL_FAIRES';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_MERCENARIES';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_GUILDS';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_EXPLORATION' , 			'CIVIC_MEDIEVAL_MILESTONE' ),
('CIVIC_HUMANISM' , 			'CIVIC_MEDIEVAL_MILESTONE' ),
('CIVIC_DIVINE_RIGHT' , 		'CIVIC_MEDIEVAL_MILESTONE' ),
('CIVIC_DIPLOMATIC_SERVICE' , 	'CIVIC_MEDIEVAL_MILESTONE' ),
('CIVIC_REFORMED_CHURCH' , 		'CIVIC_MEDIEVAL_MILESTONE' ),
('CIVIC_MEDIEVAL_MILESTONE' , 	'CIVIC_MEDIEVAL_FAIRES' ),
('CIVIC_MEDIEVAL_MILESTONE' , 	'CIVIC_MERCENARIES' ),
('CIVIC_MEDIEVAL_MILESTONE' , 	'CIVIC_GUILDS' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_COLONIALISM';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_CIVIL_ENGINEERING';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_NATIONALISM';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_OPERA_BALLET';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_MERCANTILISM';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_THE_ENLIGHTENMENT';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_COLONIALISM' , 				'CIVIC_RENAISSANCE_MILESTONE' ),
('CIVIC_CIVIL_ENGINEERING' , 		'CIVIC_RENAISSANCE_MILESTONE' ),
('CIVIC_NATIONALISM' , 				'CIVIC_RENAISSANCE_MILESTONE' ),
('CIVIC_OPERA_BALLET' , 			'CIVIC_RENAISSANCE_MILESTONE' ),
('CIVIC_RENAISSANCE_MILESTONE' , 	'CIVIC_MERCANTILISM' ),
('CIVIC_RENAISSANCE_MILESTONE' , 	'CIVIC_THE_ENLIGHTENMENT' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_CONSERVATION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_MASS_MEDIA';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_MOBILIZATION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_IDEOLOGY';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_NATURAL_HISTORY';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_SCORCHED_EARTH';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_URBANIZATION';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_CONSERVATION' , 		'CIVIC_INDUSTRIAL_MILESTONE' ),
('CIVIC_MASS_MEDIA' , 			'CIVIC_INDUSTRIAL_MILESTONE' ),
('CIVIC_MOBILIZATION' , 		'CIVIC_INDUSTRIAL_MILESTONE' ),
('CIVIC_IDEOLOGY' , 			'CIVIC_INDUSTRIAL_MILESTONE' ),
('CIVIC_INDUSTRIAL_MILESTONE' , 	'CIVIC_NATURAL_HISTORY' ),
('CIVIC_INDUSTRIAL_MILESTONE' , 	'CIVIC_OPERA_BALLET' ),
('CIVIC_INDUSTRIAL_MILESTONE' , 	'CIVIC_SCORCHED_EARTH' ),
('CIVIC_INDUSTRIAL_MILESTONE' , 	'CIVIC_URBANIZATION' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_CULTURAL_HERITAGE';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_COLD_WAR';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_PROFESSIONAL_SPORTS';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_CONSERVATION';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_NUCLEAR_PROGRAM';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_CAPITALISM';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_CULTURAL_HERITAGE' , 	'CIVIC_MODERN_MILESTONE' ),
('CIVIC_COLD_WAR' , 			'CIVIC_MODERN_MILESTONE' ),
('CIVIC_PROFESSIONAL_SPORTS' , 	'CIVIC_MODERN_MILESTONE' ),
('CIVIC_MODERN_MILESTONE' , 	'CIVIC_CONSERVATION' ),
('CIVIC_MODERN_MILESTONE' , 	'CIVIC_NUCLEAR_PROGRAM' ),
('CIVIC_MODERN_MILESTONE' , 	'CIVIC_CAPITALISM' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_GLOBALIZATION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_SOCIAL_MEDIA';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_ENVIRONMENTALISM';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_CULTURAL_HERITAGE';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_RAPID_DEPLOYMENT';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_SPACE_RACE';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_PROFESSIONAL_SPORTS';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_GLOBALIZATION' , 		'CIVIC_ATOMIC_MILESTONE' ),
('CIVIC_SOCIAL_MEDIA' , 		'CIVIC_ATOMIC_MILESTONE' ),
('CIVIC_ENVIRONMENTALISM' , 	'CIVIC_ATOMIC_MILESTONE' ),
('CIVIC_ATOMIC_MILESTONE' , 	'CIVIC_CULTURAL_HERITAGE' ),
('CIVIC_ATOMIC_MILESTONE' , 	'CIVIC_RAPID_DEPLOYMENT' ),
('CIVIC_ATOMIC_MILESTONE' , 	'CIVIC_SPACE_RACE' ),
('CIVIC_ATOMIC_MILESTONE' , 	'CIVIC_PROFESSIONAL_SPORTS' );

DELETE FROM CivicPrereqs WHERE Civic='CIVIC_GLOBAL_WARMING_MITIGATION';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_SMART_POWER_DOCTRINE';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_INFORMATION_WARFARE';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_EXODUS_IMPERATIVE';
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_CULTURAL_HEGEMONY';
DELETE FROM CivicPrereqs WHERE PrereqCivic='CIVIC_NEAR_FUTURE_GOVERNANCE';
INSERT OR REPLACE INTO CivicPrereqs
(Civic , 					PrereqCivic) VALUES
('CIVIC_GLOBAL_WARMING_MITIGATION' , 	'CIVIC_INFORMATION_MILESTONE' ),
('CIVIC_SMART_POWER_DOCTRINE' , 		'CIVIC_INFORMATION_MILESTONE' ),
('CIVIC_INFORMATION_WARFARE' , 			'CIVIC_INFORMATION_MILESTONE' ),
('CIVIC_EXODUS_IMPERATIVE' , 			'CIVIC_INFORMATION_MILESTONE' ),
('CIVIC_CULTURAL_HEGEMONY' , 			'CIVIC_INFORMATION_MILESTONE' ),
('CIVIC_INFORMATION_MILESTONE' , 		'CIVIC_NEAR_FUTURE_GOVERNANCE' );

--TechnologyModifiers
INSERT OR REPLACE INTO TechnologyModifiers (TechnologyType,					ModifierId) VALUES	
('TECH_ANCIENT_MILESTONE',		'GA_TECH_ANCIENT_MILESTONE_SCIENCE'),
('TECH_CLASSICAL_MILESTONE',	'GA_TECH_CLASSICAL_MILESTONE_SCIENCE'),
('TECH_MEDIEVAL_MILESTONE',		'GA_TECH_MEDIEVAL_MILESTONE_SCIENCE'),
('TECH_RENAISSANCE_MILESTONE',	'GA_TECH_RENAISSANCE_MILESTONE_SCIENCE'),
('TECH_INDUSTRIAL_MILESTONE',	'GA_TECH_INDUSTRIAL_MILESTONE_SCIENCE'),
('TECH_MODERN_MILESTONE',		'GA_TECH_MODERN_MILESTONE_SCIENCE'),
('TECH_ATOMIC_MILESTONE',		'GA_TECH_ATOMIC_MILESTONE_SCIENCE'),
('TECH_INFORMATION_MILESTONE',	'GA_TECH_INFORMATION_MILESTONE_SCIENCE');

INSERT OR REPLACE INTO Modifiers 
(ModifierId,								        ModifierType) 
SELECT	ModifierId,	            'MODIFIER_PLAYER_GRANT_YIELD' 	FROM TechnologyModifiers WHERE ModifierId LIKE '%_MILESTONE_SCIENCE'; 

INSERT OR REPLACE INTO ModifierArguments
       (ModifierId , Name , Value)
SELECT ModifierId , 'YieldType' , 'YIELD_SCIENCE' FROM TechnologyModifiers WHERE ModifierId LIKE '%_MILESTONE_SCIENCE'; 
INSERT OR REPLACE INTO ModifierArguments
       (ModifierId , Name , Value)
SELECT ModifierId , 'Scale' , 1 FROM TechnologyModifiers WHERE ModifierId LIKE '%_MILESTONE_SCIENCE'; 

INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_ANCIENT_MILESTONE_SCIENCE',	    	'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_ANCIENT_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_CLASSICAL_MILESTONE_SCIENCE',	    'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_CLASSICAL_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_MEDIEVAL_MILESTONE_SCIENCE',	    'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_MEDIEVAL_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_RENAISSANCE_MILESTONE_SCIENCE',	    'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_RENAISSANCE_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_INDUSTRIAL_MILESTONE_SCIENCE',	    'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_INDUSTRIAL_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_MODERN_MILESTONE_SCIENCE',	    	'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_MODERN_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_ATOMIC_MILESTONE_SCIENCE',	    	'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_ATOMIC_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_TECH_INFORMATION_MILESTONE_SCIENCE',	    'Amount',	    Cost FROM Technologies WHERE TechnologyType='TECH_INFORMATION_MILESTONE';

--CivicModifiers
INSERT OR REPLACE INTO CivicModifiers (CivicType,					ModifierId) VALUES	
('CIVIC_ANCIENT_MILESTONE',		'GA_CIVIC_ANCIENT_MILESTONE_CULTURE'),
('CIVIC_CLASSICAL_MILESTONE',	'GA_CIVIC_CLASSICAL_MILESTONE_CULTURE'),
('CIVIC_MEDIEVAL_MILESTONE',	'GA_CIVIC_MEDIEVAL_MILESTONE_CULTURE'),
('CIVIC_RENAISSANCE_MILESTONE',	'GA_CIVIC_RENAISSANCE_MILESTONE_CULTURE'),
('CIVIC_INDUSTRIAL_MILESTONE',	'GA_CIVIC_INDUSTRIAL_MILESTONE_CULTURE'),
('CIVIC_MODERN_MILESTONE',		'GA_CIVIC_MODERN_MILESTONE_CULTURE'),
('CIVIC_ATOMIC_MILESTONE',		'GA_CIVIC_ATOMIC_MILESTONE_CULTURE'),
('CIVIC_INFORMATION_MILESTONE',	'GA_CIVIC_INFORMATION_MILESTONE_CULTURE');

INSERT OR REPLACE INTO Modifiers 
(ModifierId,								        ModifierType) 
SELECT	ModifierId,	            'MODIFIER_PLAYER_GRANT_YIELD' 	FROM CivicModifiers WHERE ModifierId LIKE '%_MILESTONE_CULTURE'; 

INSERT OR REPLACE INTO ModifierArguments
       (ModifierId , Name , Value)
SELECT ModifierId , 'YieldType' , 'YIELD_CULTURE' FROM CivicModifiers WHERE ModifierId LIKE '%_MILESTONE_CULTURE'; 
INSERT OR REPLACE INTO ModifierArguments
       (ModifierId , Name , Value)
SELECT ModifierId , 'Scale' , 1 FROM CivicModifiers WHERE ModifierId LIKE '%_MILESTONE_CULTURE'; 

INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_ANCIENT_MILESTONE_CULTURE',	    'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_ANCIENT_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_CLASSICAL_MILESTONE_CULTURE',	    'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_CLASSICAL_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_MEDIEVAL_MILESTONE_CULTURE',	    'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_MEDIEVAL_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_RENAISSANCE_MILESTONE_CULTURE',	'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_RENAISSANCE_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_INDUSTRIAL_MILESTONE_CULTURE',	    'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_INDUSTRIAL_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_MODERN_MILESTONE_CULTURE',	    	'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_MODERN_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_ATOMIC_MILESTONE_CULTURE',	    	'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_ATOMIC_MILESTONE';
INSERT OR REPLACE INTO ModifierArguments 
(ModifierId,							            Name,		    Value) 
SELECT 'GA_CIVIC_INFORMATION_MILESTONE_CULTURE',	'Amount',	    Cost FROM Civics WHERE CivicType='CIVIC_INFORMATION_MILESTONE';