Hi, have managed to use Tokugawa's UA for a mod I am making, it gives domestic trade routes additional yields for domestic routes depending on how many districts each city has (and reduces yields for overseas routes). SQL code for the Leader_UA.sql is (I previously defined the trait type as 'WE_STAND_ALONE', you will need to define your own trait type):
INSERT INTO TraitModifiers
(TraitType, ModifierId )
VALUES ('TRAIT_LEADER_WE_STAND_ALONE', 'TRAIT_COMBAT_BONUS_HOME_CONTINENT' ),
('TRAIT_LEADER_WE_STAND_ALONE', 'TOKUGAWA_NEGATIVE_INTERNATIONAL_TOURISM' ),
('TRAIT_LEADER_WE_STAND_ALONE', 'TOKUGAWA_NEGATIVE_INTERNATIONAL_YIELDS' ),
('TRAIT_LEADER_WE_STAND_ALONE', 'TOKUGAWA_POSITIVE_DOMESTIC_CULTURE_DISTRICTS' ),
('TRAIT_LEADER_WE_STAND_ALONE', 'TOKUGAWA_POSITIVE_DOMESTIC_SCIENCE_DISTRICTS' ),
('TRAIT_LEADER_WE_STAND_ALONE', 'TOKUGAWA_POSITIVE_DOMESTIC_GOLD_DISTRICTS' ),
('TRAIT_LEADER_WE_STAND_ALONE', 'TOKUGAWA_TOURISM_DISTRICTS' );
-----------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementsSetId )
VALUES ('TRAIT_COMBAT_BONUS_HOME_CONTINENT', 'MODIFIER_PLAYER_UNITS_GRANT_ABILITY' ),
('TOKUGAWA_NEGATIVE_INTERNATIONAL_TOURISM', 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_TOURISM_MODIFIER' ),
('TOKUGAWA_NEGATIVE_INTERNATIONAL_YIELDS', 'MODIFIER_PLAYER_ADJUST_INTERNATIONAL_TRADE_ROUTE_YIELD_MODIFIER_WARLORDS' ),
('TOKUGAWA_POSITIVE_DOMESTIC_CULTURE_DISTRICTS', 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_YIELD_PER_SPECIALTY_DISTRICT_FOR_DOMESTIC' ),
('TOKUGAWA_POSITIVE_DOMESTIC_SCIENCE_DISTRICTS', 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_YIELD_PER_SPECIALTY_DISTRICT_FOR_DOMESTIC' ),
('TOKUGAWA_POSITIVE_DOMESTIC_GOLD_DISTRICTS', 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_YIELD_PER_SPECIALTY_DISTRICT_FOR_DOMESTIC' ),
('TOKUGAWA_TOURISM_DISTRICTS', 'MODIFIER_PLAYER_DISTRICTS_ADJUST_TOURISM_CHANGE', 'PLAYER_HAS_FLIGHT_GREATWARLORDS' );
-----------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value )
VALUES ('TRAIT_COMBAT_BONUS_HOME_CONTINENT', 'Amount', '5' ),
('TOKUGAWA_NEGATIVE_INTERNATIONAL_TOURISM', 'Amount', '-25' ),
('TOKUGAWA_NEGATIVE_INTERNATIONAL_YIELDS', 'YieldType', 'YIELD_PRODUCTION, YIELD_FOOD, YIELD_SCIENCE, YIELD_CULTURE, YIELD_GOLD, YIELD_FAITH' ),
('TOKUGAWA_NEGATIVE_INTERNATIONAL_YIELDS', 'Amount', '-25, -25, -25, -25, -25, -25' ),
('TOKUGAWA_POSITIVE_DOMESTIC_CULTURE_DISTRICTS', 'YieldType', 'YIELD_CULTURE' ),
('TOKUGAWA_POSITIVE_DOMESTIC_CULTURE_DISTRICTS', 'Amount', '1' ),
('TOKUGAWA_POSITIVE_DOMESTIC_SCIENCE_DISTRICTS', 'YieldType', 'YIELD_SCIENCE' ),
('TOKUGAWA_POSITIVE_DOMESTIC_SCIENCE_DISTRICTS', 'Amount', '1' ),
('TOKUGAWA_POSITIVE_DOMESTIC_GOLD_DISTRICTS', 'YieldType', 'YIELD_GOLD' ),
('TOKUGAWA_POSITIVE_DOMESTIC_GOLD_DISTRICTS', 'Amount', '2' ),
('TOKUGAWA_TOURISM_DISTRICTS', 'Amount', '1' );