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 | 29 +++++++++++++----------------
1 files changed, 13 insertions(+), 16 deletions(-)
diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index 1d414e8..36ca5c9 100644
--- a/script/sql/flowable.sql
+++ b/script/sql/flowable.sql
@@ -19,7 +19,6 @@
insert into sys_menu values ('11626', '娴佺▼鍒嗙被鍒犻櫎', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, sysdate(), null, null, '');
insert into sys_menu values ('11627', '娴佺▼鍒嗙被瀵煎嚭', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, sysdate(), null, null, '');
-- 璇峰亣鍗曚俊鎭�
-DROP TABLE if EXISTS test_leave;
create table test_leave
(
id bigint not null comment '涓婚敭',
@@ -38,7 +37,6 @@
) ENGINE = InnoDB COMMENT = '璇峰亣鐢宠琛�';
-- 娴佺▼鍒嗙被淇℃伅琛�
-DROP TABLE if EXISTS wf_category;
create table wf_category
(
id bigint not null comment '涓婚敭'
@@ -58,7 +56,6 @@
) engine=innodb comment= '娴佺▼鍒嗙被';
INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate(), 1, sysdate());
-DROP TABLE if EXISTS wf_task_back_node;
create table wf_task_back_node
(
id bigint not null
@@ -78,7 +75,6 @@
)
comment '鑺傜偣瀹℃壒璁板綍';
-DROP TABLE if EXISTS wf_definition_config;
create table wf_definition_config
(
id bigint not null comment '涓婚敭'
@@ -119,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