-- =========================================
-- 课题管理模块（yudao-module-research）一期
-- 建表 + 字典数据 + BPM 分类 + 菜单
-- 覆盖需求：1.课题指南发布 2.课题在线申报 3.课题评审流程 4.立项审批 5.经费拨付
-- 二期（结项验收/结项证书、成果归档知识库）不在此脚本内
-- =========================================

-- ----- 1. 课题指南表 -----
DROP TABLE IF EXISTS `research_guideline`;
CREATE TABLE `research_guideline` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '指南编号',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '指南名称',
  `category` tinyint NOT NULL COMMENT '课题类别：1-重点课题 2-一般课题',
  `apply_start_time` datetime DEFAULT NULL COMMENT '申报开始时间',
  `apply_end_time` datetime DEFAULT NULL COMMENT '申报截止时间',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '指南正文',
  `publish_status` tinyint NOT NULL DEFAULT '0' COMMENT '发布状态：0-草稿 20-已发布 30-已截止',
  `publish_time` datetime DEFAULT NULL COMMENT '发布时间',
  `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_no` (`no`) USING BTREE,
  KEY `idx_category` (`category`) USING BTREE,
  KEY `idx_publish_status` (`publish_status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课题-指南';

-- ----- 2. 课题申报书表 -----
DROP TABLE IF EXISTS `research_application`;
CREATE TABLE `research_application` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申报编号',
  `guideline_id` bigint NOT NULL COMMENT '所属课题指南 ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '课题名称',
  `category` tinyint NOT NULL COMMENT '课题类别：1-重点课题 2-一般课题（冗余自指南）',
  `member_id` bigint DEFAULT NULL COMMENT '申报会员 ID（关联 ums_member）',
  `applicant_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申报人姓名/单位名称',
  `applicant_user_id` bigint DEFAULT NULL COMMENT '申报登录用户 ID',
  `work_unit` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '工作单位',
  `job_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '职称',
  `contact_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '联系电话',
  `contact_email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '联系邮箱',
  `team_members` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '课题组成员（每行一条：姓名|单位|职称）',
  `budget_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '申请经费（元）',
  `plan_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '申报书正文（研究背景/目标/方案/预期成果）',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态：0-草稿 15-审批中 20-已立项 35-已驳回',
  `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'BPM 流程实例 ID',
  `review_avg_score` decimal(6,2) DEFAULT NULL COMMENT '专家评审加权均分（后端汇总）',
  `review_pass` tinyint DEFAULT NULL COMMENT '评审结论：0-未通过 1-推荐立项（后端汇总）',
  `research_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '立项编号（审批通过后生成）',
  `approve_time` datetime DEFAULT NULL COMMENT '立项时间',
  `notice_id` bigint DEFAULT NULL COMMENT '已发布的立项通知公告 ID',
  `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_no` (`no`) USING BTREE,
  KEY `idx_guideline_id` (`guideline_id`) USING BTREE,
  KEY `idx_member_id` (`member_id`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_applicant_user_id` (`applicant_user_id`) USING BTREE,
  KEY `idx_research_no` (`research_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课题-申报书';

-- ----- 3. 专家评审明细表（一主单挂多行，每行一位专家） -----
DROP TABLE IF EXISTS `research_topic_review`;
CREATE TABLE `research_topic_review` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `application_id` bigint NOT NULL COMMENT '课题申报书 ID',
  `evaluator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '专家姓名',
  `evaluator_unit` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '专家所在单位',
  `evaluator_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '专家职称',
  `topic_score` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '选题价值与意义得分（权重0.3）',
  `plan_score` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '研究方案可行性得分（权重0.3）',
  `team_score` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '团队与研究基础得分（权重0.2）',
  `result_score` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '预期成果与效益得分（权重0.2）',
  `composite_score` decimal(6,2) DEFAULT NULL COMMENT '加权合计得分（后端计算）',
  `ranking` int DEFAULT NULL COMMENT '本申报单内评分排名（后端计算）',
  `conclusion` tinyint DEFAULT NULL COMMENT '评审结论：1-推荐立项 2-不推荐立项',
  `opinion` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '评审意见',
  `review_time` datetime DEFAULT NULL COMMENT '评审时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_application_id` (`application_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课题-专家评审明细';

-- ----- 4. 经费拨付记录表 -----
DROP TABLE IF EXISTS `research_fund_record`;
CREATE TABLE `research_fund_record` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `application_id` bigint NOT NULL COMMENT '课题申报书 ID',
  `batch_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '拨付批次（如：第一期）',
  `amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '拨付金额（元）',
  `pay_date` date DEFAULT NULL COMMENT '拨付日期',
  `payee` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '收款单位/账户名',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态：0-待拨付 15-报销审批中 20-已拨付 30-已驳回',
  `reimbursement_id` bigint DEFAULT NULL COMMENT '关联财务报销单 ID（finance_reimbursement.id）',
  `reimbursement_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '关联财务报销单号',
  `reject_reason` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '报销驳回原因（BPM 回写）',
  `reject_time` datetime DEFAULT NULL COMMENT '报销驳回时间',
  `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_application_id` (`application_id`) USING BTREE,
  KEY `idx_reimbursement_id` (`reimbursement_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课题-经费拨付记录';

-- ----- 5. 字典数据 -----

-- research_guideline_category（课题指南类别）
DELETE FROM system_dict_type WHERE `type` = 'research_guideline_category';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (81000, '课题指南类别', 'research_guideline_category', 0, '重点课题/一般课题分类标注', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'research_guideline_category';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100001, 1, '重点课题', '1', 'research_guideline_category', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100002, 2, '一般课题', '2', 'research_guideline_category', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');

-- research_guideline_status（课题指南发布状态）
DELETE FROM system_dict_type WHERE `type` = 'research_guideline_status';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (81001, '课题指南状态', 'research_guideline_status', 0, '课题指南发布状态', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'research_guideline_status';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100101, 1, '草稿', '0', 'research_guideline_status', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100102, 2, '已发布', '20', 'research_guideline_status', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100103, 3, '已截止', '30', 'research_guideline_status', 0, 'info', '', '1', NOW(), '1', NOW(), b'0');

-- research_application_status（课题申报书状态）
DELETE FROM system_dict_type WHERE `type` = 'research_application_status';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (81002, '课题申报状态', 'research_application_status', 0, '课题申报书审批状态', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'research_application_status';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100201, 1, '草稿', '0', 'research_application_status', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100202, 2, '审批中', '15', 'research_application_status', 0, 'processing', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100203, 3, '已立项', '20', 'research_application_status', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100204, 4, '已驳回', '35', 'research_application_status', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');

-- research_review_conclusion（专家评审结论）
DELETE FROM system_dict_type WHERE `type` = 'research_review_conclusion';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (81003, '专家评审结论', 'research_review_conclusion', 0, '专家评审推荐立项/不推荐立项', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'research_review_conclusion';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100301, 1, '推荐立项', '1', 'research_review_conclusion', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100302, 2, '不推荐立项', '2', 'research_review_conclusion', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');

-- research_fund_status（经费拨付状态）
DELETE FROM system_dict_type WHERE `type` = 'research_fund_status';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (81004, '经费拨付状态', 'research_fund_status', 0, '课题经费待拨付/报销审批中/已拨付/已驳回', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'research_fund_status';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100401, 1, '待拨付', '0', 'research_fund_status', 0, 'warning', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100403, 2, '报销审批中', '15', 'research_fund_status', 0, 'processing', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100402, 3, '已拨付', '20', 'research_fund_status', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8100404, 4, '已驳回', '30', 'research_fund_status', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');

-- ----- 6. BPM 分类 -----
DELETE FROM bpm_category WHERE `code` = 'research_topic_approve';
INSERT INTO bpm_category (id, name, code, description, status, sort, creator, create_time, updater, update_time, deleted)
VALUES (8002, '课题立项审批', 'research_topic_approve', '课题申报三级审批（秘书处形式审查→专家评审→学会立项审批）', 0, 2, '1', NOW(), '1', NOW(), b'0');

-- ----- 7. 菜单 -----
-- 注意：菜单 ID 不要与现有菜单冲突（课题管理占用 1075510~1075553）
-- 顶级目录（type=1），parent_id=0，图标 ep:notebook
DELETE FROM system_menu WHERE id BETWEEN 1075510 AND 1075559;
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075510, '课题管理', '', 1, 81, 0, '/research', 'ep:notebook', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0');

-- 课题指南（菜单，type=2）
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075511, '课题指南', '', 2, 1, 1075510, 'guideline', 'ep:document', 'research/guideline/index', 'ResearchGuideline', 0, b'1', b'1', b'0', '1', NOW(), '1', NOW(), b'0');

-- 课题申报（菜单，type=2）
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075512, '课题申报', '', 2, 2, 1075510, 'application', 'ep:edit-pen', 'research/application/index', 'ResearchApplication', 0, b'1', b'1', b'0', '1', NOW(), '1', NOW(), b'0');

-- 按钮权限（type=3）—— 课题指南
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075520, '课题指南查询', 'research:guideline:query', 3, 1, 1075511, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075521, '课题指南创建', 'research:guideline:create', 3, 2, 1075511, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075522, '课题指南更新', 'research:guideline:update', 3, 3, 1075511, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075523, '课题指南删除', 'research:guideline:delete', 3, 4, 1075511, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075524, '课题指南发布/截止', 'research:guideline:publish', 3, 5, 1075511, '1', NOW(), '1', NOW(), b'0');

-- 按钮权限 —— 课题申报
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075530, '课题申报查询', 'research:application:query', 3, 1, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075531, '课题申报创建', 'research:application:create', 3, 2, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075532, '课题申报更新', 'research:application:update', 3, 3, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075533, '课题申报删除', 'research:application:delete', 3, 4, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075534, '课题申报提交审批', 'research:application:submit', 3, 5, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075535, '发布立项通知', 'research:application:notice', 3, 6, 1075512, '1', NOW(), '1', NOW(), b'0');

-- 按钮权限 —— 专家评审明细
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075540, '专家评审查询', 'research:review:query', 3, 7, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075541, '专家评审录入', 'research:review:create', 3, 8, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075542, '专家评审修改', 'research:review:update', 3, 9, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075543, '专家评审删除', 'research:review:delete', 3, 10, 1075512, '1', NOW(), '1', NOW(), b'0');

-- 按钮权限 —— 经费拨付
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075550, '经费拨付查询', 'research:fund:query', 3, 11, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075551, '经费拨付登记', 'research:fund:create', 3, 12, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075552, '经费拨付修改', 'research:fund:update', 3, 13, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075553, '经费拨付删除', 'research:fund:delete', 3, 14, 1075512, '1', NOW(), '1', NOW(), b'0');