-- 隐患分派站内通知模板。请按目标系统权限配置消息接收人账号。 INSERT INTO system_notify_template (name,code,nickname,content,type,params,status,remark,creator,updater,deleted) SELECT '隐患整改通知','safety_hazard_assigned','安全生产', '隐患 {code}:{title} 已分派给您整改,整改期限:{deadline}。请在隐患台账中处理。', 1,'["code","title","deadline"]',0,'隐患分派自动通知','1','1',0 WHERE NOT EXISTS (SELECT 1 FROM system_notify_template WHERE code='safety_hazard_assigned' AND deleted=0);