devbox
代码架构师
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

ruoyi-vue-pro yudao 项目bpm模块启用及相关SQL脚本_工作流模块 yudao-module-bpm - 表结构未导入

作者：代码架构师 | 2024-01-30 20:16:45

赞

踩

工作流模块 yudao-module-bpm - 表结构未导入

目前ruoyi-vue-pro 项目虽然开源，但是bpm模块被屏蔽了，查看文档却要收费 199元（知识星球），价格有点太高了吧。

分享下如何启用 bpm 模块，顺便贴上sql相关脚本。

一、启用模块

修改根目录 pom.xml

启用模块参与编译

 二、修改 yudao-server pom.xml， 启用模块

三、启动项目，数据库表如下

 bpm 开头的表需要额外脚本导入

  1. -- ----------------------------
  2. -- Table structure for bpm_form
  3. -- ----------------------------
  4. DROP TABLE IF EXISTS `bpm_form`;
  5. CREATE TABLE `bpm_form`  (
  6.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  7.   `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '表单名',
  8.   `status` tinyint NOT NULL COMMENT '开启状态',
  9.   `conf` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '表单的配置',
  10.   `fields` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '表单项的数组',
  11.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  12.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  13.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  14.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  15.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  16.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  17.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  18.   PRIMARY KEY (`id`) USING BTREE
  19. ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '工作流的表单定义';
  20.  
  21. -- ----------------------------
  22. -- Records of bpm_form
  23. -- ----------------------------
  24. BEGIN;
  25. COMMIT;
  26.  
  27. -- ----------------------------
  28. -- Table structure for bpm_oa_leave
  29. -- ----------------------------
  30. DROP TABLE IF EXISTS `bpm_oa_leave`;
  31. CREATE TABLE `bpm_oa_leave`  (
  32.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '请假表单主键',
  33.   `user_id` bigint NOT NULL COMMENT '申请人的用户编号',
  34.   `type` tinyint NOT NULL COMMENT '请假类型',
  35.   `reason` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请假原因',
  36.   `start_time` datetime NOT NULL COMMENT '开始时间',
  37.   `end_time` datetime NOT NULL COMMENT '结束时间',
  38.   `day` tinyint NOT NULL COMMENT '请假天数',
  39.   `result` tinyint NOT NULL COMMENT '请假结果',
  40.   `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '流程实例的编号',
  41.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  42.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  43.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  44.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  45.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  46.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  47.   PRIMARY KEY (`id`) USING BTREE
  48. ) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'OA 请假申请表';
  49.  
  50. -- ----------------------------
  51. -- Records of bpm_oa_leave
  52. -- ----------------------------
  53. BEGIN;
  54. COMMIT;
  55.  
  56. -- ----------------------------
  57. -- Table structure for bpm_process_definition_ext
  58. -- ----------------------------
  59. DROP TABLE IF EXISTS `bpm_process_definition_ext`;
  60. CREATE TABLE `bpm_process_definition_ext`  (
  61.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  62.   `process_definition_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程定义的编号',
  63.   `model_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程模型的编号',
  64.   `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  65.   `form_type` tinyint NOT NULL COMMENT '表单类型',
  66.   `form_id` bigint NULL DEFAULT NULL COMMENT '表单编号',
  67.   `form_conf` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '表单的配置',
  68.   `form_fields` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '表单项的数组',
  69.   `form_custom_create_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '自定义表单的提交路径',
  70.   `form_custom_view_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '自定义表单的查看路径',
  71.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  72.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  73.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  74.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  75.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  76.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  77.   PRIMARY KEY (`id`) USING BTREE
  78. ) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Bpm 流程定义的拓展表\n';
  79.  
  80. -- ----------------------------
  81. -- Records of bpm_process_definition_ext
  82. -- ----------------------------
  83. BEGIN;
  84. COMMIT;
  85.  
  86. -- ----------------------------
  87. -- Table structure for bpm_process_instance_ext
  88. -- ----------------------------
  89. DROP TABLE IF EXISTS `bpm_process_instance_ext`;
  90. CREATE TABLE `bpm_process_instance_ext`  (
  91.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  92.   `start_user_id` bigint NOT NULL COMMENT '发起流程的用户编号',
  93.   `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '流程实例的名字',
  94.   `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程实例的编号',
  95.   `process_definition_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程定义的编号',
  96.   `category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '流程分类',
  97.   `status` tinyint NOT NULL COMMENT '流程实例的状态',
  98.   `result` tinyint NOT NULL COMMENT '流程实例的结果',
  99.   `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  100.   `form_variables` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '表单值',
  101.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  102.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  103.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  104.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  105.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  106.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  107.   PRIMARY KEY (`id`) USING BTREE
  108. ) ENGINE = InnoDB AUTO_INCREMENT = 296 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '工作流的流程实例的拓展';
  109.  
  110. -- ----------------------------
  111. -- Records of bpm_process_instance_ext
  112. -- ----------------------------
  113. BEGIN;
  114. COMMIT;
  115.  
  116. -- ----------------------------
  117. -- Table structure for bpm_task_assign_rule
  118. -- ----------------------------
  119. DROP TABLE IF EXISTS `bpm_task_assign_rule`;
  120. CREATE TABLE `bpm_task_assign_rule`  (
  121.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  122.   `model_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程模型的编号',
  123.   `process_definition_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程定义的编号',
  124.   `task_definition_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程任务定义的 key',
  125.   `type` tinyint NOT NULL COMMENT '规则类型',
  126.   `options` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则值，JSON 数组',
  127.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  128.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  129.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  130.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  131.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  132.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  133.   PRIMARY KEY (`id`) USING BTREE
  134. ) ENGINE = InnoDB AUTO_INCREMENT = 276 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Bpm 任务规则表';
  135.  
  136. -- ----------------------------
  137. -- Records of bpm_task_assign_rule
  138. -- ----------------------------
  139. BEGIN;
  140. COMMIT;
  141.  
  142. -- ----------------------------
  143. -- Table structure for bpm_task_ext
  144. -- ----------------------------
  145. DROP TABLE IF EXISTS `bpm_task_ext`;
  146. CREATE TABLE `bpm_task_ext`  (
  147.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  148.   `assignee_user_id` bigint NULL DEFAULT NULL COMMENT '任务的审批人',
  149.   `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '任务的名字',
  150.   `task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务的编号',
  151.   `result` tinyint NOT NULL COMMENT '任务的结果',
  152.   `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '审批建议',
  153.   `end_time` datetime NULL DEFAULT NULL COMMENT '任务的结束时间',
  154.   `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程实例的编号',
  155.   `process_definition_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程定义的编号',
  156.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  157.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  158.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  159.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  160.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  161.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  162.   PRIMARY KEY (`id`) USING BTREE
  163. ) ENGINE = InnoDB AUTO_INCREMENT = 351 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '工作流的流程任务的拓展表';
  164.  
  165. -- ----------------------------
  166. -- Records of bpm_task_ext
  167. -- ----------------------------
  168. BEGIN;
  169. COMMIT;
  170.  
  171. -- ----------------------------
  172. -- Table structure for bpm_user_group
  173. -- ----------------------------
  174. DROP TABLE IF EXISTS `bpm_user_group`;
  175. CREATE TABLE `bpm_user_group`  (
  176.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  177.   `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组名',
  178.   `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述',
  179.   `member_user_ids` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '成员编号数组',
  180.   `status` tinyint NOT NULL COMMENT '状态（0正常 1停用）',
  181.   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  182.   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  183.   `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  184.   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  185.   `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  186.   `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  187.   PRIMARY KEY (`id`) USING BTREE
  188. ) ENGINE = InnoDB AUTO_INCREMENT = 113 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户组';
  189.  
  190. -- ----------------------------
  191. -- Records of bpm_user_group
  192. -- ----------------------------

四、写在后面

需要其他模块开启的请留言

ruoyi-vue-pro yudao 项目商城 mall 模块启用及相关SQL脚本

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/article/detail/49105
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号