From 18e3b424d603aed47408081bf66398532b24df12 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期日, 28 四月 2024 12:31:59 +0800
Subject: [PATCH] fix 修复 兼容redis5.0出现的问题

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

diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index 4c03f8d..ce215a7 100644
--- a/script/sql/flowable.sql
+++ b/script/sql/flowable.sql
@@ -79,9 +79,10 @@
 (
     id            bigint                        not null comment '涓婚敭'
         primary key,
-    form_id       bigint                        not null comment '琛ㄥ崟ID',
+    table_name    varchar(255)                  not null comment '琛ㄥ悕',
     definition_id varchar(255)                  not null comment '娴佺▼瀹氫箟ID',
     process_key   varchar(255)                  not null comment '娴佺▼KEY',
+    version       int(10)                       not null comment '娴佺▼鐗堟湰',
     create_dept   bigint                        null comment '鍒涘缓閮ㄩ棬',
     create_by     bigint                        null comment '鍒涘缓鑰�',
     create_time   datetime                      null comment '鍒涘缓鏃堕棿',
@@ -115,19 +116,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