INSERT INTO show_referee (
	id,
	referee_name_cn,
	referee_name_en,
	referee_sex,
	referee_citizenship,
	referee_picture,
	referee_introduce,
	referee_type,
	referee_title,
	referee_link_order,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	cku_name,
	cku_ename,
	cku_sex,
	cku_country,
	cku_picture,
	cku_jianjie,
	cku_type,
	cku_touxian,
	Ljk_LinkOrder,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	SYSDATE() update_date,
	'' remarks,
	0 del_flag
FROM
	dbo.cku_fcl;

update show_referee set referee_sex = 1 where referee_sex = '男';
update show_referee set referee_sex = 2 where referee_sex = '女';