Pingala.sql

INSERT OR IGNORE INTO Types (Type, Kind) VALUES
	('GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'KIND_GOVERNOR_PROMOTION');
INSERT OR IGNORE INTO GovernorPromotions (GovernorPromotionType, Name, Description, Level, Column, BaseAbility) VALUES
	('GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'LOC_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE_NAME', 'LOC_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE_DESCRIPTION', 3, 2, 0);
INSERT OR IGNORE INTO GovernorPromotionSets (GovernorType, GovernorPromotion) VALUES
	('GOVERNOR_THE_EDUCATOR', 'GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE');
INSERT OR IGNORE INTO GovernorPromotionPrereqs ( GovernorPromotionType, PrereqGovernorPromotion ) VALUES
	( 'GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'GOVERNOR_PROMOTION_EDUCATOR_GRANTS' );
	
INSERT OR IGNORE INTO Requirements (RequirementId, RequirementType)
	VALUES ('REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'REQUIREMENT_CITY_HAS_SPECIFIC_GOVERNOR_PROMOTION_TYPE');
INSERT OR IGNORE INTO RequirementArguments (RequirementId, Name, Value) VALUES
	('REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'Established', 1),
	('REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'GovernorPromotionType', 'GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE');
INSERT OR IGNORE INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
	('EDUCATOR_CAMPUS_CULTURE_REQUIREMENT', 'REQUIREMENTSET_TEST_ALL'),
	('EDUCATOR_THEATRE_SCIENCE_REQUIREMENT', 'REQUIREMENTSET_TEST_ALL');
INSERT OR IGNORE INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
	('EDUCATOR_CAMPUS_CULTURE_REQUIREMENT', 'REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE'),
	('EDUCATOR_CAMPUS_CULTURE_REQUIREMENT', 'REQUIRES_DISTRICT_IS_CAMPUS'),
	('EDUCATOR_THEATRE_SCIENCE_REQUIREMENT', 'REQUIRES_CITY_HAS_GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE'),
	('EDUCATOR_THEATRE_SCIENCE_REQUIREMENT', 'REQUIRES_DISTRICT_IS_THEATER');

INSERT OR IGNORE INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId) VALUES
	('EDUCATOR_CAMPUS_CULTURE', 'MODIFIER_ALL_DISTRICTS_ADJUST_YIELD_BASED_ON_ADJACENCY_BONUS', 'EDUCATOR_CAMPUS_CULTURE_REQUIREMENT'),
	('EDUCATOR_THEATRE_SCIENCE', 'MODIFIER_ALL_DISTRICTS_ADJUST_YIELD_BASED_ON_ADJACENCY_BONUS', 'EDUCATOR_THEATRE_SCIENCE_REQUIREMENT');
INSERT OR IGNORE INTO ModifierArguments (ModifierId, Name, Value) VALUES
	('EDUCATOR_CAMPUS_CULTURE' , 'YieldTypeToMirror' , 'YIELD_SCIENCE'),
	('EDUCATOR_CAMPUS_CULTURE' , 'YieldTypeToGrant' , 'YIELD_CULTURE'),
	('EDUCATOR_THEATRE_SCIENCE' , 'YieldTypeToMirror' , 'YIELD_CULTURE'),
	('EDUCATOR_THEATRE_SCIENCE' , 'YieldTypeToGrant' , 'YIELD_SCIENCE');
	
INSERT OR IGNORE INTO GovernorPromotionModifiers (GovernorPromotionType, ModifierId) VALUES
	('GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'EDUCATOR_CAMPUS_CULTURE'),
	('GOVERNOR_PROMOTION_EDUCATOR_CAMPUS_THEATRE', 'EDUCATOR_THEATRE_SCIENCE');

UPDATE GovernorPromotions SET Column = 4 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_EDUCATOR_SPACE_INITIATIVE';
UPDATE GovernorPromotions SET Column = 1 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_EDUCATOR_CONNOISSEUR';
UPDATE GovernorPromotions SET Column = 3 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_EDUCATOR_RESEARCHER';
UPDATE GovernorPromotions SET Column = 2 WHERE GovernorPromotionType = 'GOVERNOR_PROMOTION_EDUCATOR_GRANTS';