-- 安全制度按版本保存,待审批版本不会覆盖已批准版本。 CREATE TABLE IF NOT EXISTS safety_document ( id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, document_key VARCHAR(36) NOT NULL, revision INT NOT NULL, title VARCHAR(200) NOT NULL, category VARCHAR(50) NOT NULL, attachment_url VARCHAR(1000) NOT NULL, description VARCHAR(2000) NULL, effective_date DATE NULL, status VARCHAR(20) NOT NULL, owner_user_id BIGINT NOT NULL, submitter_user_id BIGINT NULL, submit_time DATETIME NULL, approver_user_id BIGINT NULL, approval_time DATETIME NULL, approval_comment VARCHAR(500) 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', UNIQUE KEY uk_safety_document_revision (tenant_id,document_key,revision), KEY idx_safety_document_status (status,id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='安全制度版本档案'; CREATE TABLE IF NOT EXISTS safety_document_approval ( id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, document_id BIGINT NOT NULL, approver_user_id BIGINT NOT NULL, decision VARCHAR(20) NOT NULL, comment VARCHAR(500) NULL, decision_time DATETIME NOT NULL, submitter_user_id BIGINT NULL, title_snapshot VARCHAR(200) NULL, category_snapshot VARCHAR(50) NULL, attachment_url_snapshot VARCHAR(1000) NULL, description_snapshot VARCHAR(2000) NULL, effective_date_snapshot DATE 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_document_approval (document_id,id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='安全制度审批记录'; -- 仅在现有安全生产一级菜单下创建页面与按钮,不自动分配角色。 -- 需要上传附件的角色还应授予现有 safety:file:upload 权限。 SET @safety_document_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,35,@safety_document_parent,'document','lucide:files','safety/document/index','SafetyDocument',0,b'1',b'1',b'1','1','1' WHERE @safety_document_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='safety/document/index' AND deleted=b'0'); SET @safety_document_page := (SELECT id FROM system_menu WHERE component='safety/document/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,@safety_document_page,'','',0,b'1',b'1',b'1','1','1' FROM (SELECT '查询' name,'safety:document:query' permission,1 sort_no UNION ALL SELECT '新增','safety:document:create',2 UNION ALL SELECT '修改和提交','safety:document:update',3 UNION ALL SELECT '审批','safety:document:approve',4) p WHERE @safety_document_page IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id=@safety_document_page AND m.permission=p.permission AND m.deleted=b'0');