mrqc-sys/doc/005.20200528v1.2.x/qc_init.sql

use `qc`;

ALTER TABLE `med_behospital_info` ADD COLUMN `is_placefile` varchar(2) NOT NULL DEFAULT '0' COMMENT '是否归档（0：未归档，1：已归档）' AFTER `director_doctor_name`;

ALTER TABLE `med_qcresult_detail` ADD COLUMN `grade_type` tinyint(4) DEFAULT '1' COMMENT '初始类型(1：机器，2：人工)' AFTER `is_reject`;
ALTER TABLE `med_qcresult_detail` ADD COLUMN `opt_type` tinyint(4) DEFAULT '1' COMMENT '操作类型(1：新增，2：删除，3：修改)' AFTER `grade_type`;

UPDATE `sys_permission` SET `is_deleted` = 'Y' WHERE `id` = '10';

update `sys_dictionary_info` set is_deleted = 'N' where group_type = 12 and `name` = '病案首页';
update `qc_mode` set order_no = 200 where id = 53;
update `qc_mode` set order_no = 210 where id = 54;