INSERT INTO Types
(Type, Kind )
VALUES ('TRAIT_CIVILIZATION_TEST1', 'KIND_TRAIT' );
INSERT INTO Traits
(TraitType, Name, Description )
VALUES ('TRAIT_CIVILIZATION_TEST1', 'Making units cheaper', 'Makes all unit purchasing 25% Cheaper.' );
INSERT INTO CivilizationTraits
(CivilizationType, TraitType)
VALUES ('CIVILIZATION_THELUNARARMYS_CIV', 'TRAIT_CIVILIZATION_TEST1');
INSERT INTO Modifiers
(ModifierId, ModifierType)
SELECT 'TRAIT_CHEAPER_' || UnitType, 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_PURCHASE_COST'
FROM (SELECT * FROM Units WHERE (FormationClass LIKE "%_COMBAT") AND (TraitType IS NULL) AND (PurchaseYield LIKE "%_GOLD"));
INSERT INTO TraitModifiers
(TraitType, ModifierId)
SELECT 'TRAIT_CIVILIZATION_TEST1','TRAIT_CHEAPER_' || UnitType
FROM (SELECT * FROM Units WHERE (FormationClass LIKE "%_COMBAT") AND (TraitType IS NULL) AND (PurchaseYield LIKE "%_GOLD"));
INSERT INTO ModifierArguments
(ModifierId, Name, Type, Value)
SELECT 'TRAIT_CHEAPER_' || UnitType, 'UnitType', 'ARGTYPE_IDENTITY', UnitType
FROM (SELECT * FROM Units WHERE (FormationClass LIKE "%_COMBAT") AND (TraitType IS NULL) AND (PurchaseYield LIKE "%_GOLD"));
INSERT INTO ModifierArguments
(ModifierId, Name, Type, Value)
SELECT 'TRAIT_CHEAPER_' || UnitType, 'Amount', 'ARGTYPE_IDENTITY', '25'
FROM (SELECT * FROM Units WHERE (FormationClass LIKE "%_COMBAT") AND (TraitType IS NULL) AND (PurchaseYield LIKE "%_GOLD"));