text: INSERT INTO ArtDefine_UnitInfos (Type,DamageStates,Formation)
  	SELECT	('ART_DEF_UNIT_3GHAZI_SWORDSMAN'), DamageStates, Formation
  	FROM ArtDefine_UnitInfos WHERE (Type = 'ART_DEF_UNIT_SWORDSMAN');
  
  INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType,UnitMemberInfoType,NumMembers)
  	SELECT	('ART_DEF_UNIT_3GHAZI_SWORDSMAN'), ('ART_DEF_UNIT_MEMBER_3GHAZI_SWORDSMAN'), NumMembers
  	FROM ArtDefine_UnitInfoMemberInfos WHERE (UnitInfoType = 'ART_DEF_UNIT_SWORDSMAN');
  
  INSERT INTO ArtDefine_UnitMemberCombats (UnitMemberType, EnableActions, DisableActions, MoveRadius, ShortMoveRadius, ChargeRadius, AttackRadius, RangedAttackRadius, MoveRate, ShortMoveRate, TurnRateMin, TurnRateMax, TurnFacingRateMin, TurnFacingRateMax, RollRateMin, RollRateMax, PitchRateMin, PitchRateMax, LOSRadiusScale, TargetRadius, TargetHeight, HasShortRangedAttack, HasLongRangedAttack, HasLeftRightAttack, HasStationaryMelee, HasStationaryRangedAttack, HasRefaceAfterCombat, ReformBeforeCombat, HasIndependentWeaponFacing, HasOpponentTracking, HasCollisionAttack, AttackAltitude, AltitudeDecelerationDistance, OnlyTurnInMovementActions, RushAttackFormation)
  	SELECT	('ART_DEF_UNIT_MEMBER_3GHAZI_SWORDSMAN'), EnableActions, DisableActions, MoveRadius, ShortMoveRadius, ChargeRadius, AttackRadius, RangedAttackRadius, MoveRate, ShortMoveRate, TurnRateMin, TurnRateMax, TurnFacingRateMin, TurnFacingRateMax, RollRateMin, RollRateMax, PitchRateMin, PitchRateMax, LOSRadiusScale, TargetRadius, TargetHeight, HasShortRangedAttack, HasLongRangedAttack, HasLeftRightAttack, HasStationaryMelee, HasStationaryRangedAttack, HasRefaceAfterCombat, ReformBeforeCombat, HasIndependentWeaponFacing, HasOpponentTracking, HasCollisionAttack, AttackAltitude, AltitudeDecelerationDistance, OnlyTurnInMovementActions, RushAttackFormation
  	FROM ArtDefine_UnitMemberCombats WHERE (UnitMemberType = 'ART_DEF_UNIT_MEMBER_SWORDSMAN');
  
  INSERT INTO ArtDefine_UnitMemberCombatWeapons (UnitMemberType, "Index", SubIndex, ID, VisKillStrengthMin, VisKillStrengthMax, ProjectileSpeed, ProjectileTurnRateMin, ProjectileTurnRateMax, HitEffect, HitEffectScale, HitRadius, ProjectileChildEffectScale, AreaDamageDelay, ContinuousFire, WaitForEffectCompletion, TargetGround, IsDropped, WeaponTypeTag, WeaponTypeSoundOverrideTag)
  	SELECT ('ART_DEF_UNIT_MEMBER_3GHAZI_SWORDSMAN'), "Index", SubIndex, ID, VisKillStrengthMin, VisKillStrengthMax, ProjectileSpeed, ProjectileTurnRateMin, ProjectileTurnRateMax, HitEffect, HitEffectScale, HitRadius, ProjectileChildEffectScale, AreaDamageDelay, ContinuousFire, WaitForEffectCompletion, TargetGround, IsDropped, WeaponTypeTag, WeaponTypeSoundOverrideTag
  	FROM ArtDefine_UnitMemberCombatWeapons WHERE (UnitMemberType = 'ART_DEF_UNIT_MEMBER_SWORDSMAN');
  
  INSERT INTO ArtDefine_UnitMemberInfos (Type, Scale, ZOffset, Domain, Model, MaterialTypeTag, MaterialTypeSoundOverrideTag)
  	SELECT	('ART_DEF_UNIT_MEMBER_3GHAZI_SWORDSMAN'), Scale, ZOffset, Domain, ('Swordsman_Arabia_v3.fxsxml'), MaterialTypeTag, MaterialTypeSoundOverrideTag
  	FROM ArtDefine_UnitMemberInfos WHERE (Type = 'ART_DEF_UNIT_MEMBER_SWORDSMAN');
  
  INSERT INTO ArtDefine_StrategicView (StrategicViewType, TileType, Asset )
  	VALUES	('ART_DEF_UNIT_3GHAZI_SWORDSMAN', 'Unit', 'IconGhaziSV.dds');
  
  
  --------------------------------	
  -- Units
  --------------------------------
  INSERT INTO Units 	
  		(Type, 						Class,	ProhibitsSpread,  PrereqTech, RangedCombat, Range, Special, Combat, Cost, ObsoleteTech, GoodyHutUpgradeUnitClass, FaithCost, RequiresFaithPurchaseEnabled, Moves, CombatClass, Domain, DefaultUnitAI, Help, Description, 					  Civilopedia, 								Strategy, 		 									Pillage, MilitarySupport, MilitaryProduction, IgnoreBuildingDefense, Mechanized, AdvancedStartCost, RangedCombatLimit, CombatLimit, XPValueDefense, UnitArtInfo, 						UnitFlagIconOffset,	UnitFlagAtlas,						 PortraitIndex, 	IconAtlas,			 MoveRate)
  SELECT	'UNIT_3GHAZI_SWORDSMAN',	Class,	'true', PrereqTech, RangedCombat, Range, Special, Combat, Cost, ObsoleteTech, GoodyHutUpgradeUnitClass, FaithCost, RequiresFaithPurchaseEnabled, Moves, CombatClass, Domain, DefaultUnitAI, 'TXT_KEY_UNIT_3GHAZI_SWORDSMAN_HELP', 'TXT_KEY_UNIT_3GHAZI_SWORDSMAN', 'TXT_KEY_UNIT_3GHAZI_SWORDSMAN_TEXT',	'TXT_KEY_UNIT_3GHAZI_SWORDSMAN_STRATEGY',  	Pillage, MilitarySupport, MilitaryProduction, IgnoreBuildingDefense, Mechanized, AdvancedStartCost, RangedCombatLimit, CombatLimit, XPValueDefense, 'ART_DEF_UNIT_3GHAZI_SWORDSMAN',	0,					'3GHAZI_SWORDSMAN_FLAG',					  0, 				'UNIT_3GHAZI_ATLAS',	 MoveRate
  FROM Units WHERE Type = 'UNIT_SWORDSMAN';
  --------------------------------	
  -- UnitGameplay2DScripts
  --------------------------------		
  INSERT INTO UnitGameplay2DScripts 	
  		(UnitType, 					SelectionSound, FirstSelectionSound)
  SELECT	'UNIT_3GHAZI_SWORDSMAN', 	SelectionSound, FirstSelectionSound
  FROM UnitGameplay2DScripts WHERE UnitType = 'UNIT_SWORDSMAN';
  --------------------------------		
  -- Unit_AITypes
  --------------------------------		
  INSERT INTO Unit_AITypes 	
  		(UnitType, 					UnitAIType)
  SELECT	'UNIT_3GHAZI_SWORDSMAN', 	UnitAIType
  FROM Unit_AITypes WHERE UnitType = 'UNIT_SWORDSMAN';
  
  --------------------------------	
  -- Unit_ClassUpgrades
  --------------------------------	
  INSERT INTO Unit_ClassUpgrades 	
  		(UnitType, 					UnitClassType)
  SELECT	'UNIT_3GHAZI_SWORDSMAN',	UnitClassType
  FROM Unit_ClassUpgrades WHERE UnitType = 'UNIT_SWORDSMAN';	
  --------------------------------	
  -- Unit_Flavors
  --------------------------------		
  INSERT INTO Unit_Flavors 	
  		(UnitType, 					FlavorType, Flavor)
  SELECT	'UNIT_3GHAZI_SWORDSMAN',	FlavorType, Flavor
  FROM Unit_Flavors  WHERE UnitType = 'UNIT_SWORDSMAN';	
  --------------------------------	
  -- Unit_ResourceQuantityRequirements
  --------------------------------	
  INSERT INTO Unit_ResourceQuantityRequirements 	
  		(UnitType, 					ResourceType, Cost)
  SELECT	'UNIT_3GHAZI_SWORDSMAN', 	ResourceType, Cost
  FROM Unit_ResourceQuantityRequirements WHERE UnitType = 'UNIT_SWORDSMAN';
  --------------------------------	
  -- Unit_FreePromotions
  --------------------------------	
  INSERT INTO Unit_FreePromotions 	
  		(UnitType, 					PromotionType)
  SELECT	'UNIT_3GHAZI_SWORDSMAN', 	PromotionType
  FROM Unit_FreePromotions WHERE UnitType = 'UNIT_SWORDSMAN';	
  
  INSERT INTO Unit_FreePromotions
  		(UnitType, 					PromotionType)
  VALUES	('UNIT_3GHAZI_SWORDSMAN',  'PROMOTION_3UC_DOUBLE');
  
  --------------------------------	
  -- Civilization_UnitClassOverrides 
  --------------------------------		
  INSERT INTO Civilization_UnitClassOverrides 
  		(CivilizationType, 					UnitClassType, 			UnitType)
  VALUES	('CIVILIZATION_ARABIA',	'UNITCLASS_SWORDSMAN',	'UNIT_3GHAZI_SWORDSMAN');