Example Enlightenment Era Support

UPDATE Units
SET Class = 'UNITCLASS_EE_SKIRMISHER'
WHERE TYPE = 'UNIT_MC_MEXICAN_ZAPATISTA'
AND EXISTS (SELECT * FROM Units WHERE TYPE = 'UNIT_EE_SKIRMISHER');

UPDATE Civilization_UnitClassOverrides
SET UnitClassType = 'UNITCLASS_EE_SKIRMISHER'
WHERE UnitType = 'UNIT_MC_MEXICAN_ZAPATISTA'
AND EXISTS (SELECT * FROM Units WHERE TYPE = 'UNIT_EE_SKIRMISHER');