| 123456789 |
- 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 '备注';
|
