|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
/*!50503 SET NAMES utf8mb4 */;
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
DROP TABLE IF EXISTS `bpm_category`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_category` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '分类编号',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类名',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类标志',
|
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类描述',
|
`status` tinyint NOT NULL DEFAULT '0' COMMENT '分类状态（0正常 1停用）',
|
`sort` int NOT NULL DEFAULT '0' 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
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 流程分类表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_category` WRITE;
|
/*!40000 ALTER TABLE `bpm_category` DISABLE KEYS */;
|
/*!40000 ALTER TABLE `bpm_category` ENABLE KEYS */;
|
UNLOCK TABLES;
|
DROP TABLE IF EXISTS `bpm_form`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_form` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '表单名',
|
`status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
`conf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '表单的配置',
|
`fields` json NOT NULL COMMENT '表单项的数组',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 工作流表单定义表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_form` WRITE;
|
/*!40000 ALTER TABLE `bpm_form` DISABLE KEYS */;
|
/*!40000 ALTER TABLE `bpm_form` ENABLE KEYS */;
|
UNLOCK TABLES;
|
DROP TABLE IF EXISTS `bpm_user_group`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_user_group` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '组名',
|
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
|
`status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
`user_ids` json NOT 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
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 用户组表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_user_group` WRITE;
|
/*!40000 ALTER TABLE `bpm_user_group` DISABLE KEYS */;
|
/*!40000 ALTER TABLE `bpm_user_group` ENABLE KEYS */;
|
UNLOCK TABLES;
|
DROP TABLE IF EXISTS `bpm_process_listener`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_process_listener` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '监听器名字',
|
`status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '监听类型（execution执行监听器、task任务监听器）',
|
`event` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '监听事件',
|
`value_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '值类型（class类、delegateExpression委托表达式、expression表达式）',
|
`value` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 流程监听器表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_process_listener` WRITE;
|
/*!40000 ALTER TABLE `bpm_process_listener` DISABLE KEYS */;
|
/*!40000 ALTER TABLE `bpm_process_listener` ENABLE KEYS */;
|
UNLOCK TABLES;
|
DROP TABLE IF EXISTS `bpm_process_expression`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_process_expression` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '表达式名字',
|
`status` tinyint NOT NULL DEFAULT '0' COMMENT '表达式状态（0正常 1停用）',
|
`expression` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 流程表达式表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_process_expression` WRITE;
|
/*!40000 ALTER TABLE `bpm_process_expression` DISABLE KEYS */;
|
/*!40000 ALTER TABLE `bpm_process_expression` ENABLE KEYS */;
|
UNLOCK TABLES;
|
DROP TABLE IF EXISTS `bpm_process_definition_info`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_process_definition_info` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
|
`process_definition_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程定义的编号',
|
`model_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程模型的编号',
|
`model_type` tinyint NOT NULL DEFAULT '10' COMMENT '流程模型的类型',
|
`category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '流程分类的编码',
|
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
|
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
|
`form_type` tinyint NOT NULL DEFAULT '10' COMMENT '表单类型（10普通表单 20自定义表单）',
|
`form_id` bigint DEFAULT NULL COMMENT '动态表单编号',
|
`form_conf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '表单的配置',
|
`form_fields` json DEFAULT NULL COMMENT '表单项的数组',
|
`form_custom_create_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义表单的提交路径',
|
`form_custom_view_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义表单的查看路径',
|
`simple_model` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'SIMPLE 设计器模型数据',
|
`visible` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可见',
|
`sort` bigint NOT NULL DEFAULT '0' COMMENT '排序值',
|
`start_user_ids` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '可发起用户编号数组',
|
`start_dept_ids` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '可发起部门编号数组',
|
`manager_user_ids` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '可管理用户编号数组',
|
`allow_cancel_running_process` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否允许撤销审批中的申请',
|
`allow_withdraw_task` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否允许审批人撤回任务',
|
`process_id_rule` json DEFAULT NULL COMMENT '流程 ID 规则',
|
`auto_approval_type` tinyint DEFAULT NULL COMMENT '自动去重类型',
|
`title_setting` json DEFAULT NULL COMMENT '标题设置',
|
`summary_setting` json DEFAULT NULL COMMENT '摘要设置',
|
`process_before_trigger_setting` json DEFAULT NULL COMMENT '流程前置通知设置',
|
`process_after_trigger_setting` json DEFAULT NULL COMMENT '流程后置通知设置',
|
`task_before_trigger_setting` json DEFAULT NULL COMMENT '任务前置通知设置',
|
`task_after_trigger_setting` json DEFAULT NULL COMMENT '任务后置通知设置',
|
`print_template_setting` json 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
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 流程定义拓展信息表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_process_definition_info` WRITE;
|
/*!40000 ALTER TABLE `bpm_process_definition_info` DISABLE KEYS */;
|
/*!40000 ALTER TABLE `bpm_process_definition_info` ENABLE KEYS */;
|
UNLOCK TABLES;
|
DROP TABLE IF EXISTS `bpm_business_attach`;
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
/*!50503 SET character_set_client = utf8mb4 */;
|
CREATE TABLE `bpm_business_attach` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
|
`process_definition_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流程定义的 Key',
|
`business_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '业务类型，例如 erp_purchase_order',
|
`component_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务详情组件路径，例如 /erp/purchase/order/detail/index.vue',
|
`status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0开启 1关闭）',
|
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`deleted` bit(1) NOT NULL DEFAULT b'0',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `uk_process_definition_key` (`process_definition_key`,`deleted`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='BPM 业务附件配置表';
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
LOCK TABLES `bpm_business_attach` WRITE;
|
/*!40000 ALTER TABLE `bpm_business_attach` DISABLE KEYS */;
|
INSERT INTO `bpm_business_attach` VALUES (1,'purchase_order_approve','erp_purchase_order','/erp/purchase/order/detail/index.vue',0,'采购订单审批业务详情组件','1','2026-08-25 11:27:28','1','2026-08-25 11:27:28',_binary '\0'),(2,'sale_order_approve','erp_sale_order','/erp/sale/order/detail/index.vue',0,'销售订单审批业务详情组件','1','2026-08-28 16:54:09','1','2026-08-28 16:54:09',_binary '\0'),(3,'supplier_apply_approve','srm_supplier_apply','/srm/supplierApply/detail/index.vue',0,'供应商准入审批业务详情组件','1','2026-08-29 02:08:12','1','2026-08-29 02:08:12',_binary '\0'),(4,'1','1','1',0,NULL,'1','2026-09-18 16:28:34','1','2026-10-23 17:07:13',_binary '');
|
/*!40000 ALTER TABLE `bpm_business_attach` ENABLE KEYS */;
|
UNLOCK TABLES;
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
