From 3879fa5df2e9a80e924d9df55e11a65de7dd71a2 Mon Sep 17 00:00:00 2001
From: TomXin <766781886@qq.com>
Date: 星期一, 13 五月 2024 16:29:43 +0800
Subject: [PATCH] 修正Oracle的sql
---
script/sql/oracle/flowable.sql | 220 ++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 193 insertions(+), 27 deletions(-)
diff --git a/script/sql/oracle/flowable.sql b/script/sql/oracle/flowable.sql
index 308c7c4..0773c39 100644
--- a/script/sql/oracle/flowable.sql
+++ b/script/sql/oracle/flowable.sql
@@ -35,22 +35,22 @@
CREATE_TIME DATE,
UPDATE_BY NUMBER(20),
UPDATE_TIME DATE,
- TENANT_ID VARCHAR2(255) default '000000'
+ TENANT_ID VARCHAR2(20)
);
-comment on table TEST_LEAVE is '璇峰亣鐢宠琛�'
-comment on column TEST_LEAVE.ID is '涓婚敭'
-comment on column TEST_LEAVE.LEAVE_TYPE is '璇峰亣绫诲瀷'
-comment on column TEST_LEAVE.START_DATE is '寮�濮嬫椂闂�'
-comment on column TEST_LEAVE.END_DATE is '缁撴潫鏃堕棿'
-comment on column TEST_LEAVE.LEAVE_DAYS is '璇峰亣澶╂暟'
-comment on column TEST_LEAVE.REMARK is '璇峰亣鍘熷洜'
-comment on column TEST_LEAVE.CREATE_DEPT is '鍒涘缓閮ㄩ棬'
-comment on column TEST_LEAVE.CREATE_BY is '鍒涘缓鑰�'
-comment on column TEST_LEAVE.CREATE_TIME is '鍒涘缓鏃堕棿'
-comment on column TEST_LEAVE.UPDATE_BY is '鏇存柊鑰�'
-comment on column TEST_LEAVE.UPDATE_TIME is '鏇存柊鏃堕棿'
-comment on column TEST_LEAVE.TENANT_ID is '绉熸埛缂栧彿'
+comment on table TEST_LEAVE is '璇峰亣鐢宠琛�';
+comment on column TEST_LEAVE.ID is '涓婚敭';
+comment on column TEST_LEAVE.LEAVE_TYPE is '璇峰亣绫诲瀷';
+comment on column TEST_LEAVE.START_DATE is '寮�濮嬫椂闂�';
+comment on column TEST_LEAVE.END_DATE is '缁撴潫鏃堕棿';
+comment on column TEST_LEAVE.LEAVE_DAYS is '璇峰亣澶╂暟';
+comment on column TEST_LEAVE.REMARK is '璇峰亣鍘熷洜';
+comment on column TEST_LEAVE.CREATE_DEPT is '鍒涘缓閮ㄩ棬';
+comment on column TEST_LEAVE.CREATE_BY is '鍒涘缓鑰�';
+comment on column TEST_LEAVE.CREATE_TIME is '鍒涘缓鏃堕棿';
+comment on column TEST_LEAVE.UPDATE_BY is '鏇存柊鑰�';
+comment on column TEST_LEAVE.UPDATE_TIME is '鏇存柊鏃堕棿';
+comment on column TEST_LEAVE.TENANT_ID is '绉熸埛缂栧彿';
-- 娴佺▼鍒嗙被淇℃伅琛�
create table WF_CATEGORY
@@ -64,7 +64,7 @@
unique,
PARENT_ID NUMBER(20),
SORT_NUM NUMBER(10),
- TENANT_ID NUMBER(20),
+ TENANT_ID VARCHAR2(20),
CREATE_DEPT NUMBER(20),
CREATE_BY NUMBER(20),
CREATE_TIME DATE,
@@ -72,18 +72,151 @@
UPDATE_TIME DATE
);
-comment on table WF_CATEGORY is '娴佺▼鍒嗙被'
-comment on column WF_CATEGORY.ID is '涓婚敭'
-comment on column WF_CATEGORY.CATEGORY_NAME is '鍒嗙被鍚嶇О'
-comment on column WF_CATEGORY.CATEGORY_CODE is '鍒嗙被缂栫爜'
-comment on column WF_CATEGORY.PARENT_ID is '鐖剁骇id'
-comment on column WF_CATEGORY.SORT_NUM is '鎺掑簭'
-comment on column WF_CATEGORY.TENANT_ID is '绉熸埛缂栧彿'
-comment on column WF_CATEGORY.CREATE_DEPT is '鍒涘缓閮ㄩ棬'
-comment on column WF_CATEGORY.CREATE_BY is '鍒涘缓鑰�'
-comment on column WF_CATEGORY.CREATE_TIME is '鍒涘缓鏃堕棿'
-comment on column WF_CATEGORY.UPDATE_BY is '鏇存柊鑰�'
-comment on column WF_CATEGORY.UPDATE_TIME is '鏇存柊鏃堕棿'
+comment on table WF_CATEGORY is '娴佺▼鍒嗙被';
+comment on column WF_CATEGORY.ID is '涓婚敭';
+comment on column WF_CATEGORY.CATEGORY_NAME is '鍒嗙被鍚嶇О';
+comment on column WF_CATEGORY.CATEGORY_CODE is '鍒嗙被缂栫爜';
+comment on column WF_CATEGORY.PARENT_ID is '鐖剁骇id';
+comment on column WF_CATEGORY.SORT_NUM is '鎺掑簭';
+comment on column WF_CATEGORY.TENANT_ID is '绉熸埛缂栧彿';
+comment on column WF_CATEGORY.CREATE_DEPT is '鍒涘缓閮ㄩ棬';
+comment on column WF_CATEGORY.CREATE_BY is '鍒涘缓鑰�';
+comment on column WF_CATEGORY.CREATE_TIME is '鍒涘缓鏃堕棿';
+comment on column WF_CATEGORY.UPDATE_BY is '鏇存柊鑰�';
+comment on column WF_CATEGORY.UPDATE_TIME is '鏇存柊鏃堕棿';
+INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate, 1, sysdate);
+
+create table WF_TASK_BACK_NODE
+(
+ ID NUMBER(20) not null
+ constraint PK_WF_TASK_BACK_NODE
+ primary key,
+ NODE_ID VARCHAR2(255) not null,
+ NODE_NAME VARCHAR2(255) not null,
+ ORDER_NO NUMBER(20) not null,
+ INSTANCE_ID VARCHAR2(255) not null,
+ TASK_TYPE VARCHAR2(255) not null,
+ ASSIGNEE VARCHAR2(2000) not null,
+ TENANT_ID VARCHAR2(20),
+ CREATE_DEPT NUMBER(20),
+ CREATE_BY NUMBER(20),
+ CREATE_TIME DATE,
+ UPDATE_BY NUMBER(20),
+ UPDATE_TIME DATE
+);
+comment on table WF_TASK_BACK_NODE is '鑺傜偣瀹℃壒璁板綍';
+comment on column WF_TASK_BACK_NODE.ID is '涓婚敭';
+comment on column WF_TASK_BACK_NODE.NODE_ID is '鑺傜偣id';
+comment on column WF_TASK_BACK_NODE.NODE_NAME is '鑺傜偣鍚嶇О';
+comment on column WF_TASK_BACK_NODE.ORDER_NO is '鎺掑簭';
+comment on column WF_TASK_BACK_NODE.INSTANCE_ID is '娴佺▼瀹炰緥id';
+comment on column WF_TASK_BACK_NODE.TASK_TYPE is '鑺傜偣绫诲瀷';
+comment on column WF_TASK_BACK_NODE.ASSIGNEE is '瀹℃壒浜�';
+comment on column WF_TASK_BACK_NODE.TENANT_ID is '绉熸埛缂栧彿';
+comment on column WF_TASK_BACK_NODE.CREATE_DEPT is '鍒涘缓閮ㄩ棬';
+comment on column WF_TASK_BACK_NODE.CREATE_BY is '鍒涘缓鑰�';
+comment on column WF_TASK_BACK_NODE.CREATE_TIME is '鍒涘缓鏃堕棿';
+comment on column WF_TASK_BACK_NODE.UPDATE_BY is '鏇存柊鑰�';
+comment on column WF_TASK_BACK_NODE.UPDATE_TIME is '鏇存柊鏃堕棿';
+
+create table WF_DEFINITION_CONFIG
+(
+ ID NUMBER(20) NOT NULL
+ CONSTRAINT PK_WF_DEFINITION_CONFIG
+ PRIMARY KEY,
+ TABLE_NAME VARCHAR2(255) NOT NULL,
+ DEFINITION_ID VARCHAR2(255) NOT NULL,
+ PROCESS_KEY VARCHAR2(255) NOT NULL,
+ VERSION NUMBER(10) NOT NULL,
+ REMARK VARCHAR2(500),
+ TENANT_ID VARCHAR2(20),
+ CREATE_DEPT NUMBER(20),
+ CREATE_BY NUMBER(20),
+ CREATE_TIME DATE,
+ UPDATE_BY NUMBER(20),
+ UPDATE_TIME DATE,
+ constraint uni_definition_id
+ unique (definition_id)
+);
+comment on table WF_DEFINITION_CONFIG is '娴佺▼瀹氫箟閰嶇疆';
+comment on column WF_DEFINITION_CONFIG.ID is '涓婚敭';
+comment on column WF_DEFINITION_CONFIG.TABLE_NAME is '琛ㄥ悕';
+comment on column WF_DEFINITION_CONFIG.DEFINITION_ID is '娴佺▼瀹氫箟ID';
+comment on column WF_DEFINITION_CONFIG.PROCESS_KEY is '娴佺▼KEY';
+comment on column WF_DEFINITION_CONFIG.VERSION is '娴佺▼鐗堟湰';
+comment on column WF_DEFINITION_CONFIG.TENANT_ID is '绉熸埛缂栧彿';
+comment on column WF_DEFINITION_CONFIG.REMARK is '澶囨敞';
+comment on column WF_DEFINITION_CONFIG.CREATE_DEPT is '鍒涘缓閮ㄩ棬';
+comment on column WF_DEFINITION_CONFIG.CREATE_BY is '鍒涘缓鑰�';
+comment on column WF_DEFINITION_CONFIG.CREATE_TIME is '鍒涘缓鏃堕棿';
+comment on column WF_DEFINITION_CONFIG.UPDATE_BY is '鏇存柊鑰�';
+comment on column WF_DEFINITION_CONFIG.UPDATE_TIME is '鏇存柊鏃堕棿';
+
+create table WF_FORM_MANAGE
+(
+ ID NUMBER(20) NOT NULL
+ CONSTRAINT PK_WF_FORM_MANAGE
+ PRIMARY KEY,
+ FORM_NAME VARCHAR2(255) NOT NULL,
+ FORM_TYPE VARCHAR2(255) NOT NULL,
+ ROUTER VARCHAR2(255) NOT NULL,
+ REMARK VARCHAR2(500),
+ TENANT_ID VARCHAR2(20),
+ CREATE_DEPT NUMBER(20),
+ CREATE_BY NUMBER(20),
+ CREATE_TIME DATE,
+ UPDATE_BY NUMBER(20),
+ UPDATE_TIME DATE
+);
+
+comment on table WF_FORM_MANAGE is '琛ㄥ崟绠＄悊';
+comment on column WF_FORM_MANAGE.ID is '涓婚敭';
+comment on column WF_FORM_MANAGE.FORM_NAME is '琛ㄥ崟鍚嶇О';
+comment on column WF_FORM_MANAGE.FORM_TYPE is '琛ㄥ崟绫诲瀷';
+comment on column WF_FORM_MANAGE.ROUTER is '璺敱鍦板潃/琛ㄥ崟ID';
+comment on column WF_FORM_MANAGE.REMARK is '澶囨敞';
+comment on column WF_FORM_MANAGE.TENANT_ID is '绉熸埛缂栧彿';
+comment on column WF_FORM_MANAGE.CREATE_DEPT is '鍒涘缓閮ㄩ棬';
+comment on column WF_FORM_MANAGE.CREATE_BY is '鍒涘缓鑰�';
+comment on column WF_FORM_MANAGE.CREATE_TIME is '鍒涘缓鏃堕棿';
+comment on column WF_FORM_MANAGE.UPDATE_BY is '鏇存柊鑰�';
+comment on column WF_FORM_MANAGE.UPDATE_TIME is '鏇存柊鏃堕棿';
+
+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 NUMBER(20) NOT NULL
+ CONSTRAINT PK_WF_NODE_CONFIG
+ PRIMARY KEY,
+ FORM_ID NUMBER(20),
+ FORM_TYPE VARCHAR2(255),
+ NODE_NAME VARCHAR2(255) NOT NULL,
+ NODE_ID VARCHAR2(255) NOT NULL,
+ DEFINITION_ID VARCHAR2(255) NOT NULL,
+ APPLY_USER_TASK CHAR(1) DEFAULT '0',
+ TENANT_ID VARCHAR2(20),
+ CREATE_DEPT NUMBER(20),
+ CREATE_BY NUMBER(20),
+ CREATE_TIME DATE,
+ UPDATE_BY NUMBER(20),
+ UPDATE_TIME DATE
+);
+
+comment on table WF_NODE_CONFIG is '鑺傜偣閰嶇疆';
+comment on column WF_NODE_CONFIG.ID is '涓婚敭';
+comment on column WF_NODE_CONFIG.FORM_ID is '琛ㄥ崟id';
+comment on column WF_NODE_CONFIG.FORM_TYPE is '琛ㄥ崟绫诲瀷';
+comment on column WF_NODE_CONFIG.NODE_ID is '鑺傜偣id';
+comment on column WF_NODE_CONFIG.NODE_NAME is '鑺傜偣鍚嶇О';
+comment on column WF_NODE_CONFIG.DEFINITION_ID is '娴佺▼瀹氫箟id';
+comment on column WF_NODE_CONFIG.APPLY_USER_TASK is '鏄惁涓虹敵璇蜂汉鑺傜偣 锛�0鏄� 1鍚︼級';
+comment on column WF_NODE_CONFIG.TENANT_ID is '绉熸埛缂栧彿';
+comment on column WF_NODE_CONFIG.CREATE_DEPT is '鍒涘缓閮ㄩ棬';
+comment on column WF_NODE_CONFIG.CREATE_BY is '鍒涘缓鑰�';
+comment on column WF_NODE_CONFIG.CREATE_TIME is '鍒涘缓鏃堕棿';
+comment on column WF_NODE_CONFIG.UPDATE_BY is '鏇存柊鑰�';
+comment on column WF_NODE_CONFIG.UPDATE_TIME is '鏇存柊鏃堕棿';
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, '');
@@ -91,3 +224,36 @@
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 (11641, '璇峰亣鐢宠淇敼', 11638, 3, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:edit', '#', 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 (11642, '璇峰亣鐢宠鍒犻櫎', 11638, 4, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:remove', '#', 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 (11643, '璇峰亣鐢宠瀵煎嚭', 11638, 5, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:export', '#', 103, 1, sysdate, NULL, NULL, '');
+
+INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (13, '000000', '涓氬姟鐘舵��', 'wf_business_status', 103, 1, sysdate, NULL, NULL, '涓氬姟鐘舵�佸垪琛�');
+INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (14, '000000', '琛ㄥ崟绫诲瀷', 'wf_form_type', 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 (39, '000000', 1, '宸叉挙閿�', 'cancel', '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 (40, '000000', 2, '鑽夌', 'draft', 'wf_business_status', '', 'info', '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 (41, '000000', 3, '寰呭鏍�', 'waiting', 'wf_business_status', '', '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 (42, '000000', 4, '宸插畬鎴�', 'finish', 'wf_business_status', '', '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 (43, '000000', 5, '宸蹭綔搴�', 'invalid', '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 (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, '鍔ㄦ�佽〃鍗�');
+
+-- 琛ㄥ崟绠＄悊 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)
+values(11628, '琛ㄥ崟绠＄悊', '11616', '5', 'formManage', 'workflow/formManage/index', 1, 0, 'C', '0', '0', 'workflow:formManage:list', 'tree-table', 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)
+values(11644, '琛ㄥ崟绠＄悊鏌ヨ', 11628, '1', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:query', '', 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(11645, '琛ㄥ崟绠＄悊鏂板', 11628, '2', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:add', '', 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(11646, '琛ㄥ崟绠＄悊淇敼', 11628, '3', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:edit', '', 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(11647, '琛ㄥ崟绠＄悊鍒犻櫎', 11628, '4', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:remove', '', 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(11648, '琛ㄥ崟绠＄悊瀵煎嚭', 11628, '5', '#', '', 1, 0, 'F', '0', '0', 'workflow:formManage:export', 'tree-table', 103, 1, sysdate, null, null, '');
--
Gitblit v1.9.3