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