From eb03afef41dc6c57b9c6e0c6e64c384556092d95 Mon Sep 17 00:00:00 2001
From: gssong <1742057357@qq.com>
Date: 星期六, 06 四月 2024 11:29:42 +0800
Subject: [PATCH] update 补充节点配置sql

---
 script/sql/flowable.sql |   25 +++++++++++++------------
 1 files changed, 13 insertions(+), 12 deletions(-)

diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index 4c03f8d..36ca5c9 100644
--- a/script/sql/flowable.sql
+++ b/script/sql/flowable.sql
@@ -115,19 +115,20 @@
 
 create table wf_node_config
 (
-    id            bigint       not null comment '涓婚敭'
+    id               bigint       not null comment '涓婚敭'
         primary key,
-    form_id       bigint       null comment '琛ㄥ崟id',
-    form_type     varchar(255) null comment '琛ㄥ崟绫诲瀷',
-    node_name     varchar(255) not null comment '鑺傜偣鍚嶇О',
-    node_id       varchar(255) not null comment '鑺傜偣id',
-    definition_id varchar(255) not null comment '娴佺▼瀹氫箟id',
-    create_dept   bigint       null comment '鍒涘缓閮ㄩ棬',
-    create_by     bigint       null comment '鍒涘缓鑰�',
-    create_time   datetime     null comment '鍒涘缓鏃堕棿',
-    update_by     bigint       null comment '鏇存柊鑰�',
-    update_time   datetime     null comment '鏇存柊鏃堕棿',
-    tenant_id     varchar(20)  null comment '绉熸埛缂栧彿'
+    form_id          bigint       null comment '琛ㄥ崟id',
+    form_type        varchar(255) null comment '琛ㄥ崟绫诲瀷',
+    node_name        varchar(255) not null comment '鑺傜偣鍚嶇О',
+    node_id          varchar(255) not null comment '鑺傜偣id',
+    definition_id    varchar(255) not null comment '娴佺▼瀹氫箟id',
+    apply_user_task  char(1)      default '0'     comment '鏄惁涓虹敵璇蜂汉鑺傜偣 锛�0鏄� 1鍚︼級',
+    create_dept      bigint       null comment '鍒涘缓閮ㄩ棬',
+    create_by        bigint       null comment '鍒涘缓鑰�',
+    create_time      datetime     null comment '鍒涘缓鏃堕棿',
+    update_by        bigint       null comment '鏇存柊鑰�',
+    update_time      datetime     null comment '鏇存柊鏃堕棿',
+    tenant_id        varchar(20)  null comment '绉熸埛缂栧彿'
 )
     comment '鑺傜偣閰嶇疆';
 

--
Gitblit v1.9.3