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/sqlserver/sqlserver_ry_workflow.sql | 2
script/sql/oracle/oracle_ry_workflow.sql | 226 +++++++++++-----------
script/sql/postgres/postgres_ry_workflow.sql | 184 +++++++++---------
script/sql/ry_workflow.sql | 186 +++++++++---------
4 files changed, 303 insertions(+), 295 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);
diff --git a/script/sql/postgres/postgres_ry_workflow.sql b/script/sql/postgres/postgres_ry_workflow.sql
index aacd145..337b066 100644
--- a/script/sql/postgres/postgres_ry_workflow.sql
+++ b/script/sql/postgres/postgres_ry_workflow.sql
@@ -3,22 +3,22 @@
-- ----------------------------
CREATE TABLE flow_definition
(
- id int8 NOT NULL, -- 涓婚敭id
- flow_code varchar(40) NOT NULL, -- 娴佺▼缂栫爜
- flow_name varchar(100) NOT NULL, -- 娴佺▼鍚嶇О
- category varchar(100) NULL, -- 娴佺▼绫诲埆
- "version" varchar(20) NOT NULL, -- 娴佺▼鐗堟湰
- is_publish int2 NOT NULL DEFAULT 0, -- 鏄惁鍙戝竷锛�0鏈彂甯� 1宸插彂甯� 9澶辨晥锛�
- form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
- form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
- activity_status int2 NOT NULL DEFAULT 1, -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
- listener_type varchar(100) NULL, -- 鐩戝惉鍣ㄧ被鍨�
- listener_path varchar(400) NULL, -- 鐩戝惉鍣ㄨ矾寰�
- ext varchar(500) NULL, -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
- create_time timestamp NULL, -- 鍒涘缓鏃堕棿
- update_time timestamp NULL, -- 鏇存柊鏃堕棿
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
- tenant_id varchar(40) NULL, -- 绉熸埛id
+ id int8 NOT NULL, -- 涓婚敭id
+ flow_code varchar(40) NOT NULL, -- 娴佺▼缂栫爜
+ flow_name varchar(100) NOT NULL, -- 娴佺▼鍚嶇О
+ category varchar(100) NULL, -- 娴佺▼绫诲埆
+ "version" varchar(20) NOT NULL, -- 娴佺▼鐗堟湰
+ is_publish int2 NOT NULL DEFAULT 0, -- 鏄惁鍙戝竷锛�0鏈彂甯� 1宸插彂甯� 9澶辨晥锛�
+ form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+ form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
+ activity_status int2 NOT NULL DEFAULT 1, -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
+ listener_type varchar(100) NULL, -- 鐩戝惉鍣ㄧ被鍨�
+ listener_path varchar(400) NULL, -- 鐩戝惉鍣ㄨ矾寰�
+ ext varchar(500) NULL, -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
+ create_time timestamp NULL, -- 鍒涘缓鏃堕棿
+ update_time timestamp NULL, -- 鏇存柊鏃堕棿
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_definition_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE flow_definition IS '娴佺▼瀹氫箟琛�';
@@ -56,12 +56,12 @@
listener_path varchar(400) NULL, -- 鐩戝惉鍣ㄨ矾寰�
handler_type varchar(100) NULL, -- 澶勭悊鍣ㄧ被鍨�
handler_path varchar(400) NULL, -- 澶勭悊鍣ㄨ矾寰�
- form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+ form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
"version" varchar(20) NOT NULL, -- 鐗堟湰
create_time timestamp NULL, -- 鍒涘缓鏃堕棿
update_time timestamp NULL, -- 鏇存柊鏃堕棿
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_node_pkey PRIMARY KEY (id)
);
@@ -92,20 +92,20 @@
CREATE TABLE flow_skip
(
- id int8 NOT NULL, -- 涓婚敭id
- definition_id int8 NOT NULL, -- 娴佺▼瀹氫箟id
- now_node_code varchar(100) NOT NULL, -- 褰撳墠娴佺▼鑺傜偣鐨勭紪鐮�
- now_node_type int2 NULL, -- 褰撳墠鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
- next_node_code varchar(100) NOT NULL, -- 涓嬩竴涓祦绋嬭妭鐐圭殑缂栫爜
- next_node_type int2 NULL, -- 涓嬩竴涓妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
- skip_name varchar(100) NULL, -- 璺宠浆鍚嶇О
- skip_type varchar(40) NULL, -- 璺宠浆绫诲瀷锛圥ASS瀹℃壒閫氳繃 REJECT閫�鍥烇級
- skip_condition varchar(200) NULL, -- 璺宠浆鏉′欢
- coordinate varchar(100) NULL, -- 鍧愭爣
- create_time timestamp NULL, -- 鍒涘缓鏃堕棿
- update_time timestamp NULL, -- 鏇存柊鏃堕棿
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
- tenant_id varchar(40) NULL, -- 绉熸埛id
+ id int8 NOT NULL, -- 涓婚敭id
+ definition_id int8 NOT NULL, -- 娴佺▼瀹氫箟id
+ now_node_code varchar(100) NOT NULL, -- 褰撳墠娴佺▼鑺傜偣鐨勭紪鐮�
+ now_node_type int2 NULL, -- 褰撳墠鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+ next_node_code varchar(100) NOT NULL, -- 涓嬩竴涓祦绋嬭妭鐐圭殑缂栫爜
+ next_node_type int2 NULL, -- 涓嬩竴涓妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+ skip_name varchar(100) NULL, -- 璺宠浆鍚嶇О
+ skip_type varchar(40) NULL, -- 璺宠浆绫诲瀷锛圥ASS瀹℃壒閫氳繃 REJECT閫�鍥烇級
+ skip_condition varchar(200) NULL, -- 璺宠浆鏉′欢
+ coordinate varchar(100) NULL, -- 鍧愭爣
+ create_time timestamp NULL, -- 鍒涘缓鏃堕棿
+ update_time timestamp NULL, -- 鏇存柊鏃堕棿
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_skip_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE flow_skip IS '鑺傜偣璺宠浆鍏宠仈琛�';
@@ -127,21 +127,21 @@
CREATE TABLE flow_instance
(
- id int8 NOT NULL, -- 涓婚敭id
- definition_id int8 NOT NULL, -- 瀵瑰簲flow_definition琛ㄧ殑id
- business_id varchar(40) NOT NULL, -- 涓氬姟id
- node_type int2 NOT NULL, -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
- node_code varchar(40) NOT NULL, -- 娴佺▼鑺傜偣缂栫爜
- node_name varchar(100) NULL, -- 娴佺▼鑺傜偣鍚嶇О
- variable text NULL, -- 浠诲姟鍙橀噺
- flow_status varchar(20) NOT NULL, -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
- activity_status int2 NOT NULL DEFAULT 1, -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
- create_by varchar(64) NULL DEFAULT '':: character varying, -- 鍒涘缓鑰�
- create_time timestamp NULL, -- 鍒涘缓鏃堕棿
- update_time timestamp NULL, -- 鏇存柊鏃堕棿
- ext varchar(500) NULL, -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
- tenant_id varchar(40) NULL, -- 绉熸埛id
+ id int8 NOT NULL, -- 涓婚敭id
+ definition_id int8 NOT NULL, -- 瀵瑰簲flow_definition琛ㄧ殑id
+ business_id varchar(40) NOT NULL, -- 涓氬姟id
+ node_type int2 NOT NULL, -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+ node_code varchar(40) NOT NULL, -- 娴佺▼鑺傜偣缂栫爜
+ node_name varchar(100) NULL, -- 娴佺▼鑺傜偣鍚嶇О
+ variable text NULL, -- 浠诲姟鍙橀噺
+ flow_status varchar(20) NOT NULL, -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
+ activity_status int2 NOT NULL DEFAULT 1, -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
+ create_by varchar(64) NULL DEFAULT '':: character varying, -- 鍒涘缓鑰�
+ create_time timestamp NULL, -- 鍒涘缓鏃堕棿
+ update_time timestamp NULL, -- 鏇存柊鏃堕棿
+ ext varchar(500) NULL, -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_instance_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE flow_instance IS '娴佺▼瀹炰緥琛�';
@@ -164,18 +164,18 @@
CREATE TABLE flow_task
(
- id int8 NOT NULL, -- 涓婚敭id
- definition_id int8 NOT NULL, -- 瀵瑰簲flow_definition琛ㄧ殑id
- instance_id int8 NOT NULL, -- 瀵瑰簲flow_instance琛ㄧ殑id
- node_code varchar(100) NOT NULL, -- 鑺傜偣缂栫爜
- node_name varchar(100) NULL, -- 鑺傜偣鍚嶇О
- node_type int2 NOT NULL, -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
- form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
- form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
- create_time timestamp NULL, -- 鍒涘缓鏃堕棿
- update_time timestamp NULL, -- 鏇存柊鏃堕棿
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
- tenant_id varchar(40) NULL, -- 绉熸埛id
+ id int8 NOT NULL, -- 涓婚敭id
+ definition_id int8 NOT NULL, -- 瀵瑰簲flow_definition琛ㄧ殑id
+ instance_id int8 NOT NULL, -- 瀵瑰簲flow_instance琛ㄧ殑id
+ node_code varchar(100) NOT NULL, -- 鑺傜偣缂栫爜
+ node_name varchar(100) NULL, -- 鑺傜偣鍚嶇О
+ node_type int2 NOT NULL, -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+ form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+ form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
+ create_time timestamp NULL, -- 鍒涘缓鏃堕棿
+ update_time timestamp NULL, -- 鏇存柊鏃堕棿
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_task_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE flow_task IS '寰呭姙浠诲姟琛�';
@@ -195,28 +195,29 @@
CREATE TABLE flow_his_task
(
- id int8 NOT NULL, -- 涓婚敭id
- definition_id int8 NOT NULL, -- 瀵瑰簲flow_definition琛ㄧ殑id
- instance_id int8 NOT NULL, -- 瀵瑰簲flow_instance琛ㄧ殑id
- task_id int8 NOT NULL, -- 瀵瑰簲flow_task琛ㄧ殑id
- node_code varchar(100) NULL, -- 寮�濮嬭妭鐐圭紪鐮�
- node_name varchar(100) NULL, -- 寮�濮嬭妭鐐瑰悕绉�
- node_type int2 NULL, -- 寮�濮嬭妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
- target_node_code varchar(100) NULL, -- 鐩爣鑺傜偣缂栫爜
- target_node_name varchar(100) NULL, -- 缁撴潫鑺傜偣鍚嶇О
- approver varchar(40) NULL, -- 瀹℃壒鑰�
- cooperate_type int2 NOT NULL DEFAULT 0, -- 鍗忎綔鏂瑰紡(1瀹℃壒 2杞姙 3濮旀淳 4浼氱 5绁ㄧ 6鍔犵 7鍑忕)
- collaborator varchar(40) NULL, -- 鍗忎綔浜�(鍙湁杞姙銆佷細绛俱�佺エ绛俱�佸娲�)
- skip_type varchar(10) NULL, -- 娴佽浆绫诲瀷锛圥ASS閫氳繃 REJECT閫�鍥� NONE鏃犲姩浣滐級
- flow_status varchar(20) NOT NULL, -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
- form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
- form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
- ext varchar(500) NULL, -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
- message varchar(500) NULL, -- 瀹℃壒鎰忚
- create_time timestamp NULL, -- 鍒涘缓鏃堕棿
- update_time timestamp NULL, -- 鏇存柊鏃堕棿
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
- tenant_id varchar(40) NULL, -- 绉熸埛id
+ id int8 NOT NULL, -- 涓婚敭id
+ definition_id int8 NOT NULL, -- 瀵瑰簲flow_definition琛ㄧ殑id
+ instance_id int8 NOT NULL, -- 瀵瑰簲flow_instance琛ㄧ殑id
+ task_id int8 NOT NULL, -- 瀵瑰簲flow_task琛ㄧ殑id
+ node_code varchar(100) NULL, -- 寮�濮嬭妭鐐圭紪鐮�
+ node_name varchar(100) NULL, -- 寮�濮嬭妭鐐瑰悕绉�
+ node_type int2 NULL, -- 寮�濮嬭妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+ target_node_code varchar(200) NULL, -- 鐩爣鑺傜偣缂栫爜
+ target_node_name varchar(200) NULL, -- 缁撴潫鑺傜偣鍚嶇О
+ approver varchar(40) NULL, -- 瀹℃壒鑰�
+ cooperate_type int2 NOT NULL DEFAULT 0, -- 鍗忎綔鏂瑰紡(1瀹℃壒 2杞姙 3濮旀淳 4浼氱 5绁ㄧ 6鍔犵 7鍑忕)
+ collaborator varchar(40) NULL, -- 鍗忎綔浜�(鍙湁杞姙銆佷細绛俱�佺エ绛俱�佸娲�)
+ skip_type varchar(10) NULL, -- 娴佽浆绫诲瀷锛圥ASS閫氳繃 REJECT閫�鍥� NONE鏃犲姩浣滐級
+ flow_status varchar(20) NOT NULL, -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
+ form_custom bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+ form_path varchar(100) NULL, -- 瀹℃壒琛ㄥ崟璺緞
+ ext varchar(500) NULL, -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
+ message varchar(500) NULL, -- 瀹℃壒鎰忚
+ variable text NULL, -- 浠诲姟鍙橀噺
+ create_time timestamp NULL, -- 鍒涘缓鏃堕棿
+ update_time timestamp NULL, -- 鏇存柊鏃堕棿
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_his_task_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE flow_his_task IS '鍘嗗彶浠诲姟璁板綍琛�';
@@ -238,6 +239,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 '瀹℃壒瀹屾垚鏃堕棿';
@@ -246,15 +248,15 @@
CREATE TABLE flow_user
(
- id int8 NOT NULL, -- 涓婚敭id
- "type" bpchar(1) NOT NULL, -- 浜哄憳绫诲瀷锛�1寰呭姙浠诲姟鐨勫鎵逛汉鏉冮檺 2寰呭姙浠诲姟鐨勮浆鍔炰汉鏉冮檺 3娴佺▼瀹炰緥鐨勬妱閫佷汉鏉冮檺 4寰呭姙浠诲姟鐨勫鎵樹汉鏉冮檺锛�
- processed_by varchar(80) NULL, -- 鏉冮檺浜�
- associated int8 NOT NULL, -- 浠诲姟琛╥d
- create_time timestamp NULL, -- 鍒涘缓鏃堕棿
- create_by varchar(80) NULL, -- 鍒涘缓浜�
- update_time timestamp NULL, -- 鏇存柊鏃堕棿
- del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
- tenant_id varchar(40) NULL, -- 绉熸埛id
+ id int8 NOT NULL, -- 涓婚敭id
+ "type" bpchar(1) NOT NULL, -- 浜哄憳绫诲瀷锛�1寰呭姙浠诲姟鐨勫鎵逛汉鏉冮檺 2寰呭姙浠诲姟鐨勮浆鍔炰汉鏉冮檺 3娴佺▼瀹炰緥鐨勬妱閫佷汉鏉冮檺 4寰呭姙浠诲姟鐨勫鎵樹汉鏉冮檺锛�
+ processed_by varchar(80) NULL, -- 鏉冮檺浜�
+ associated int8 NOT NULL, -- 浠诲姟琛╥d
+ create_time timestamp NULL, -- 鍒涘缓鏃堕棿
+ create_by varchar(80) NULL, -- 鍒涘缓浜�
+ update_time timestamp NULL, -- 鏇存柊鏃堕棿
+ del_flag bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+ tenant_id varchar(40) NULL, -- 绉熸埛id
CONSTRAINT flow_user_pk PRIMARY KEY (id)
);
CREATE INDEX user_processed_type ON flow_user USING btree (processed_by, type);
@@ -306,7 +308,7 @@
INSERT INTO flow_category VALUES (100, '000000', 0, '0', 'OA瀹℃壒', 0, '0', 103, 1, now(), NULL, NULL);
INSERT INTO flow_category VALUES (101, '000000', 100, '0,100', '鍋囧嫟绠＄悊', 0, '0', 103, 1, now(), NULL, NULL);
-INSERT INTO flow_category VALUES (102, '000000', 100, '0,100', '浜轰簨绠＄悊', 0, '0', 103, 1, now(), NULL, NULL);
+INSERT INTO flow_category VALUES (102, '000000', 100, '0,100', '浜轰簨绠＄悊', 1, '0', 103, 1, now(), NULL, NULL);
INSERT INTO flow_category VALUES (103, '000000', 101, '0,100,101', '璇峰亣', 0, '0', 103, 1, now(), NULL, NULL);
INSERT INTO flow_category VALUES (104, '000000', 101, '0,100,101', '鍑哄樊', 1, '0', 103, 1, now(), NULL, NULL);
INSERT INTO flow_category VALUES (105, '000000', 101, '0,100,101', '鍔犵彮', 2, '0', 103, 1, now(), NULL, NULL);
diff --git a/script/sql/ry_workflow.sql b/script/sql/ry_workflow.sql
index 7b82ef6..c5adb64 100644
--- a/script/sql/ry_workflow.sql
+++ b/script/sql/ry_workflow.sql
@@ -3,106 +3,107 @@
-- ----------------------------
CREATE TABLE `flow_definition`
(
- `id` bigint unsigned NOT NULL COMMENT '涓婚敭id',
- `flow_code` varchar(40) NOT NULL COMMENT '娴佺▼缂栫爜',
- `flow_name` varchar(100) NOT NULL COMMENT '娴佺▼鍚嶇О',
- `category` varchar(100) DEFAULT NULL COMMENT '娴佺▼绫诲埆',
- `version` varchar(20) NOT NULL COMMENT '娴佺▼鐗堟湰',
- `is_publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍙戝竷锛�0鏈彂甯� 1宸插彂甯� 9澶辨晥锛�',
- `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
- `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
- `activity_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級',
- `listener_type` varchar(100) DEFAULT NULL COMMENT '鐩戝惉鍣ㄧ被鍨�',
- `listener_path` varchar(400) DEFAULT NULL COMMENT '鐩戝惉鍣ㄨ矾寰�',
- `ext` varchar(500) DEFAULT NULL COMMENT '涓氬姟璇︽儏 瀛樹笟鍔¤〃瀵硅薄json瀛楃涓�',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
- `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
+ `id` bigint unsigned NOT NULL COMMENT '涓婚敭id',
+ `flow_code` varchar(40) NOT NULL COMMENT '娴佺▼缂栫爜',
+ `flow_name` varchar(100) NOT NULL COMMENT '娴佺▼鍚嶇О',
+ `category` varchar(100) DEFAULT NULL COMMENT '娴佺▼绫诲埆',
+ `version` varchar(20) NOT NULL COMMENT '娴佺▼鐗堟湰',
+ `is_publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鏄惁鍙戝竷锛�0鏈彂甯� 1宸插彂甯� 9澶辨晥锛�',
+ `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
+ `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
+ `activity_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級',
+ `listener_type` varchar(100) DEFAULT NULL COMMENT '鐩戝惉鍣ㄧ被鍨�',
+ `listener_path` varchar(400) DEFAULT NULL COMMENT '鐩戝惉鍣ㄨ矾寰�',
+ `ext` varchar(500) DEFAULT NULL COMMENT '涓氬姟璇︽儏 瀛樹笟鍔¤〃瀵硅薄json瀛楃涓�',
+ `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
+ `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB COMMENT='娴佺▼瀹氫箟琛�';
+) ENGINE = InnoDB COMMENT ='娴佺▼瀹氫箟琛�';
CREATE TABLE `flow_node`
(
`id` bigint unsigned NOT NULL COMMENT '涓婚敭id',
- `node_type` tinyint(1) NOT NULL COMMENT '鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
- `definition_id` bigint NOT NULL COMMENT '娴佺▼瀹氫箟id',
- `node_code` varchar(100) NOT NULL COMMENT '娴佺▼鑺傜偣缂栫爜',
- `node_name` varchar(100) DEFAULT NULL COMMENT '娴佺▼鑺傜偣鍚嶇О',
- `permission_flag` varchar(200) DEFAULT NULL COMMENT '鏉冮檺鏍囪瘑锛堟潈闄愮被鍨�:鏉冮檺鏍囪瘑锛屽彲浠ュ涓紝鐢ㄩ�楀彿闅斿紑)',
- `node_ratio` DECIMAL(6,3) DEFAULT NULL COMMENT '娴佺▼绛剧讲姣斾緥鍊�',
- `coordinate` varchar(100) DEFAULT NULL COMMENT '鍧愭爣',
- `skip_any_node` varchar(100) DEFAULT 'N' COMMENT '鏄惁鍙互閫�鍥炰换鎰忚妭鐐癸紙Y鏄� N鍚︼級鍗冲皢鍒犻櫎',
- `any_node_skip` varchar(100) DEFAULT NULL COMMENT '浠绘剰缁撶偣璺宠浆',
- `listener_type` varchar(100) DEFAULT NULL COMMENT '鐩戝惉鍣ㄧ被鍨�',
- `listener_path` varchar(400) DEFAULT NULL COMMENT '鐩戝惉鍣ㄨ矾寰�',
+ `node_type` tinyint(1) NOT NULL COMMENT '鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
+ `definition_id` bigint NOT NULL COMMENT '娴佺▼瀹氫箟id',
+ `node_code` varchar(100) NOT NULL COMMENT '娴佺▼鑺傜偣缂栫爜',
+ `node_name` varchar(100) DEFAULT NULL COMMENT '娴佺▼鑺傜偣鍚嶇О',
+ `permission_flag` varchar(200) DEFAULT NULL COMMENT '鏉冮檺鏍囪瘑锛堟潈闄愮被鍨�:鏉冮檺鏍囪瘑锛屽彲浠ュ涓紝鐢ㄩ�楀彿闅斿紑)',
+ `node_ratio` decimal(6, 3) DEFAULT NULL COMMENT '娴佺▼绛剧讲姣斾緥鍊�',
+ `coordinate` varchar(100) DEFAULT NULL COMMENT '鍧愭爣',
+ `skip_any_node` varchar(100) DEFAULT 'N' COMMENT '鏄惁鍙互閫�鍥炰换鎰忚妭鐐癸紙Y鏄� N鍚︼級鍗冲皢鍒犻櫎',
+ `any_node_skip` varchar(100) DEFAULT NULL COMMENT '浠绘剰缁撶偣璺宠浆',
+ `listener_type` varchar(100) DEFAULT NULL COMMENT '鐩戝惉鍣ㄧ被鍨�',
+ `listener_path` varchar(400) DEFAULT NULL COMMENT '鐩戝惉鍣ㄨ矾寰�',
`handler_type` varchar(100) DEFAULT NULL COMMENT '澶勭悊鍣ㄧ被鍨�',
`handler_path` varchar(400) DEFAULT NULL COMMENT '澶勭悊鍣ㄨ矾寰�',
- `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
- `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
- `version` varchar(20) NOT NULL COMMENT '鐗堟湰',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
- `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
+ `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
+ `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
+ `version` varchar(20) NOT NULL COMMENT '鐗堟湰',
+ `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
+ `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB COMMENT='娴佺▼鑺傜偣琛�';
+) ENGINE = InnoDB COMMENT ='娴佺▼鑺傜偣琛�';
CREATE TABLE `flow_skip`
(
`id` bigint unsigned NOT NULL COMMENT '涓婚敭id',
- `definition_id` bigint NOT NULL COMMENT '娴佺▼瀹氫箟id',
- `now_node_code` varchar(100) NOT NULL COMMENT '褰撳墠娴佺▼鑺傜偣鐨勭紪鐮�',
- `now_node_type` tinyint(1) DEFAULT NULL COMMENT '褰撳墠鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
- `next_node_code` varchar(100) NOT NULL COMMENT '涓嬩竴涓祦绋嬭妭鐐圭殑缂栫爜',
- `next_node_type` tinyint(1) DEFAULT NULL COMMENT '涓嬩竴涓妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
+ `definition_id` bigint NOT NULL COMMENT '娴佺▼瀹氫箟id',
+ `now_node_code` varchar(100) NOT NULL COMMENT '褰撳墠娴佺▼鑺傜偣鐨勭紪鐮�',
+ `now_node_type` tinyint(1) DEFAULT NULL COMMENT '褰撳墠鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
+ `next_node_code` varchar(100) NOT NULL COMMENT '涓嬩竴涓祦绋嬭妭鐐圭殑缂栫爜',
+ `next_node_type` tinyint(1) DEFAULT NULL COMMENT '涓嬩竴涓妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
`skip_name` varchar(100) DEFAULT NULL COMMENT '璺宠浆鍚嶇О',
`skip_type` varchar(40) DEFAULT NULL COMMENT '璺宠浆绫诲瀷锛圥ASS瀹℃壒閫氳繃 REJECT閫�鍥烇級',
`skip_condition` varchar(200) DEFAULT NULL COMMENT '璺宠浆鏉′欢',
`coordinate` varchar(100) DEFAULT NULL COMMENT '鍧愭爣',
`create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
`update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
- `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
+ `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
+ `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB COMMENT='鑺傜偣璺宠浆鍏宠仈琛�';
+) ENGINE = InnoDB COMMENT ='鑺傜偣璺宠浆鍏宠仈琛�';
CREATE TABLE `flow_instance`
(
- `id` bigint NOT NULL COMMENT '涓婚敭id',
- `definition_id` bigint NOT NULL COMMENT '瀵瑰簲flow_definition琛ㄧ殑id',
- `business_id` varchar(40) NOT NULL COMMENT '涓氬姟id',
- `node_type` tinyint(1) NOT NULL COMMENT '鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
- `node_code` varchar(40) NOT NULL COMMENT '娴佺▼鑺傜偣缂栫爜',
- `node_name` varchar(100) DEFAULT NULL COMMENT '娴佺▼鑺傜偣鍚嶇О',
- `variable` text COMMENT '浠诲姟鍙橀噺',
- `flow_status` varchar(20) NOT NULL COMMENT '娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 3鑷姩閫氳繃 4缁堟 5浣滃簾 6鎾ら攢 7鍙栧洖 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�',
- `activity_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級',
- `create_by` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `ext` varchar(500) DEFAULT NULL COMMENT '鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤',
- `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
- `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
+ `id` bigint NOT NULL COMMENT '涓婚敭id',
+ `definition_id` bigint NOT NULL COMMENT '瀵瑰簲flow_definition琛ㄧ殑id',
+ `business_id` varchar(40) NOT NULL COMMENT '涓氬姟id',
+ `node_type` tinyint(1) NOT NULL COMMENT '鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
+ `node_code` varchar(40) NOT NULL COMMENT '娴佺▼鑺傜偣缂栫爜',
+ `node_name` varchar(100) DEFAULT NULL COMMENT '娴佺▼鑺傜偣鍚嶇О',
+ `variable` text COMMENT '浠诲姟鍙橀噺',
+ `flow_status` varchar(20) NOT NULL COMMENT '娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 3鑷姩閫氳繃 4缁堟 5浣滃簾 6鎾ら攢 7鍙栧洖 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�',
+ `activity_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級',
+ `def_json` text COMMENT '娴佺▼瀹氫箟json',
+ `create_by` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `ext` varchar(500) DEFAULT NULL COMMENT '鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤',
+ `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
+ `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB COMMENT='娴佺▼瀹炰緥琛�';
+) ENGINE = InnoDB COMMENT ='娴佺▼瀹炰緥琛�';
CREATE TABLE `flow_task`
(
- `id` bigint NOT NULL COMMENT '涓婚敭id',
- `definition_id` bigint NOT NULL COMMENT '瀵瑰簲flow_definition琛ㄧ殑id',
- `instance_id` bigint NOT NULL COMMENT '瀵瑰簲flow_instance琛ㄧ殑id',
- `node_code` varchar(100) NOT NULL COMMENT '鑺傜偣缂栫爜',
- `node_name` varchar(100) DEFAULT NULL COMMENT '鑺傜偣鍚嶇О',
- `node_type` tinyint(1) NOT NULL COMMENT '鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
- `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
- `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
- `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
+ `id` bigint NOT NULL COMMENT '涓婚敭id',
+ `definition_id` bigint NOT NULL COMMENT '瀵瑰簲flow_definition琛ㄧ殑id',
+ `instance_id` bigint NOT NULL COMMENT '瀵瑰簲flow_instance琛ㄧ殑id',
+ `node_code` varchar(100) NOT NULL COMMENT '鑺傜偣缂栫爜',
+ `node_name` varchar(100) DEFAULT NULL COMMENT '鑺傜偣鍚嶇О',
+ `node_type` tinyint(1) NOT NULL COMMENT '鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
+ `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
+ `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
+ `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
+ `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB COMMENT='寰呭姙浠诲姟琛�';
+) ENGINE = InnoDB COMMENT ='寰呭姙浠诲姟琛�';
CREATE TABLE `flow_his_task`
(
@@ -113,39 +114,40 @@
`node_code` varchar(100) DEFAULT NULL COMMENT '寮�濮嬭妭鐐圭紪鐮�',
`node_name` varchar(100) DEFAULT NULL COMMENT '寮�濮嬭妭鐐瑰悕绉�',
`node_type` tinyint(1) DEFAULT NULL COMMENT '寮�濮嬭妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�',
- `target_node_code` varchar(100) DEFAULT NULL COMMENT '鐩爣鑺傜偣缂栫爜',
- `target_node_name` varchar(100) DEFAULT NULL COMMENT '缁撴潫鑺傜偣鍚嶇О',
+ `target_node_code` varchar(200) DEFAULT NULL COMMENT '鐩爣鑺傜偣缂栫爜',
+ `target_node_name` varchar(200) DEFAULT NULL COMMENT '缁撴潫鑺傜偣鍚嶇О',
`approver` varchar(40) DEFAULT NULL COMMENT '瀹℃壒鑰�',
`cooperate_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鍗忎綔鏂瑰紡(1瀹℃壒 2杞姙 3濮旀淳 4浼氱 5绁ㄧ 6鍔犵 7鍑忕)',
`collaborator` varchar(40) DEFAULT NULL COMMENT '鍗忎綔浜�',
- `skip_type` varchar(10) NOT NULL COMMENT '娴佽浆绫诲瀷锛圥ASS閫氳繃 REJECT閫�鍥� NONE鏃犲姩浣滐級',
- `flow_status` varchar(20) NOT NULL COMMENT '娴佺▼鐘舵�侊紙1瀹℃壒涓� 2 瀹℃壒閫氳繃 9宸查��鍥� 10澶辨晥锛�',
- `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
- `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
+ `skip_type` varchar(10) NOT NULL COMMENT '娴佽浆绫诲瀷锛圥ASS閫氳繃 REJECT閫�鍥� NONE鏃犲姩浣滐級',
+ `flow_status` varchar(20) NOT NULL COMMENT '娴佺▼鐘舵�侊紙1瀹℃壒涓� 2 瀹℃壒閫氳繃 9宸查��鍥� 10澶辨晥锛�',
+ `form_custom` char(1) DEFAULT 'N' COMMENT '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級',
+ `form_path` varchar(100) DEFAULT NULL COMMENT '瀹℃壒琛ㄥ崟璺緞',
`message` varchar(500) DEFAULT NULL COMMENT '瀹℃壒鎰忚',
+ `variable` TEXT DEFAULT NULL COMMENT '浠诲姟鍙橀噺',
`ext` varchar(500) DEFAULT NULL COMMENT '涓氬姟璇︽儏 瀛樹笟鍔¤〃瀵硅薄json瀛楃涓�',
`create_time` datetime DEFAULT NULL COMMENT '浠诲姟寮�濮嬫椂闂�',
`update_time` datetime DEFAULT NULL COMMENT '瀹℃壒瀹屾垚鏃堕棿',
`del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
`tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB COMMENT ='鍘嗗彶浠诲姟璁板綍琛�';
+) ENGINE = InnoDB COMMENT ='鍘嗗彶浠诲姟璁板綍琛�';
CREATE TABLE `flow_user`
(
- `id` bigint unsigned NOT NULL COMMENT '涓婚敭id',
- `type` char(1) NOT NULL COMMENT '浜哄憳绫诲瀷锛�1寰呭姙浠诲姟鐨勫鎵逛汉鏉冮檺 2寰呭姙浠诲姟鐨勮浆鍔炰汉鏉冮檺 3寰呭姙浠诲姟鐨勫鎵樹汉鏉冮檺锛�',
- `processed_by` varchar(80) DEFAULT NULL COMMENT '鏉冮檺浜�',
- `associated` bigint NOT NULL COMMENT '浠诲姟琛╥d',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `create_by` varchar(80) DEFAULT NULL COMMENT '鍒涘缓浜�',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
- `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
+ `id` bigint unsigned NOT NULL COMMENT '涓婚敭id',
+ `type` char(1) NOT NULL COMMENT '浜哄憳绫诲瀷锛�1寰呭姙浠诲姟鐨勫鎵逛汉鏉冮檺 2寰呭姙浠诲姟鐨勮浆鍔炰汉鏉冮檺 3寰呭姙浠诲姟鐨勫鎵樹汉鏉冮檺锛�',
+ `processed_by` varchar(80) DEFAULT NULL COMMENT '鏉冮檺浜�',
+ `associated` bigint NOT NULL COMMENT '浠诲姟琛╥d',
+ `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `create_by` varchar(80) DEFAULT NULL COMMENT '鍒涘缓浜�',
+ `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `del_flag` char(1) DEFAULT '0' COMMENT '鍒犻櫎鏍囧織',
+ `tenant_id` varchar(40) DEFAULT NULL COMMENT '绉熸埛id',
PRIMARY KEY (`id`) USING BTREE,
- KEY `user_processed_type` (`processed_by`,`type`)
-) ENGINE=InnoDB COMMENT='娴佺▼鐢ㄦ埛琛�';
+ KEY `user_processed_type` (`processed_by`, `type`)
+) ENGINE = InnoDB COMMENT ='娴佺▼鐢ㄦ埛琛�';
-- ----------------------------
-- 娴佺▼鍒嗙被琛�
@@ -169,7 +171,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);
diff --git a/script/sql/sqlserver/sqlserver_ry_workflow.sql b/script/sql/sqlserver/sqlserver_ry_workflow.sql
index dc5c6b2..2ccb6fa 100644
--- a/script/sql/sqlserver/sqlserver_ry_workflow.sql
+++ b/script/sql/sqlserver/sqlserver_ry_workflow.sql
@@ -1086,7 +1086,7 @@
GO
INSERT flow_category VALUES (101, N'000000', 100, N'0,100', N'鍋囧嫟绠＄悊', 0, N'0', 103, 1, getdate(), NULL, NULL);
GO
-INSERT flow_category VALUES (102, N'000000', 100, N'0,100', N'浜轰簨绠＄悊', 0, N'0', 103, 1, getdate(), NULL, NULL);
+INSERT flow_category VALUES (102, N'000000', 100, N'0,100', N'浜轰簨绠＄悊', 1, N'0', 103, 1, getdate(), NULL, NULL);
GO
INSERT flow_category VALUES (103, N'000000', 101, N'0,100,101', N'璇峰亣', 0, N'0', 103, 1, getdate(), NULL, NULL);
GO
--
Gitblit v1.9.3