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/postgres/flowable.sql | 27 +++++++++++++++------------
1 files changed, 15 insertions(+), 12 deletions(-)
diff --git a/script/sql/postgres/flowable.sql b/script/sql/postgres/flowable.sql
index f20426d..c67e527 100644
--- a/script/sql/postgres/flowable.sql
+++ b/script/sql/postgres/flowable.sql
@@ -252,20 +252,21 @@
create table wf_node_config
(
- id bigint not null
+ id bigint not null
constraint pk_wf_node_config
primary key,
- form_id bigint,
- form_type varchar(255),
- node_name varchar(255) not null,
- node_id varchar(255) not null,
- definition_id varchar(255) not null,
- tenant_id varchar(20),
- create_dept bigint,
- create_by bigint,
- create_time timestamp,
- update_by bigint,
- update_time timestamp
+ form_id bigint,
+ form_type varchar(255),
+ node_name varchar(255) not null,
+ node_id varchar(255) not null,
+ definition_id varchar(255) not null,
+ apply_user_task char(1) default '0',
+ tenant_id varchar(20),
+ create_dept bigint,
+ create_by bigint,
+ create_time timestamp,
+ update_by bigint,
+ update_time timestamp
);
comment on table wf_node_config is '鑺傜偣閰嶇疆';
@@ -282,6 +283,8 @@
comment on column wf_node_config.definition_id is '娴佺▼瀹氫箟id';
+comment on column wf_node_config.apply_user_task is '鏄惁涓虹敵璇蜂汉鑺傜偣 锛�0鏄� 1鍚︼級';
+
comment on column wf_node_config.tenant_id is '绉熸埛id';
comment on column wf_node_config.create_dept is '鍒涘缓閮ㄩ棬';
--
Gitblit v1.9.3