INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_1_ATTACH'),
--('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_2_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_3_ATTACH'),
--('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_4_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_5_ATTACH'),
--('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_6_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_7_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-1_ATTACH'),
--('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-2_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-3_ATTACH'),
--('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-4_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-5_ATTACH'),
--('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-6_ATTACH'),
('DISTRICT_CITY_CENTER','MODIFIER_CSL_LOYALTY_-7_ATTACH');
INSERT INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId, OwnerRequirementSetId) VALUES
('MODIFIER_CSL_LOYALTY_1_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_10', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_2_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_9', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_3_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_8', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_4_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_7', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_5_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_6', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_6_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_5', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_7_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_4', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-1_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_10', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-2_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_9', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-3_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_8', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-4_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_7', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-5_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_6', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-6_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_5', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_-7_ATTACH', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_4', 'PLAYER_IS_MINOR'),
('MODIFIER_CSL_LOYALTY_1', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_2', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_3', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_4', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_5', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_6', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_7', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-1', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-2', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-3', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-4', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-5', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-6', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL),
('MODIFIER_CSL_LOYALTY_-7', 'MODIFIER_SINGLE_CITY_ADJUST_IDENTITY_PER_TURN', NULL, NULL);
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES
('MODIFIER_CSL_LOYALTY_1_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_1'),
('MODIFIER_CSL_LOYALTY_2_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_2'),
('MODIFIER_CSL_LOYALTY_3_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_3'),
('MODIFIER_CSL_LOYALTY_4_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_4'),
('MODIFIER_CSL_LOYALTY_5_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_5'),
('MODIFIER_CSL_LOYALTY_6_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_6'),
('MODIFIER_CSL_LOYALTY_7_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_7'),
('MODIFIER_CSL_LOYALTY_-1_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-1'),
('MODIFIER_CSL_LOYALTY_-2_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-2'),
('MODIFIER_CSL_LOYALTY_-3_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-3'),
('MODIFIER_CSL_LOYALTY_-4_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-4'),
('MODIFIER_CSL_LOYALTY_-5_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-5'),
('MODIFIER_CSL_LOYALTY_-6_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-6'),
('MODIFIER_CSL_LOYALTY_-7_ATTACH', 'ModifierId', 'MODIFIER_CSL_LOYALTY_-7'),
('MODIFIER_CSL_LOYALTY_1', 'Amount', '1'),
('MODIFIER_CSL_LOYALTY_2', 'Amount', '2'),
('MODIFIER_CSL_LOYALTY_3', 'Amount', '2'),
('MODIFIER_CSL_LOYALTY_4', 'Amount', '4'),
('MODIFIER_CSL_LOYALTY_5', 'Amount', '3'),
('MODIFIER_CSL_LOYALTY_6', 'Amount', '6'),
('MODIFIER_CSL_LOYALTY_7', 'Amount', '4'),
('MODIFIER_CSL_LOYALTY_-1', 'Amount', '-1'),
('MODIFIER_CSL_LOYALTY_-2', 'Amount', '-2'),
('MODIFIER_CSL_LOYALTY_-3', 'Amount', '-2'),
('MODIFIER_CSL_LOYALTY_-4', 'Amount', '-4'),
('MODIFIER_CSL_LOYALTY_-5', 'Amount', '-3'),
('MODIFIER_CSL_LOYALTY_-6', 'Amount', '-6'),
('MODIFIER_CSL_LOYALTY_-7', 'Amount', '-4');
INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_10', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_9', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_8', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_7', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_6', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_5', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_4', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_10', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_9', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_8', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_7', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_6', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_5', 'REQUIREMENTSET_TEST_ALL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_4', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_10', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_9', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_8', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_7', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_6', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_5', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_4', 'REQUIRES_PLAYER_IS_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_10', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_9', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_8', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_7', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_6', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_5', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_4', 'REQUIRES_PLAYER_IS_NOT_SUZERAIN'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_10', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_9', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_8', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_7', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_6', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_5', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_4', 'REQUIRES_PLAYER_IS_MAJOR_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_10', 'REQUIRES_CITY_WITHIN_10_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_9', 'REQUIRES_CITY_WITHIN_9_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_8', 'REQUIRES_CITY_WITHIN_8_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_7', 'REQUIRES_CITY_WITHIN_7_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_6', 'REQUIRES_CITY_WITHIN_6_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_5', 'REQUIRES_CITY_WITHIN_5_CSL'),
('REQ_PLAYER_IS_SUZERAIN_AND_WITHIN_4', 'REQUIRES_CITY_WITHIN_4_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_10', 'REQUIRES_CITY_WITHIN_10_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_9', 'REQUIRES_CITY_WITHIN_9_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_8', 'REQUIRES_CITY_WITHIN_8_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_7', 'REQUIRES_CITY_WITHIN_7_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_6', 'REQUIRES_CITY_WITHIN_6_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_5', 'REQUIRES_CITY_WITHIN_5_CSL'),
('REQ_PLAYER_IS_NOT_SUZERAIN_AND_WITHIN_4', 'REQUIRES_CITY_WITHIN_4_CSL');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES
('REQUIRES_CITY_WITHIN_10_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_CITY_WITHIN_9_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_CITY_WITHIN_8_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_CITY_WITHIN_7_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_CITY_WITHIN_6_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_CITY_WITHIN_5_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_CITY_WITHIN_4_CSL', 'REQUIREMENT_PLOT_ADJACENT_TO_OWNER'),
('REQUIRES_PLAYER_IS_MAJOR_CSL', 'REQUIREMENT_PLAYER_IS_MAJOR');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES
('REQUIRES_CITY_WITHIN_10_CSL', 'MaxDistance', '10'),
('REQUIRES_CITY_WITHIN_9_CSL', 'MaxDistance', '9'),
('REQUIRES_CITY_WITHIN_8_CSL', 'MaxDistance', '8'),
('REQUIRES_CITY_WITHIN_7_CSL', 'MaxDistance', '7'),
('REQUIRES_CITY_WITHIN_6_CSL', 'MaxDistance', '6'),
('REQUIRES_CITY_WITHIN_5_CSL', 'MaxDistance', '5'),
('REQUIRES_CITY_WITHIN_4_CSL', 'MaxDistance', '4'),
('REQUIRES_CITY_WITHIN_10_CSL', 'MinDistance', '9'),
('REQUIRES_CITY_WITHIN_9_CSL', 'MinDistance', '9'),
('REQUIRES_CITY_WITHIN_8_CSL', 'MinDistance', '7'),
('REQUIRES_CITY_WITHIN_7_CSL', 'MinDistance', '7'),
('REQUIRES_CITY_WITHIN_6_CSL', 'MinDistance', '5'),
('REQUIRES_CITY_WITHIN_5_CSL', 'MinDistance', '5'),
('REQUIRES_CITY_WITHIN_4_CSL', 'MinDistance', '4');