猿道OA启动问题

根pom文件打开注释掉的模块

service模块打开注释掉的工作流依赖

mysql需要建几张表

接口BpmProcessInstanceService有多个实现类 需要处理 否则启动报错

CREATE TABLE `bpm_form` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(64) NOT NULL,
  `STATUS` tinyint(4) NOT NULL,
  `CONF` varchar(1000) NOT NULL,
  `FIELDS` varchar(5000) NOT NULL,
  `REMARK` varchar(255) DEFAULT NULL,
  `CREATOR` varchar(64) DEFAULT '',
  `CREATE_TIME` timestamp NULL DEFAULT NULL,
  `UPDATER` varchar(64) DEFAULT '',
  `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED` bit(1) NOT NULL DEFAULT b'0',
  `TENANT_ID` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `bpm_process_definition_ext` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PROCESS_DEFINITION_ID` varchar(64) NOT NULL,
  `MODEL_ID` varchar(64) NOT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `FORM_TYPE` tinyint(4) NOT NULL,
  `FORM_ID` bigint(20) DEFAULT NULL,
  `FORM_CONF` varchar(1000) DEFAULT NULL,
  `FORM_FIELDS` varchar(5000) DEFAULT NULL,
  `FORM_CUSTOM_CREATE_PATH` varchar(255) DEFAULT NULL,
  `FORM_CUSTOM_VIEW_PATH` varchar(255) DEFAULT NULL,
  `CREATOR` varchar(64) DEFAULT '',
  `CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATER` varchar(64) DEFAULT '',
  `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED` bit(1) NOT NULL DEFAULT b'0',
  `TENANT_ID` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `bpm_process_instance_ext` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `START_USER_ID` bigint(20) NOT NULL,
  `NAME` varchar(64) DEFAULT NULL,
  `PROCESS_INSTANCE_ID` varchar(64) NOT NULL,
  `PROCESS_DEFINITION_ID` varchar(64) NOT NULL,
  `CATEGORY` varchar(64) DEFAULT NULL,
  `STATUS` tinyint(4) NOT NULL,
  `RESULT` tinyint(4) NOT NULL,
  `END_TIME` timestamp NULL DEFAULT NULL,
  `FORM_VARIABLES` varchar(5000) DEFAULT NULL,
  `CREATOR` varchar(64) DEFAULT '',
  `CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATER` varchar(64) DEFAULT '',
  `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED` bit(1) NOT NULL DEFAULT b'0',
  `TENANT_ID` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `bpm_task_assign_rule` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `MODEL_ID` varchar(64) NOT NULL,
  `PROCESS_DEFINITION_ID` varchar(64) NOT NULL,
  `TASK_DEFINITION_KEY` varchar(64) NOT NULL,
  `TYPE` tinyint(4) NOT NULL,
  `OPTIONS` varchar(1024) NOT NULL,
  `CREATOR` varchar(64) DEFAULT '',
  `CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATER` varchar(64) DEFAULT '',
  `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED` bit(1) NOT NULL DEFAULT b'0',
  `TENANT_ID` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `bpm_task_ext` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `assignee_user_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `result` int(11) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `process_instance_id` varchar(255) DEFAULT NULL,
  `process_definition_id` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `updater` varchar(255) DEFAULT NULL,
  `deleted` tinyint(1) unsigned zerofill DEFAULT NULL,
  `tenant_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `bpm_user_group` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(30) NOT NULL DEFAULT '',
  `DESCRIPTION` varchar(255) NOT NULL DEFAULT '',
  `MEMBER_USER_IDS` varchar(1024) NOT NULL DEFAULT '0',
  `STATUS` tinyint(4) NOT NULL,
  `CREATOR` varchar(64) DEFAULT '',
  `CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATER` varchar(64) DEFAULT '',
  `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED` bit(1) NOT NULL DEFAULT b'0',
  `TENANT_ID` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;