--==========================================================================================================================
-- MORE UNIQUE COMPONENTS FOR VP (NEW)
--==========================================================================================================================
-- Units
------------------------------
UPDATE Units SET MinorCivGift = 0, Class = 'UNITCLASS_CUIRASSIER' WHERE Type = 'UNIT_JFD_DEATHS_HEAD' AND EXISTS (SELECT * FROM Buildings WHERE Type ='BUILDING_GERMANY_TEUTONIC_ORDER');
--------------------------------
-- Civilization_UnitClassOverrides
--------------------------------
INSERT INTO Civilization_UnitClassOverrides
(CivilizationType, UnitClassType, UnitType)
SELECT 'CIVILIZATION_JFD_PRUSSIA', 'UNITCLASS_CUIRASSIER', 'UNIT_JFD_DEATHS_HEAD'
WHERE EXISTS (SELECT * FROM Buildings WHERE Type = 'BUILDING_GERMANY_TEUTONIC_ORDER');
--------------------------------
-- Civilization_BuildingClassOverrides
--------------------------------
INSERT INTO Civilization_BuildingClassOverrides
(CivilizationType, BuildingClassType, BuildingType)
SELECT 'CIVILIZATION_JFD_PRUSSIA', 'BUILDINGCLASS_MINT', 'BUILDING_HANSE'
WHERE EXISTS (SELECT * FROM Buildings WHERE Type = 'BUILDING_GERMANY_TEUTONIC_ORDER');
--------------------------------
-- Trigger for the above three (mysterious load order issues)
--------------------------------
CREATE TRIGGER JFDPrussiaForVP_4UC
AFTER INSERT ON Buildings
WHEN NEW.Type = 'BUILDING_GERMANY_TEUTONIC_ORDER'
BEGIN
UPDATE Units SET MinorCivGift = 0, Class = 'UNITCLASS_CUIRASSIER' WHERE Type = 'UNIT_JFD_DEATHS_HEAD';
INSERT INTO Civilization_UnitClassOverrides
(CivilizationType, UnitClassType, UnitType)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'UNITCLASS_CUIRASSIER', 'UNIT_JFD_DEATHS_HEAD');
INSERT INTO Civilization_BuildingClassOverrides
(CivilizationType, BuildingClassType, BuildingType)
VALUES ('CIVILIZATION_JFD_PRUSSIA', 'BUILDINGCLASS_MINT', 'BUILDING_HANSE');
END;