mrqc-sys/doc/017.20200716v1.3.8/qc_inti_check.sql

use `qc`;
ALTER TABLE `med_check_info` ADD COLUMN `check_type` INT(11) NULL COMMENT '核查类型（0病历，1病案首页）' AFTER `status`;
UPDATE med_check_info a SET check_type =0;
UPDATE med_check_info a SET check_name = (SELECT linkman FROM sys_user b WHERE a.check_id=b.id) inkman FROM sys_user b WHERE a.check_id=b.id)