memes

CREATE TABLE IF NOT EXISTS
    District_TLA_INCONTROL_UA_DistrictPairings (
        District TEXT,
        YieldType TEXT,
        Amount TEXT );

INSERT INTO District_TLA_INCONTROL_UA_DistrictPairings
        ( District,                     YieldType,              Amount )
VALUES  ('CITY_CENTER',                 'YIELD_FOOD',           '2' ),
        ('AQUEDUCT',                    'YIELD_FOOD',           '2' ),
        ('HOLY_SITE',                   'YIELD_FAITH',          '2' ),
        ('CAMPUS',                      'YIELD_SCIENCE',        '2' ),

        ('HARBOR',                      'YIELD_GOLD',           '2' ),
        ('COMMERCIAL_HUB',              'YIELD_GOLD',           '2' ),

        ('INDUSTRIAL_ZONE',             'YIELD_PRODUCTION',     '2' ),
        ('THEATER',                     'YIELD_CULTURE',        '2' );



INSERT INTO TraitModifiers
        (TraitType,                             ModifierId)
SELECT  'TRAIT_CIVILIZATION_TLA_INCONTROL_UA',  'MODIFIER_TLA_INCONTROL_UA_PASTURES_'||District
        FROM District_TLA_INCONTROL_UA_DistrictPairings;


INSERT INTO ModifierArguments
        (ModifierId,                                        Name,               VALUE)
SELECT  'MODIFIER_TLA_INCONTROL_UA_PASTURES_'||District,    'Amount',           Amount
        FROM District_TLA_INCONTROL_UA_DistrictPairings ;


INSERT INTO ModifierArguments
        (ModifierId,                                        Name,               VALUE)
SELECT  'MODIFIER_TLA_INCONTROL_UA_PASTURES_'||District,    'YieldType',        YieldType
        FROM District_TLA_INCONTROL_UA_DistrictPairings ;

DROP TABLE District_TLA_INCONTROL_UA_DistrictPairings;