jfcloud-gene/jfcloud-gene-biz/src/main/resources/sql/ddl-20250321.sql

INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.-1.dingding.enable','true','样本送检驳回钉钉通知');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.25.dingding.enable','true','样本送检部门负责人审核钉钉通知');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.60.dingding.enable','true','样本送检项目管理部审核钉钉通知');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.100.dingding.enable','true','样本送检完成钉钉通知');

INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('gene.sync.ky','true','基因定制科研同步');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('gene.sync.animal','true','基因定制动物同步');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.sync.ky','true','样本送检科研同步');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.sync.animal','true','样本送检动物同步');

INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('gene.approvalType','128553280451923968','基因定制项目类型');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.animal.approvalType','140214062520487936','动物样本检测项目类型');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.pathological.approvalType','139128675031076864','病理样本检测项目类型');
INSERT INTO jfcloud_gene.system_properties (prop_key,prop_value,remark) VALUES
    ('sample.animalImage.approvalType','140214120615792640','动物影像检测项目类型');