--============================================================
-- YU - CONFIG ===============================================
--============================================================
-- Author: Lime
-- DateCreated: 1/9/2018 21:22:17
--------------------------------------------------------------

--------------------------------------------------------------
-- Players
--------------------------------------------------------------
INSERT INTO Players	
		(CivilizationType,	
		Domain,		
		Portrait,							 
		PortraitBackground,		
		LeaderType,				
		LeaderName,							
		LeaderIcon,						
		LeaderAbilityName,								
		LeaderAbilityDescription,								
		LeaderAbilityIcon,				
		CivilizationName,	
		CivilizationIcon,							
		CivilizationAbilityName,	
		CivilizationAbilityDescription,	
		CivilizationAbilityIcon)
SELECT	'CIVILIZATION_CHINA',
		Domain,		
		'LEADER_LIME_YU_NEUTRAL.dds',	 
		'LEADER_DEFAULT_BACKGROUND',	
		'LEADER_LIME_CHINA_YU',	
		'LOC_LEADER_LIME_CHINA_YU_NAME',	
		'ICON_LEADER_LIME_CHINA_YU',	
		'LOC_TRAIT_LEADER_LIME_CHINA_YU_GATEWAY_NAME',	
		'LOC_TRAIT_LEADER_LIME_CHINA_YU_GATEWAY_DESCRIPTION',	
		'ICON_LEADER_LIME_CHINA_YU',	
		CivilizationName,	
		'ICON_CIV_LIME_CHINA_YU_COLOR',	
		CivilizationAbilityName,	
		CivilizationAbilityDescription,	
		'ICON_CIV_LIME_CHINA_YU_COLOR'
FROM Players WHERE CivilizationType = 'CIVILIZATION_CHINA' AND LeaderType= 'LEADER_QIN';
	
--------------------------------------------------------------
-- PlayerItems
--------------------------------------------------------------
INSERT INTO PlayerItems	
		(CivilizationType,	
		Domain,		
		LeaderType,				
		Type, 
		Icon, 
		Name, 
		Description, 
		SortIndex)
SELECT	'CIVILIZATION_CHINA',
		Domain,
		'LEADER_LIME_CHINA_YU',	
		Type, 
		Icon, 
		Name, 
		Description, 
		SortIndex
FROM PlayerItems WHERE CivilizationType = 'CIVILIZATION_CHINA' AND LeaderType= 'LEADER_QIN' AND Type IN ('UNIT_CHINESE_CROUCHING_TIGER', 'IMPROVEMENT_GREAT_WALL');