From 089a79002f697198e9f4cbeb0ca85711d329eb52 Mon Sep 17 00:00:00 2001 From: AprilWind <2100166581@qq.com> Date: 星期三, 15 一月 2025 19:06:42 +0800 Subject: [PATCH] update 升级warm-flow的sql语句 --- script/sql/oracle/oracle_ry_workflow.sql | 226 ++++++++++++++++++++++++++++--------------------------- 1 files changed, 115 insertions(+), 111 deletions(-) diff --git a/script/sql/oracle/oracle_ry_workflow.sql b/script/sql/oracle/oracle_ry_workflow.sql index 6a7c5c5..a0f71d0 100644 --- a/script/sql/oracle/oracle_ry_workflow.sql +++ b/script/sql/oracle/oracle_ry_workflow.sql @@ -1,22 +1,21 @@ - create table FLOW_DEFINITION ( - ID NUMBER (20) not null, - FLOW_CODE VARCHAR2 (40) not null, - FLOW_NAME VARCHAR2 (100) not null, - CATEGORY VARCHAR2 (100), - VERSION VARCHAR2 (20) not null, - IS_PUBLISH NUMBER (1) default 0 not null, - FORM_CUSTOM VARCHAR2 (1) default 'N', - FORM_PATH VARCHAR2 (100), - ACTIVITY_STATUS NUMBER (1) default 1, - LISTENER_TYPE VARCHAR2 (100), - LISTENER_PATH VARCHAR2 (500), - EXT VARCHAR2 (500), - CREATE_TIME DATE, - UPDATE_TIME DATE, - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40) + ID NUMBER(20) not null, + FLOW_CODE VARCHAR2(40) not null, + FLOW_NAME VARCHAR2(100) not null, + CATEGORY VARCHAR2(100), + VERSION VARCHAR2(20) not null, + IS_PUBLISH NUMBER(1) default 0 not null, + FORM_CUSTOM VARCHAR2(1) default 'N', + FORM_PATH VARCHAR2(100), + ACTIVITY_STATUS NUMBER(1) default 1, + LISTENER_TYPE VARCHAR2(100), + LISTENER_PATH VARCHAR2(500), + EXT VARCHAR2(500), + CREATE_TIME DATE, + UPDATE_TIME DATE, + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40) ); alter table FLOW_DEFINITION add constraint PK_FLOW_DEFINITION primary key (ID); @@ -41,27 +40,27 @@ create table FLOW_NODE ( - ID NUMBER (20) not null, - NODE_TYPE NUMBER (1) not null, - DEFINITION_ID NUMBER (20) not null, - NODE_CODE VARCHAR2 (100) not null, - NODE_NAME VARCHAR2 (100), - NODE_RATIO NUMBER (6,3), - COORDINATE VARCHAR2 (100), - SKIP_ANY_NODE VARCHAR2 (100) default 'N', - ANY_NODE_SKIP VARCHAR2 (100), - LISTENER_TYPE VARCHAR2 (100), - LISTENER_PATH VARCHAR2 (500), - HANDLER_TYPE VARCHAR2 (100), - HANDLER_PATH VARCHAR2 (400), - FORM_CUSTOM VARCHAR2 (1) default 'N', - FORM_PATH VARCHAR2 (100), - VERSION VARCHAR2 (20), - CREATE_TIME DATE, - UPDATE_TIME DATE, - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40), - PERMISSION_FLAG VARCHAR2 (200) + ID NUMBER(20) not null, + NODE_TYPE NUMBER(1) not null, + DEFINITION_ID NUMBER(20) not null, + NODE_CODE VARCHAR2(100) not null, + NODE_NAME VARCHAR2(100), + NODE_RATIO NUMBER(6, 3), + COORDINATE VARCHAR2(100), + SKIP_ANY_NODE VARCHAR2(100) default 'N', + ANY_NODE_SKIP VARCHAR2(100), + LISTENER_TYPE VARCHAR2(100), + LISTENER_PATH VARCHAR2(500), + HANDLER_TYPE VARCHAR2(100), + HANDLER_PATH VARCHAR2(400), + FORM_CUSTOM VARCHAR2(1) default 'N', + FORM_PATH VARCHAR2(100), + VERSION VARCHAR2(20), + CREATE_TIME DATE, + UPDATE_TIME DATE, + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40), + PERMISSION_FLAG VARCHAR2(200) ); alter table FLOW_NODE add constraint PK_FLOW_NODE primary key (ID); @@ -91,20 +90,20 @@ create table FLOW_SKIP ( - ID NUMBER (20) not null, - DEFINITION_ID NUMBER (20) not null, - NOW_NODE_CODE VARCHAR2 (100) not null, - NOW_NODE_TYPE NUMBER (1), - NEXT_NODE_CODE VARCHAR2 (100) not null, - NEXT_NODE_TYPE NUMBER (1), - SKIP_NAME VARCHAR2 (100), - SKIP_TYPE VARCHAR2 (40), - SKIP_CONDITION VARCHAR2 (200), - COORDINATE VARCHAR2 (100), - CREATE_TIME DATE, - UPDATE_TIME DATE, - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40) + ID NUMBER(20) not null, + DEFINITION_ID NUMBER(20) not null, + NOW_NODE_CODE VARCHAR2(100) not null, + NOW_NODE_TYPE NUMBER(1), + NEXT_NODE_CODE VARCHAR2(100) not null, + NEXT_NODE_TYPE NUMBER(1), + SKIP_NAME VARCHAR2(100), + SKIP_TYPE VARCHAR2(40), + SKIP_CONDITION VARCHAR2(200), + COORDINATE VARCHAR2(100), + CREATE_TIME DATE, + UPDATE_TIME DATE, + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40) ); alter table FLOW_SKIP add constraint PK_FLOW_SKIP primary key (ID); @@ -127,21 +126,22 @@ create table FLOW_INSTANCE ( - ID NUMBER not null, - DEFINITION_ID NUMBER not null, - BUSINESS_ID VARCHAR2 (40) not null, - NODE_TYPE NUMBER (1), - NODE_CODE VARCHAR2 (100), - NODE_NAME VARCHAR2 (100), - VARIABLE CLOB, - FLOW_STATUS VARCHAR2 (20), - ACTIVITY_STATUS NUMBER (1) default 1, - CREATE_BY VARCHAR2 (64) default '', - CREATE_TIME DATE, - UPDATE_TIME DATE, - EXT VARCHAR2 (500), - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40) + ID NUMBER not null, + DEFINITION_ID NUMBER not null, + BUSINESS_ID VARCHAR2(40) not null, + NODE_TYPE NUMBER(1), + NODE_CODE VARCHAR2(100), + NODE_NAME VARCHAR2(100), + VARIABLE CLOB, + FLOW_STATUS VARCHAR2(20), + ACTIVITY_STATUS NUMBER(1) default 1, + DEF_JSON CLOB, + CREATE_BY VARCHAR2(64) default '', + CREATE_TIME DATE, + UPDATE_TIME DATE, + EXT VARCHAR2(500), + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40) ); alter table FLOW_INSTANCE add constraint PK_FLOW_INSTANCE primary key (ID); @@ -156,6 +156,7 @@ comment on column FLOW_INSTANCE.VARIABLE is '浠诲姟鍙橀噺'; comment on column FLOW_INSTANCE.FLOW_STATUS is '娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 3鑷姩閫氳繃 4缁堟 5浣滃簾 6鎾ら攢 7鍙栧洖 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�'; comment on column FLOW_INSTANCE.ACTIVITY_STATUS is '娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級'; +comment on column FLOW_INSTANCE.DEF_JSON is '娴佺▼瀹氫箟json'; comment on column FLOW_INSTANCE.CREATE_BY is '鍒涘缓鑰�'; comment on column FLOW_INSTANCE.CREATE_TIME is '鍒涘缓鏃堕棿'; comment on column FLOW_INSTANCE.UPDATE_TIME is '鏇存柊鏃堕棿'; @@ -165,18 +166,18 @@ create table FLOW_TASK ( - ID NUMBER (20) not null, - DEFINITION_ID NUMBER (20) not null, - INSTANCE_ID NUMBER (20) not null, - NODE_CODE VARCHAR2 (100), - NODE_NAME VARCHAR2 (100), - NODE_TYPE NUMBER (1), - FORM_CUSTOM VARCHAR2 (1) default 'N', - FORM_PATH VARCHAR2 (100), - CREATE_TIME DATE, - UPDATE_TIME DATE, - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40) + ID NUMBER(20) not null, + DEFINITION_ID NUMBER(20) not null, + INSTANCE_ID NUMBER(20) not null, + NODE_CODE VARCHAR2(100), + NODE_NAME VARCHAR2(100), + NODE_TYPE NUMBER(1), + FORM_CUSTOM VARCHAR2(1) default 'N', + FORM_PATH VARCHAR2(100), + CREATE_TIME DATE, + UPDATE_TIME DATE, + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40) ); alter table FLOW_TASK add constraint PK_FLOW_TASK primary key (ID); @@ -197,28 +198,30 @@ create table FLOW_HIS_TASK ( - ID NUMBER (20) not null, - DEFINITION_ID NUMBER (20) not null, - INSTANCE_ID NUMBER (20) not null, - TASK_ID NUMBER (20) not null, - NODE_CODE VARCHAR2 (100), - NODE_NAME VARCHAR2 (100), - NODE_TYPE NUMBER (1), - TARGET_NODE_CODE VARCHAR2 (100), - TARGET_NODE_NAME VARCHAR2 (100), - APPROVER VARCHAR2 (40), - COOPERATE_TYPE NUMBER (1) default 0, - COLLABORATOR VARCHAR2 (40), - SKIP_TYPE VARCHAR2 (10), - FLOW_STATUS VARCHAR2 (20), - FORM_CUSTOM VARCHAR2 (1) default 'N', - FORM_PATH VARCHAR2 (100), - MESSAGE VARCHAR2 (500), - EXT VARCHAR2 (500), - CREATE_TIME DATE, - UPDATE_TIME DATE, - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40) + ID NUMBER(20) not null, + DEFINITION_ID NUMBER(20) not null, + INSTANCE_ID NUMBER(20) not null, + TASK_ID NUMBER(20) not null, + NODE_CODE VARCHAR2(100), + NODE_NAME VARCHAR2(100), + NODE_TYPE NUMBER(1), + TARGET_NODE_CODE VARCHAR2(200), + TARGET_NODE_NAME VARCHAR2(200), + APPROVER VARCHAR2(40), + COOPERATE_TYPE NUMBER(1) default 0, + COLLABORATOR VARCHAR2(40), + SKIP_TYPE VARCHAR2(10), + FLOW_STATUS VARCHAR2(20), + FORM_CUSTOM VARCHAR2(1) default 'N', + FORM_PATH VARCHAR2(100), + MESSAGE VARCHAR2(500), + VARIABLE CLOB, + EXT VARCHAR2(500), + CREATE_TIME DATE, + UPDATE_TIME DATE, + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40) + ); alter table FLOW_HIS_TASK add constraint PK_FLOW_HIS_TASK primary key (ID); @@ -238,6 +241,7 @@ comment on column FLOW_HIS_TASK.FORM_CUSTOM is '瀹℃壒琛ㄥ崟鏄惁鑷畾涔� (Y鏄� N鍚�)'; comment on column FLOW_HIS_TASK.FORM_PATH is '瀹℃壒琛ㄥ崟璺緞'; comment on column FLOW_HIS_TASK.MESSAGE is '瀹℃壒鎰忚'; +comment on column FLOW_HIS_TASK.VARIABLE is '浠诲姟鍙橀噺'; comment on column FLOW_HIS_TASK.EXT is '鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤'; comment on column FLOW_HIS_TASK.CREATE_TIME is '浠诲姟寮�濮嬫椂闂�'; comment on column FLOW_HIS_TASK.UPDATE_TIME is '瀹℃壒瀹屾垚鏃堕棿'; @@ -249,15 +253,15 @@ create table FLOW_USER ( - ID NUMBER (20) not null, - TYPE VARCHAR2 (1) not null, - PROCESSED_BY VARCHAR2 (80), - ASSOCIATED NUMBER (20) not null, - CREATE_TIME DATE, - CREATE_BY VARCHAR2 (80), - UPDATE_TIME DATE, - DEL_FLAG VARCHAR2 (1) default '0', - TENANT_ID VARCHAR2 (40) + ID NUMBER(20) not null, + TYPE VARCHAR2(1) not null, + PROCESSED_BY VARCHAR2(80), + ASSOCIATED NUMBER(20) not null, + CREATE_TIME DATE, + CREATE_BY VARCHAR2(80), + UPDATE_TIME DATE, + DEL_FLAG VARCHAR2(1) default '0', + TENANT_ID VARCHAR2(40) ); alter table FLOW_USER add constraint PK_FLOW_USER primary key (ID); @@ -312,7 +316,7 @@ INSERT INTO flow_category VALUES (100, '000000', 0, '0', 'OA瀹℃壒', 0, '0', 103, 1, SYSDATE, NULL, NULL); INSERT INTO flow_category VALUES (101, '000000', 100, '0,100', '鍋囧嫟绠＄悊', 0, '0', 103, 1, SYSDATE, NULL, NULL); -INSERT INTO flow_category VALUES (102, '000000', 100, '0,100', '浜轰簨绠＄悊', 0, '0', 103, 1, SYSDATE, NULL, NULL); +INSERT INTO flow_category VALUES (102, '000000', 100, '0,100', '浜轰簨绠＄悊', 1, '0', 103, 1, SYSDATE, NULL, NULL); INSERT INTO flow_category VALUES (103, '000000', 101, '0,100,101', '璇峰亣', 0, '0', 103, 1, SYSDATE, NULL, NULL); INSERT INTO flow_category VALUES (104, '000000', 101, '0,100,101', '鍑哄樊', 1, '0', 103, 1, SYSDATE, NULL, NULL); INSERT INTO flow_category VALUES (105, '000000', 101, '0,100,101', '鍔犵彮', 2, '0', 103, 1, SYSDATE, NULL, NULL); -- Gitblit v1.9.3