From eb03afef41dc6c57b9c6e0c6e64c384556092d95 Mon Sep 17 00:00:00 2001
From: gssong <1742057357@qq.com>
Date: 星期六, 06 四月 2024 11:29:42 +0800
Subject: [PATCH] update 补充节点配置sql
---
script/sql/sqlserver/flowable.sql | 31 +++++++++++++++++--------------
1 files changed, 17 insertions(+), 14 deletions(-)
diff --git a/script/sql/sqlserver/flowable.sql b/script/sql/sqlserver/flowable.sql
index 1c0576b..b3651bb 100644
--- a/script/sql/sqlserver/flowable.sql
+++ b/script/sql/sqlserver/flowable.sql
@@ -19,7 +19,6 @@
insert into sys_menu values ('11626', '娴佺▼鍒嗙被鍒犻櫎', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, getdate(), null, null, '');
insert into sys_menu values ('11627', '娴佺▼鍒嗙被瀵煎嚭', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, getdate(), null, null, '');
-- 璇峰亣鍗曚俊鎭�
-DROP TABLE if EXISTS test_leave;
create table test_leave
(
id bigint not null
@@ -84,7 +83,6 @@
go
-- 娴佺▼鍒嗙被淇℃伅琛�
-DROP TABLE if EXISTS wf_category;
create table wf_category
(
id bigint not null
@@ -335,18 +333,19 @@
create table wf_node_config
(
- id bigint not null primary key,
- form_id bigint,
- form_type nvarchar(255) ,
- node_name nvarchar(255) not null,
- node_id nvarchar(255) not null,
- definition_id nvarchar(255) not null,
- tenant_id nvarchar(20),
- create_dept bigint,
- create_by bigint,
- create_time datetime2,
- update_by bigint,
- update_time datetime2
+ id bigint not null primary key,
+ form_id bigint,
+ form_type nvarchar(255) ,
+ node_name nvarchar(255) not null,
+ node_id nvarchar(255) not null,
+ definition_id nvarchar(255) not null,
+ apply_user_task nchar default ('0') null,
+ tenant_id nvarchar(20),
+ create_dept bigint,
+ create_by bigint,
+ create_time datetime2,
+ update_by bigint,
+ update_time datetime2
)
go
@@ -376,6 +375,10 @@
'definition_id'
go
+exec sp_addextendedproperty 'MS_Description', N'鏄惁涓虹敵璇蜂汉鑺傜偣 锛�0鏄� 1鍚︼級', 'SCHEMA', 'dbo', 'TABLE', 'wf_node_config', 'COLUMN',
+ 'apply_user_task'
+go
+
exec sp_addextendedproperty 'MS_Description', N'绉熸埛缂栧彿', 'SCHEMA', 'dbo', 'TABLE', 'wf_node_config', 'COLUMN',
'tenant_id'
go
--
Gitblit v1.9.3