-- 人工维护危险源当前值;不表示已接入自动数采,也不保留历史观测序列。 CREATE TABLE IF NOT EXISTS safety_risk_source ( id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(120) NOT NULL, category VARCHAR(24) NOT NULL, location VARCHAR(160) DEFAULT NULL, metric_name VARCHAR(80) NOT NULL, unit VARCHAR(32) DEFAULT NULL, lower_limit DECIMAL(20,6) DEFAULT NULL, upper_limit DECIMAL(20,6) DEFAULT NULL, current_value DECIMAL(20,6) DEFAULT NULL, observed_at DATETIME DEFAULT NULL, risk_status VARCHAR(16) NOT NULL DEFAULT 'UNKNOWN', remark VARCHAR(500) DEFAULT NULL, tenant_id BIGINT NOT NULL DEFAULT 0, creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted BIT(1) NOT NULL DEFAULT b'0', KEY idx_safety_risk_status (risk_status,deleted) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='危险源人工监测台账'; SET @risk_parent := (SELECT id FROM system_menu WHERE parent_id=0 AND path='/safety' AND type=1 AND deleted=b'0' LIMIT 1); INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater) SELECT '危险源台账','',2,36,@risk_parent,'risk-source','lucide:triangle-alert','safety/risk-source/index','SafetyRiskSource',0,b'1',b'1',b'1','1','1' WHERE @risk_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='safety/risk-source/index' AND deleted=b'0'); SET @risk_page := (SELECT id FROM system_menu WHERE component='safety/risk-source/index' AND deleted=b'0' LIMIT 1); INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,status,visible,keep_alive,always_show,creator,updater) SELECT p.name,p.permission,3,p.sort_no,@risk_page,'','',0,b'1',b'1',b'1','1','1' FROM (SELECT '查询' name,'safety:risk:query' permission,1 sort_no UNION ALL SELECT '新增','safety:risk:create',2 UNION ALL SELECT '修改','safety:risk:update',3 UNION ALL SELECT '删除','safety:risk:delete',4) p WHERE @risk_page IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id=@risk_page AND m.permission=p.permission AND m.deleted=b'0');