From 5360ec6ec3bf356a554df624e884a0bb1090fa4b Mon Sep 17 00:00:00 2001 From: gssong <1742057357@qq.com> Date: 星期日, 17 三月 2024 18:25:20 +0800 Subject: [PATCH] add 添加节点审批记录，调整流程驳回 --- script/sql/flowable.sql | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql index b7149e5..7eb8d6b 100644 --- a/script/sql/flowable.sql +++ b/script/sql/flowable.sql @@ -58,6 +58,26 @@ ) 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 varchar(255) 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) default '000000' 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 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