diagbotcloud/docs/011.20190731ICSS历史病历优化增量脚本/init_med.sql

use `med`;
ALTER TABLE kl_concept ADD sort_deleted VARCHAR(5)  GENERATED ALWAYS AS ('Y' > is_deleted) VIRTUAL COMMENT '自动生成排序用删除标志';
ALTER TABLE kl_concept ADD INDEX  idx_deleted_modified_id(`sort_deleted`,`gmt_modified`,`id`);