cdss-core/doc/20210727提示规则新需求/med2021_init.sql

USE `med_2021`;

ALTER TABLE kl_rule_condition ADD  COLUMN `msg` varchar(255) NOT NULL DEFAULT '' COMMENT '附加信息' AFTER `rule_base_id`;

UPDATE kl_rule_condition t1,
 (
	SELECT
		*
	FROM
		`kl_rule`
	WHERE
		msg != ""
) t2
SET t1.msg = t2.msg
where t1.rule_id = t2.id;

SELECT
		*
	FROM
		`kl_rule_condition`
	WHERE
		msg != "";