riskctrl-server-fixed/script/sql/safety_training.sql

-- 安全培训表
DROP TABLE IF EXISTS `safety_training`;
CREATE TABLE `safety_training` (
  `training_id` bigint NOT NULL AUTO_INCREMENT COMMENT '培训ID',
  `training_no` varchar(32) DEFAULT NULL COMMENT '培训编号',
  `training_title` varchar(100) NOT NULL COMMENT '培训标题',
  `training_type` varchar(32) DEFAULT NULL COMMENT '培训类型（安全知识/操作规范/应急预案/设备维护）',
  `training_time` datetime DEFAULT NULL COMMENT '培训时间',
  `training_location` varchar(200) DEFAULT NULL COMMENT '培训地点',
  `trainer` varchar(64) DEFAULT NULL COMMENT '培训师',
  `participant_count` int DEFAULT 0 COMMENT '参与人数',
  `training_status` varchar(16) DEFAULT '未开始' COMMENT '培训状态（未开始/进行中/已结束）',
  `training_content` text COMMENT '培训内容',
  `training_material` varchar(500) DEFAULT NULL COMMENT '培训资料',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`training_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='安全培训';

-- 安全培训菜单
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) 
SELECT '安全培训', 你的父菜单ID, 11, 'safetyTraining', 'riskctrl/safetyTraining/index', NULL, 'SafetyTraining', 1, 0, 'C', '0', '0', 'riskctrl:safetyTraining:list', 'education', NULL, NOW(), NULL, NULL, NULL;

-- 安全培训按钮
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
SELECT '安全培训查询', 安全培训菜单ID, 1, '', NULL, NULL, '', 1, 0, 'F', '0', '0', 'riskctrl:safetyTraining:query', '#', NULL, NOW(), NULL, NULL, NULL;

INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
SELECT '安全培训新增', 安全培训菜单ID, 2, '', NULL, '', '', 1, 0, 'F', '0', '0', 'riskctrl:safetyTraining:add', '#', NULL, NOW(), NULL, NULL, NULL;

INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
SELECT '安全培训修改', 安全培训菜单ID, 3, '', NULL, '', '', 1, 0, 'F', '0', '0', 'riskctrl:safetyTraining:edit', '#', NULL, NOW(), NULL, NULL, NULL;

INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
SELECT '安全培训删除', 安全培训菜单ID, 4, '', NULL, '', '', 1, 0, 'F', '0', '0', 'riskctrl:safetyTraining:remove', '#', NULL, NOW(), NULL, NULL, NULL;

-- 安全培训字典数据
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `remark`) VALUES ('安全培训类型', 'safety_training_type', '0', NULL, NOW(), '安全培训类型');
SET @training_type_id = LAST_INSERT_ID();
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `status`, `create_by`, `create_time`, `remark`) VALUES 
(1, '安全知识', '安全知识', 'safety_training_type', '0', NULL, NOW(), NULL),
(2, '操作规范', '操作规范', 'safety_training_type', '0', NULL, NOW(), NULL),
(3, '应急预案', '应急预案', 'safety_training_type', '0', NULL, NOW(), NULL),
(4, '设备维护', '设备维护', 'safety_training_type', '0', NULL, NOW(), NULL);

INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `remark`) VALUES ('培训状态', 'training_status', '0', NULL, NOW(), '安全培训状态');
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `status`, `create_by`, `create_time`, `remark`) VALUES 
(1, '未开始', '未开始', 'training_status', '0', NULL, NOW(), NULL),
(2, '进行中', '进行中', 'training_status', '0', NULL, NOW(), NULL),
(3, '已结束', '已结束', 'training_status', '0', NULL, NOW(), NULL);