From 148ad7a3d157e53ab1483830b39968b0ddad746d Mon Sep 17 00:00:00 2001
From: gssong <1742057357@qq.com>
Date: 星期二, 26 三月 2024 22:00:31 +0800
Subject: [PATCH] update 补充工作流sql脚本
---
script/sql/flowable.sql | 45 +++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 43 insertions(+), 2 deletions(-)
diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index b7149e5..ab363fa 100644
--- a/script/sql/flowable.sql
+++ b/script/sql/flowable.sql
@@ -33,7 +33,7 @@
create_time datetime null comment '鍒涘缓鏃堕棿',
update_by bigint null comment '鏇存柊鑰�',
update_time datetime null comment '鏇存柊鏃堕棿',
- tenant_id varchar(20) default '000000' null comment '绉熸埛缂栧彿',
+ tenant_id varchar(20) null comment '绉熸埛缂栧彿',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB COMMENT = '璇峰亣鐢宠琛�';
@@ -47,7 +47,7 @@
category_code varchar(255) null comment '鍒嗙被缂栫爜',
parent_id bigint null comment '鐖剁骇id',
sort_num int(19) null comment '鎺掑簭',
- tenant_id varchar(20) default '000000' null comment '绉熸埛缂栧彿',
+ tenant_id varchar(20) null comment '绉熸埛缂栧彿',
create_dept bigint null comment '鍒涘缓閮ㄩ棬',
create_by bigint null comment '鍒涘缓鑰�',
create_time datetime null comment '鍒涘缓鏃堕棿',
@@ -58,6 +58,47 @@
) 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
+ primary key,
+ node_id varchar(255) not null comment '鑺傜偣id',
+ node_name varchar(255) not null comment '鑺傜偣鍚嶇О',
+ order_no int not null comment '鎺掑簭',
+ instance_id varchar(255) null comment '娴佺▼瀹炰緥id',
+ task_type varchar(255) not null comment '鑺傜偣绫诲瀷',
+ assignee varchar(2000) not 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 '鑺傜偣瀹℃壒璁板綍';
+
+DROP TABLE if EXISTS wf_form_definition;
+create table wf_form_definition
+(
+ id bigint not null comment '涓婚敭'
+ primary key,
+ path varchar(200) default '' not null comment '璺敱鍦板潃',
+ definition_id varchar(255) not null comment '娴佺▼瀹氫箟ID',
+ process_key varchar(255) not null comment '娴佺▼KEY',
+ 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 '鏇存柊鏃堕棿',
+ remark varchar(500) default '' null comment '澶囨敞',
+ tenant_id varchar(20) null comment '绉熸埛缂栧彿',
+ constraint uni_definition_id
+ unique (definition_id)
+)
+ 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, '璇峰亣鐢宠鑿滃崟');
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 (11639, '璇峰亣鐢宠鏌ヨ', 11638, 1, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:query', '#', 103, 1, sysdate(), NULL, NULL, '');
--
Gitblit v1.9.3