dev/2020/2020-019(OK)/2020-019-wzw-001.sql

USE DCP;

-- 依托机构（Chair Agency）
UPDATE sys_dict 
SET DICT_NAME = 'Chair Agency',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '1' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_UNIT_POST_DICT_EN' );

	-- 副主席（Co-Chairperson）
UPDATE sys_dict 
SET DICT_NAME = 'Co-Chairperson',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '2' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_POST_DICT_EN' );
	
	-- 主席（Chairperson）
UPDATE sys_dict 
SET DICT_NAME = 'Chairperson',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '1' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_POST_DICT_EN' );
	
	-- 中南美（Latin America）
UPDATE sys_dict 
SET DICT_NAME = 'Latin America',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '7' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_REGIONAL_DICT_EN' );
	
	-- 北美（North America）
UPDATE sys_dict 
SET DICT_NAME = 'North America',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '6' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_REGIONAL_DICT_EN' );
	
	-- 东南亚-南亚（Southeast Asia & South Asia）
UPDATE sys_dict 
SET DICT_NAME = 'Southeast Asia & South Asia',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '5' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_REGIONAL_DICT_EN' );
	
	-- 欧洲（Europe）
UPDATE sys_dict 
SET DICT_NAME = 'Europe',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '3' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_REGIONAL_DICT_EN' );
	
	-- 东欧-中亚（Eastern Europe & Central Asia）
UPDATE sys_dict 
SET DICT_NAME = 'Eastern Europe & Central Asia',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '4' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_REGIONAL_DICT_EN' );
	
	-- 西亚-北非（West Asian & North Africa）
UPDATE sys_dict 
SET DICT_NAME = 'West Asian & North Africa',
UPDATE_TIME = now( ),
UPDATE_USER_ID = '1' 
WHERE
	DICT_VALUE = '2' 
	AND DICT_TYPE_ID = ( SELECT DICT_TYPE_ID FROM sys_dict_type WHERE DICT_TYPE_CODE = 'COMMITTEE_REGIONAL_DICT_EN' );
	/*161已执行 2020.12.1 */
    /*159已执行 2020年12月1日 15:12:58 ljh */