From 7c2c82fc0a0478adb4dc9606de8bcb872b20f0eb Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期五, 24 一月 2025 12:42:48 +0800
Subject: [PATCH] fix 修复 postgres sql缺少字段问题
---
script/sql/postgres/postgres_ry_workflow.sql | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/script/sql/postgres/postgres_ry_workflow.sql b/script/sql/postgres/postgres_ry_workflow.sql
index 9bcf2cf..80cd414 100644
--- a/script/sql/postgres/postgres_ry_workflow.sql
+++ b/script/sql/postgres/postgres_ry_workflow.sql
@@ -136,6 +136,7 @@
variable text NULL, -- 浠诲姟鍙橀噺
flow_status varchar(20) NOT NULL, -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
activity_status int2 NOT NULL DEFAULT 1, -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
+ def_json text NULL, -- 娴佺▼瀹氫箟json
create_by varchar(64) NULL DEFAULT '':: character varying, -- 鍒涘缓鑰�
create_time timestamp NULL, -- 鍒涘缓鏃堕棿
update_time timestamp NULL, -- 鏇存柊鏃堕棿
@@ -155,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 '鏇存柊鏃堕棿';
@@ -199,8 +201,8 @@
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_code varchar(200) NULL, -- 寮�濮嬭妭鐐圭紪鐮�
+ node_name varchar(200) NULL, -- 寮�濮嬭妭鐐瑰悕绉�
node_type int2 NULL, -- 寮�濮嬭妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
target_node_code varchar(200) NULL, -- 鐩爣鑺傜偣缂栫爜
target_node_name varchar(200) NULL, -- 缁撴潫鑺傜偣鍚嶇О
--
Gitblit v1.9.3