From 17bf0c06236c2956ad9b6fe2b89524de7a0c608c Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期六, 27 四月 2024 16:15:14 +0800
Subject: [PATCH] update 优化 代码生成表导入 排除工作流相关表
---
script/sql/postgres/flowable.sql | 38 +++++++++++++++++++++-----------------
1 files changed, 21 insertions(+), 17 deletions(-)
diff --git a/script/sql/postgres/flowable.sql b/script/sql/postgres/flowable.sql
index 60b6cca..a44b051 100644
--- a/script/sql/postgres/flowable.sql
+++ b/script/sql/postgres/flowable.sql
@@ -19,7 +19,6 @@
insert into sys_menu values ('11626', '娴佺▼鍒嗙被鍒犻櫎', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, now(), null, null, '');
insert into sys_menu values ('11627', '娴佺▼鍒嗙被瀵煎嚭', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, now(), null, null, '');
-- 璇峰亣鍗曚俊鎭�
-DROP TABLE if EXISTS test_leave;
create table test_leave
(
id bigint not null
@@ -66,7 +65,6 @@
owner to postgres;
-- 娴佺▼鍒嗙被淇℃伅琛�
-DROP TABLE if EXISTS wf_category;
create table wf_category
(
id bigint not null
@@ -171,9 +169,10 @@
id bigint not null
constraint pk_wf_definition_config
primary key,
- form_id bigint(20) not null,
+ table_name varchar(255) not null,
definition_id varchar(255) not null,
- process_key varchar(255) not null,
+ process_key varchar(255) not null,
+ version bigint not null,
tenant_id varchar(20),
create_dept bigint,
create_by bigint,
@@ -186,11 +185,13 @@
comment on column wf_definition_config.id is '涓婚敭';
-comment on column wf_definition_config.form_id is '琛ㄥ崟ID';
+comment on column wf_definition_config.table_name is '琛ㄥ悕';
comment on column wf_definition_config.definition_id is '娴佺▼瀹氫箟ID';
comment on column wf_definition_config.process_key is '娴佺▼KEY';
+
+comment on column wf_definition_config.version is '娴佺▼鐗堟湰';
comment on column wf_definition_config.tenant_id is '绉熸埛id';
@@ -254,20 +255,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 '鑺傜偣閰嶇疆';
@@ -284,6 +286,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