INSERT INTO dog_name (
	id,
	dog_gender,
	dog_name
) SELECT 
	id,
	dogSex,
	dogName
FROM dbo.dogName;
INSERT INTO dog_birth_certificate (
	id,
	birth_cer_reg_code,
	pedigree_certified,
	dog_owenr,
	member_code,
	second_dog_owner,
	second_owner_member_code,
	breeder_member_code,
	breeder,
	temp_member_code,
	temp_user_name,
	dog_en_name,
	dog_gender,
	dog_breed,
	dog_birthday,
	same_batch_num,
	identification_flag,
	color_flag,
	dna,
	fdog_pedigree_certified,
	mdog_pedigree_certified,
	fmdog_breed_certified_code,
	operator,
	price,
	deduction,
	add_user,
	urgent,
	print_type,
	chip_inject_date,
	sn_code,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state
) SELECT
	id,
	出生证明登记编号,
	血统证书号,
	犬主人,
	会员号,
	第二犬主,
	第二犬主会员号,
	繁殖人会员号,
	繁殖人,
	tempUserID,
	tempUserName,
	英文姓名,
	性别,
	种类,
	case when 出生日期 = '' then null else 出生日期 end 出生日期,
	同胎犬数,
	身份识别标志,
	颜色及标志,
	DNA,
	父犬血统证号,
	母犬血统证号,
	父母犬配犬证明号,
	操作人员,
	order_price,
	dikou,
	insert_user,
	cku_jiaji,
	print_type,
	chipRegDate,
	snCode,
	1 create_by,
	添加日期,
	1 update_by,
	修改日期,
	'' remarks,
	del_tag,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate
FROM
	dbo.dog_BirthCertificate;


update dog_birth_certificate set dog_gender = 1 where dog_gender = '公';
update dog_birth_certificate set dog_gender = 2 where dog_gender = '母';

update dog_birth_certificate set urgent = 0 where urgent = '否';
update dog_birth_certificate set urgent = 1 where urgent = '是';

update dog_birth_certificate set payment_state = 2 where payment_state = 1;
update dog_birth_certificate set payment_state = 1 where payment_state = 0;
UPDATE dbo.dog_Appraise set dog_birthday = "2010-09-20" where dog_birthday = "2010年9月20日";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-2-1" where dog_birthday = "2013-2";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-1-1" where dog_birthday = "2011-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-02-1" where dog_birthday = "2011-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2010-1-1" where dog_birthday = "2010-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-12-1" where dog_birthday = "2013-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-02-1" where dog_birthday = "2012-2";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-02-1" where dog_birthday = "2012-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-04-1" where dog_birthday = "2012-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-01-1" where dog_birthday = "2012";
UPDATE dbo.dog_Appraise set dog_birthday = "2010-12-01" where dog_birthday = "2010-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2010-01-01" where dog_birthday = "2012-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-05-01" where dog_birthday = "2011-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-1-01" where dog_birthday = "2013-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-03-01" where dog_birthday = "2012-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-03-01" where dog_birthday = "2011-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-01-01" where dog_birthday = "2012-01";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-09-01" where dog_birthday = "2012-09";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-08-01" where dog_birthday = "2012-08";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-07-01" where dog_birthday = "2012-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-06-01" where dog_birthday = "2012-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-05-01" where dog_birthday = "2012-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-04-01" where dog_birthday = "2012-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-12-01" where dog_birthday = "2012-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-07-01" where dog_birthday = "2013-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-04-01" where dog_birthday = "2013-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-02-28" where dog_birthday = "2012-02-30";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-04-01" where dog_birthday = "2011-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-10-01" where dog_birthday = "2013-10";

UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-01" where dog_birthday = "2014-01";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-02" where dog_birthday = "2014-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-03" where dog_birthday = "2014-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-04" where dog_birthday = "2014-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-05" where dog_birthday = "2014-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-06" where dog_birthday = "2014-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-07" where dog_birthday = "2014-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-08" where dog_birthday = "2014-08";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-09" where dog_birthday = "2014-09";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-10" where dog_birthday = "2014-10";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-11" where dog_birthday = "2014-11";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-12" where dog_birthday = "2014-12";

UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-01" where dog_birthday = "2014-01";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-02" where dog_birthday = "2014-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-03" where dog_birthday = "2014-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-04" where dog_birthday = "2014-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-05" where dog_birthday = "2014-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-06" where dog_birthday = "2014-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-07" where dog_birthday = "2014-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-08" where dog_birthday = "2014-08";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-09" where dog_birthday = "2014-09";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-10" where dog_birthday = "2014-10";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-11" where dog_birthday = "2014-11";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-12" where dog_birthday = "2014-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-05-01" where dog_birthday = "2012-05-";
UPDATE dbo.dog_Appraise set dog_birthday = "2015-06-01" where dog_birthday = "2015-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-06-01" where dog_birthday = "2013-06";
INSERT INTO dog_appraisal (
	id,
	dog_id,
	dog_owner_code,
	dog_owner_name,
	payment_member_code,
	identify_type,
	identify_site,
	dog_breed,
	dog_name,
	dog_gender,
	dog_fur_color,
	birthday,
	operator,
	price,
	dog_appraisal.dog_chip,
	dog_dna_image,
	pedigree_certified,
	hospital_id,
	identify_code,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	pay_ckuid,
	'',
	pay_ckuid,
	Appraise_type,
	'',
	dog_class,
	dog_name,
	dog_sex,
	dog_color,
	case when dog_birthday = '' then null else dog_birthday end dog_birthday,
	operater,
	order_price,
	Appraise_sfnum,
	Appraise_pic,
	Appraise_zsnum,
	'',
	Appraise_sfnum,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_Appraise;

update dog_appraisal set dog_gender = 1 where dog_gender = '公';
update dog_appraisal set dog_gender = 2 where dog_gender = '母';

update dog_appraisal set identify_type = 0 where identify_type = '审查员鉴定';
update dog_appraisal set identify_type = 1 where identify_type = 'DNA';

update dog_appraisal set payment_state = 2 where payment_state = 1;
update dog_appraisal set payment_state = 1 where payment_state = 0;

#更新犬只鉴定表中犬主人姓名缺失的问题
update dog_appraisal a,sys_member m set a.dog_owner_name = m.name where (a.dog_owner_name is null or a.dog_owner_name = '') and a.dog_owner_code=m.member_code;

INSERT INTO dog_chip_change (
	id,
	dog_id,
	chip_code_old,
	chip_code_new,
	payment_member_code,
	operator,
	price,
	organization_username,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	Chip,
	new_Chip,
	pay_ckuid,
	operater,
	order_price,
	username,
	info_Confirm,
	info_Confirm_time,
	'',
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_ChipChange;



INSERT INTO dog_color_mark (
	id,
	dog_color_mark_code,
	dog_color_mark_cn,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	UUID(),
	abbreviate_english,
	explain_chinese,
	1 create_by,
	SYSDATE() create_date,
	1 update_by,
	SYSDATE() update_date,
	'' remarks,
	0 del_flag
FROM
	dbo.tab_color_and_badge;
	
	
	
	
	INSERT INTO dog_pedigree_certified_export (
	id,
	dog_id,
	pedigree_certified,
	export_destination,
	exporter,
	payment_member_code,
	operator,
	price,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	zsid,
	export_country,
	export_user,
	pay_ckuid,
	operater,
	order_price,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_ZsidExport;


update dog_pedigree_certified_export set payment_state = 2 where payment_state = 1;
update dog_pedigree_certified_export set payment_state = 1 where payment_state = 0;

#把虽然标记为未处理，但实际已处理的记录改为已处理
UPDATE dog_pedigree_certified_change
SET process_state = 1
WHERE
	id IN (
		SELECT
			a.id
		FROM
			(
				SELECT
					id
				FROM
					dog_pedigree_certified_change
				WHERE
					overseas_pedigree_certified IN (
						SELECT
							pedigree_certified_en
						FROM
							dog
						WHERE
							pedigree_certified_en IN (
								SELECT
									overseas_pedigree_certified
								FROM
									dog_pedigree_certified_change
								WHERE
									review_state = 1
								AND (
									process_state = 0
									OR process_state IS NULL
								)
							)
					)
			) a
	);
	
	
	INSERT INTO dog_dna_archive (
	id,
	dog_id,
	pedigree_certified,
	dna_code,
	payment_member_code,
	operator,
	price,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	zsid,
	DNA_ID,
	pay_ckuid,
	operater,
	order_price,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_DNAcunDang;


update dog_dna_archive set payment_state = 2 where payment_state = 1;
update dog_dna_archive set payment_state = 1 where payment_state = 0;


INSERT INTO dog_dna (
	id,
	dog_id,
	sum_zu,
	dna_result,
	dna_result_remark,
	dna_code,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dog_id,
	sum_zu,
	DNA鉴定结果,
	DNA鉴定备注,
	DNA样本登记号码,
	1 create_by,
	添加日期 create_date,
	1 update_by,
	修改日期 update_date,
	'' remarks,
	del_tag
FROM
	dbo.dog_DNA;
	
	UPDATE sys_express_send set print_state = '0' where print_state is null;
	
	
	INSERT INTO dog_pedigree_certified_redo (
	id,
	dog_id,
	original_pedigree_certified,
	current_pedigree_certified,
	payment_member_code,
	operator,
	price,
	change_type,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	zsid,
	new_zsid,
	pay_ckuid,
	operater,
	order_price,
	changeType,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_ZsidChange;
	
update dog_pedigree_certified_redo set payment_state = 2 where payment_state = 1;
update dog_pedigree_certified_redo set payment_state = 1 where payment_state = 0;


truncate table dog_pedigree_certified_change;


UPDATE dbo.dog_Recertification set dog_birthday = "2010-09-20" where dog_birthday = "2010年9月20日";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-2-1" where dog_birthday = "2013-2";
UPDATE dbo.dog_Recertification set dog_birthday = "2011-1-1" where dog_birthday = "2011-1";
UPDATE dbo.dog_Recertification set dog_birthday = "2011-02-1" where dog_birthday = "2011-02";
UPDATE dbo.dog_Recertification set dog_birthday = "2010-1-1" where dog_birthday = "2010-1";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-12-1" where dog_birthday = "2013-12";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-02-1" where dog_birthday = "2012-2";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-02-1" where dog_birthday = "2012-02";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-04-1" where dog_birthday = "2012-04";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-01-1" where dog_birthday = "2012";
UPDATE dbo.dog_Recertification set dog_birthday = "2010-12-01" where dog_birthday = "2010-12";
UPDATE dbo.dog_Recertification set dog_birthday = "2010-01-01" where dog_birthday = "2012-1";
UPDATE dbo.dog_Recertification set dog_birthday = "2011-05-01" where dog_birthday = "2011-05";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-1-01" where dog_birthday = "2013-1";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-03-01" where dog_birthday = "2012-03";
UPDATE dbo.dog_Recertification set dog_birthday = "2011-03-01" where dog_birthday = "2011-03";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-01-01" where dog_birthday = "2012-01";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-09-01" where dog_birthday = "2012-09";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-08-01" where dog_birthday = "2012-08";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-07-01" where dog_birthday = "2012-07";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-06-01" where dog_birthday = "2012-06";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-05-01" where dog_birthday = "2012-05";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-04-01" where dog_birthday = "2012-04";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-12-01" where dog_birthday = "2012-12";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-07-01" where dog_birthday = "2013-07";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-04-01" where dog_birthday = "2013-04";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-02-28" where dog_birthday = "2012-02-30";
UPDATE dbo.dog_Recertification set dog_birthday = "2011-04-01" where dog_birthday = "2011-04";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-10-01" where dog_birthday = "2013-10";

UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-01" where dog_birthday = "2014-01";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-02" where dog_birthday = "2014-02";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-03" where dog_birthday = "2014-03";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-04" where dog_birthday = "2014-04";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-05" where dog_birthday = "2014-05";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-06" where dog_birthday = "2014-06";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-07" where dog_birthday = "2014-07";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-08" where dog_birthday = "2014-08";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-09" where dog_birthday = "2014-09";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-10" where dog_birthday = "2014-10";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-11" where dog_birthday = "2014-11";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-12" where dog_birthday = "2014-12";

UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-01" where dog_birthday = "2014-01";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-02" where dog_birthday = "2014-02";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-03" where dog_birthday = "2014-03";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-04" where dog_birthday = "2014-04";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-05" where dog_birthday = "2014-05";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-06" where dog_birthday = "2014-06";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-07" where dog_birthday = "2014-07";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-08" where dog_birthday = "2014-08";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-09" where dog_birthday = "2014-09";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-10" where dog_birthday = "2014-10";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-11" where dog_birthday = "2014-11";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-01-12" where dog_birthday = "2014-12";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-05-01" where dog_birthday = "2012-05-";
UPDATE dbo.dog_Recertification set dog_birthday = "2015-06-01" where dog_birthday = "2015-06";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-07-01" where dog_birthday = "2014-7";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-06-17" where dog_birthday = "2013 06 17";
UPDATE dbo.dog_Recertification set dog_birthday = "2012-09-09" where dog_birthday = "2012-09-99";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-04-12" where dog_birthday = "PUBLIC";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-05-09" where dog_birthday = "201";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-11-15" where dog_birthday = "20913-11-15";
UPDATE dbo.dog_Recertification set dog_birthday = "2014-3-15" where dog_birthday = "2014年3月15日";
UPDATE dbo.dog_Recertification set dog_birthday = "2015-1-1" where dog_birthday = "2015";
UPDATE dbo.dog_Recertification set dog_birthday = "2015-2-23" where dog_birthday = "2015年，2月23";
UPDATE dbo.dog_Recertification set dog_birthday = "2013-1-1" where dog_birthday = "2013年，1月1号";
UPDATE dbo.dog_Recertification set dog_birthday = "2010-11-2" where dog_birthday = "2010﹡-11-2";





INSERT INTO dog_pedigree_certified_change (
	id,
	dog_id,
	overseas_pedigree_certified,
	dog_breed,
	dog_name,
	dog_gender,
	dog_fur_color,
	dog_birthday,
	dog_chip,
	payment_member_code,
	operator,
	price,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	zsid_gw,
	dog_class,
	dog_name,
	dog_sex,
	dog_color,
	case when dog_birthday = '' then null else dog_birthday end,
	dog_chip,
	pay_ckuid,
	operater,
	order_price,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_Recertification;
	

	
select dog_gender,count(*) from dog_pedigree_certified_change group by dog_gender;	
update dog_pedigree_certified_change set dog_gender = 1 where dog_gender = '公';
update dog_pedigree_certified_change set dog_gender = 2 where dog_gender = '母';
	
select payment_state,count(*) from dog_pedigree_certified_change group by payment_state;	

update dog_pedigree_certified_change set payment_state = 2 where payment_state = 1;
update dog_pedigree_certified_change set payment_state = 1 where payment_state = 0;


update dog_type d,dbo.dogCodeColor c set d.dog_color = c.dogColor where d.dog_breed_code = c.dogCode;