UPDATE Units
SET
Domain = (SELECT Domain FROM Units WHERE Type = 'UNIT_CRUISER'),
CombatClass = (SELECT CombatClass FROM Units WHERE Type = 'UNIT_CRUISER'),
IsMounted = (SELECT IsMounted FROM Units WHERE Type = 'UNIT_CRUISER'),
DefaultUnitAI = (SELECT DefaultUnitAI FROM Units WHERE Type = 'UNIT_CRUISER'),
Special = (SELECT Special FROM Units WHERE Type = 'UNIT_CRUISER'),
PrereqTech = (SELECT PrereqTech FROM Units WHERE Type = 'UNIT_CRUISER'),
-- UUs always obsolete at the same time as their upgrade unit
-- If you want to be extra compatible (even if VP changes what Cruiser upgrades into), you can use more complicated SQL for that
ObsoleteTech = (SELECT Domain FROM Units WHERE Type = 'UNIT_BATTLESHIP'),
MoveRate = (SELECT MoveRate FROM Units WHERE Type = 'UNIT_CRUISER'),
Moves = (SELECT Moves FROM Units WHERE Type = 'UNIT_CRUISER'),
BaseSightRange = (SELECT BaseSightRange FROM Units WHERE Type = 'UNIT_CRUISER'),
Combat = (SELECT Combat FROM Units WHERE Type = 'UNIT_CRUISER') + 3,
RangedCombat = (SELECT RangedCombat FROM Units WHERE Type = 'UNIT_CRUISER') + 5,
"Range" = (SELECT "Range" FROM Units WHERE Type = 'UNIT_CRUISER'),
BaseLandAirDefense = (SELECT BaseLandAirDefense FROM Units WHERE Type = 'UNIT_CRUISER'),
MilitarySupport = (SELECT MilitarySupport FROM Units WHERE Type = 'UNIT_CRUISER'),
MilitaryProduction = (SELECT MilitaryProduction FROM Units WHERE Type = 'UNIT_CRUISER'),
NoMaintenance = (SELECT NoMaintenance FROM Units WHERE Type = 'UNIT_CRUISER'),
NoSupply = (SELECT NoSupply FROM Units WHERE Type = 'UNIT_CRUISER'),
Pillage = (SELECT Pillage FROM Units WHERE Type = 'UNIT_CRUISER'),
MoveAfterPurchase = (SELECT MoveAfterPurchase FROM Units WHERE Type = 'UNIT_CRUISER'),
PurchaseCooldown = (SELECT PurchaseCooldown FROM Units WHERE Type = 'UNIT_CRUISER'),
GlobalFaithPurchaseCooldown = (SELECT GlobalFaithPurchaseCooldown FROM Units WHERE Type = 'UNIT_CRUISER'),
HurryCostModifier = (SELECT HurryCostModifier FROM Units WHERE Type = 'UNIT_CRUISER'),
RequiresFaithPurchaseEnabled = (SELECT RequiresFaithPurchaseEnabled FROM Units WHERE Type = 'UNIT_CRUISER'),
MinAreaSize = (SELECT MinAreaSize FROM Units WHERE Type = 'UNIT_CRUISER'),
AirInterceptRange = (SELECT AirInterceptRange FROM Units WHERE Type = 'UNIT_CRUISER'),
AirUnitCap = (SELECT AirUnitCap FROM Units WHERE Type = 'UNIT_CRUISER')
FROM Units
WHERE Type = 'UNIT_NEW_CRUISER';