From eafecc3ac0227960f2b8fa377be27f066e10e50f Mon Sep 17 00:00:00 2001
From: baoshiwei <baoshiwei@shlanbao.cn>
Date: 星期二, 20 五月 2025 10:47:58 +0800
Subject: [PATCH] perf(lb-qms): 优化查询功能和时间范围筛选
---
script/sql/sqlserver/sqlserver_ry_workflow.sql | 24 ++++++++++++++++++++----
1 files changed, 20 insertions(+), 4 deletions(-)
diff --git a/script/sql/sqlserver/sqlserver_ry_workflow.sql b/script/sql/sqlserver/sqlserver_ry_workflow.sql
index dc5c6b2..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,
@@ -840,6 +849,13 @@
'SCHEMA', N'dbo',
'TABLE', N'flow_his_task',
'COLUMN', N'message'
+GO
+
+EXEC sp_addextendedproperty
+'MS_Description', N'浠诲姟鍙橀噺',
+'SCHEMA', N'dbo',
+'TABLE', N'flow_his_task',
+'COLUMN', N'variable'
GO
EXEC sp_addextendedproperty
@@ -1035,7 +1051,7 @@
GO
EXEC sp_addextendedproperty
-'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�',
'SCHEMA', N'dbo',
'TABLE', N'flow_category',
'COLUMN', N'del_flag'
@@ -1086,7 +1102,7 @@
GO
INSERT flow_category VALUES (101, N'000000', 100, N'0,100', N'鍋囧嫟绠＄悊', 0, N'0', 103, 1, getdate(), NULL, NULL);
GO
-INSERT flow_category VALUES (102, N'000000', 100, N'0,100', N'浜轰簨绠＄悊', 0, N'0', 103, 1, getdate(), NULL, NULL);
+INSERT flow_category VALUES (102, N'000000', 100, N'0,100', N'浜轰簨绠＄悊', 1, N'0', 103, 1, getdate(), NULL, NULL);
GO
INSERT flow_category VALUES (103, N'000000', 101, N'0,100,101', N'璇峰亣', 0, N'0', 103, 1, getdate(), NULL, NULL);
GO
--
Gitblit v1.9.3