cnbg-be/db/v2121.4.16/3.sql

update sys_dept d set tax_code = (
select t.zj_number  from wm_da_agent t where d.dept_id = t.dept_id
)

update sys_dept d set tax_code = (
select t.entcode  from wm_da_drug_ent t where d.dept_id = t.dept_id
) where tax_code is null


update sys_user  set  rlj_cert_status = cert_status where cert_status < 10

insert into sys_dept_sub (dept_id,subject_type,app_id,app_secret,rsa_public_key,query_url,subject_name,enable_flag)
SELECT dept_id,subject_type,app_id,app_secret,rsa_public_key,query_url,subject_name,1 from sys_dept where dept_id<>1 and del_flag=0  and app_id is not null

update wm_score_package_settle_note t set id_card_number  = (
select s.id_card_number from sys_user s where t.user_id = s.user_id )