From 651b2e140ba842126c4177df1b909b2b764ecdb8 Mon Sep 17 00:00:00 2001
From: gssong <1742057357@qq.com>
Date: 星期日, 31 三月 2024 15:34:27 +0800
Subject: [PATCH] add 添加表单配置
---
script/sql/flowable.sql | 44 ++++++++++++++++++++++++++++++++++++++++----
1 files changed, 40 insertions(+), 4 deletions(-)
diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index ab363fa..f08ad05 100644
--- a/script/sql/flowable.sql
+++ b/script/sql/flowable.sql
@@ -78,12 +78,12 @@
)
comment '鑺傜偣瀹℃壒璁板綍';
-DROP TABLE if EXISTS wf_form_definition;
-create table wf_form_definition
+DROP TABLE if EXISTS wf_definition_config;
+create table wf_definition_config
(
id bigint not null comment '涓婚敭'
primary key,
- path varchar(200) default '' not null comment '璺敱鍦板潃',
+ form_id bigint not null comment '琛ㄥ崟ID',
definition_id varchar(255) not null comment '娴佺▼瀹氫箟ID',
process_key varchar(255) not null comment '娴佺▼KEY',
create_dept bigint null comment '鍒涘缓閮ㄩ棬',
@@ -96,8 +96,44 @@
constraint uni_definition_id
unique (definition_id)
)
- comment '琛ㄥ崟閰嶇疆';
+ comment '娴佺▼瀹氫箟閰嶇疆';
+create table wf_form_manage
+(
+ id bigint not null comment '涓婚敭'
+ primary key,
+ form_name varchar(255) not null comment '琛ㄥ崟鍚嶇О',
+ form_type varchar(255) not null comment '琛ㄥ崟绫诲瀷',
+ router varchar(255) not null comment '璺敱鍦板潃/琛ㄥ崟ID',
+ remark varchar(500) null comment '澶囨敞',
+ tenant_id varchar(20) null comment '绉熸埛缂栧彿',
+ 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 '鏇存柊鏃堕棿'
+)
+ comment '琛ㄥ崟绠＄悊';
+
+insert into wf_form_manage(id, form_name, form_type, router, remark, tenant_id, create_dept, create_by, create_time, update_by, update_time) VALUES (1, '璇峰亣鐢宠', 'static', '/demo/leaveEdit/index', NULL, '000000', 103, 1, sysdate(), 1, sysdate());
+
+create table wf_node_config
+(
+ 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 '绉熸埛缂栧彿'
+)
+ comment '鑺傜偣閰嶇疆';
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11638, '璇峰亣鐢宠', 5, 1, 'leave', 'workflow/leave/index', 1, 0, 'C', '0', '0', 'demo:leave:list', '#', 103, 1, sysdate(), NULL, NULL, '璇峰亣鐢宠鑿滃崟');
--
Gitblit v1.9.3