From 296466fa134e689368c5e34265a2030a1deb37b1 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期五, 24 一月 2025 13:08:28 +0800
Subject: [PATCH] !640 发布 5.3.0 新春版 祝大家新年快乐 Merge pull request !640 from 疯狂的狮子Li/dev

---
 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