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;