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 | 31 ++++++++++++++-----------------
1 files changed, 14 insertions(+), 17 deletions(-)
diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index 04d89d7..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 '鑺傜偣閰嶇疆';
@@ -154,7 +151,7 @@
INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (44, '000000', 6, '宸查��鍥�', 'back', 'wf_business_status', '', 'danger', 'N', 103, 1, sysdate(), NULL, NULL, '宸查��鍥�');
INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (45, '000000', 7, '宸茬粓姝�', 'termination', 'wf_business_status', '', 'danger', 'N', 103, 1,sysdate(), NULL, NULL, '宸茬粓姝�');
INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (46, '000000', 1, '鑷畾涔夎〃鍗�', 'static', 'wf_form_type', '', 'success', 'N', 103, 1, sysdate(), NULL, NULL, '鑷畾涔夎〃鍗�');
-INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (47 '000000', 2, '鍔ㄦ�佽〃鍗�', 'dynamic', 'wf_form_type', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, '鍔ㄦ�佽〃鍗�');
+INSERT INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (47, '000000', 2, '鍔ㄦ�佽〃鍗�', 'dynamic', 'wf_form_type', '', 'primary', 'N', 103, 1, sysdate(), NULL, NULL, '鍔ㄦ�佽〃鍗�');
-- 琛ㄥ崟绠＄悊 SQL
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)
--
Gitblit v1.9.3