use `qc`; ALTER TABLE `qc_cases_entry_hospital` ADD `score_run` decimal(5,1) DEFAULT NULL COMMENT '扣分值(运行质控)' AFTER `score`; ALTER TABLE `qc_cases_entry_hospital` ADD `is_used_run` int(3) DEFAULT NULL COMMENT '0-未启用 1-启用(运行质控)' AFTER `is_used`; update qc_cases_entry_hospital set is_used_run = is_used, score_run=score; UPDATE `sys_dictionary_info` SET `name` = '形式质控',`order_no` = 3 WHERE `name` = '形式质控' and group_type = '18' and val = '1'; UPDATE `sys_dictionary_info` SET `name` = '内涵CRF质控',`order_no` = 2 WHERE `name` = '内涵质控' and group_type = '18' and val = '2'; INSERT INTO `sys_dictionary_info` (`is_deleted`,`gmt_create`,`gmt_modified`,`creator`,`modifier`,`group_type`,`name`,`val`,`return_type`,`order_no`,`remark`) VALUES ('N','1970-01-01 12:00:00','1970-01-01 12:00:00','0','0',18,'内涵规则质控','3',1,1,'质控形式'); alter table qc_cases_entry MODIFY remark varchar(1024) DEFAULT NULL COMMENT '备注';