INSERT INTO show_score (
	id,
	YEAR,
	score_type,
	score,
	pedigree_certified,
	dog_gender,
	dog_owner,
	dog_breed_name_cn,
	dog_breed_name_en,
	dog_name,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	UUID(),
	年度,
	积分类型,
	积分,
	血统证书号,
	性别,
	犬主人,
	犬种中文名,
	犬种英文名,
	犬名,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	SYSDATE() update_date,
	'' remarks,
	0 del_flag
FROM
	dbo.tab_games_integral;

update show_score set dog_gender = 1 where dog_gender in ('公','公 Male');
update show_score set dog_gender = 2 where dog_gender in ('母','母 Female');