From 6bc2d9d4a761191d149a9902c6ea6fafd7030c85 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期四, 16 一月 2025 10:23:55 +0800 Subject: [PATCH] update 优化 升级sqlserver warmflow sql脚本 --- script/sql/sqlserver/sqlserver_ry_workflow.sql | 20 ++++++++++++++++++-- 1 files changed, 18 insertions(+), 2 deletions(-) diff --git a/script/sql/sqlserver/sqlserver_ry_workflow.sql b/script/sql/sqlserver/sqlserver_ry_workflow.sql index 478dc86..ea4b720 100644 --- a/script/sql/sqlserver/sqlserver_ry_workflow.sql +++ b/script/sql/sqlserver/sqlserver_ry_workflow.sql @@ -458,6 +458,7 @@ variable nvarchar(max) NULL, flow_status nvarchar(20) NOT NULL, activity_status tinyint DEFAULT('1') NULL, + def_json nvarchar(max) NULL, create_by nvarchar(64) NULL, create_time datetime2(7) NULL, update_time datetime2(7) NULL, @@ -533,6 +534,13 @@ 'SCHEMA', N'dbo', 'TABLE', N'flow_instance', 'COLUMN', N'activity_status' +GO + +EXEC sp_addextendedproperty +'MS_Description', N'娴佺▼瀹氫箟json', +'SCHEMA', N'dbo', +'TABLE', N'flow_instance', +'COLUMN', N'def_json' GO EXEC sp_addextendedproperty @@ -698,8 +706,8 @@ definition_id bigint NOT NULL, instance_id bigint NOT NULL, task_id bigint NOT NULL, - node_code nvarchar(100) NULL, - node_name nvarchar(100) NULL, + node_code nvarchar(200) NULL, + node_name nvarchar(200) NULL, node_type tinyint NULL, target_node_code nvarchar(100) NULL, target_node_name nvarchar(100) NULL, @@ -711,6 +719,7 @@ form_custom nchar(1) DEFAULT('N') NULL, form_path nvarchar(100) NULL, message nvarchar(500) NULL, + variable nvarchar(max) NULL, ext nvarchar(500) NULL, create_time datetime2(7) NULL, update_time datetime2(7) NULL, @@ -843,6 +852,13 @@ GO EXEC sp_addextendedproperty +'MS_Description', N'浠诲姟鍙橀噺', +'SCHEMA', N'dbo', +'TABLE', N'flow_his_task', +'COLUMN', N'variable' +GO + +EXEC sp_addextendedproperty 'MS_Description', N'涓氬姟璇︽儏 瀛樹笟鍔¤〃瀵硅薄json瀛楃涓�', 'SCHEMA', N'dbo', 'TABLE', N'flow_his_task', -- Gitblit v1.9.3