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