From 3c8d864b5f68af5167199e0d5c9ff6c0c5852638 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期一, 20 一月 2025 11:35:45 +0800
Subject: [PATCH] !639 发布 5.3.0-BETA 公测版本 Merge pull request !639 from 疯狂的狮子Li/dev
---
script/sql/sqlserver/sqlserver_ry_vue_5.X.sql | 28 ++++++++++++++++------------
1 files changed, 16 insertions(+), 12 deletions(-)
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
index ad9a0b5..4607fb2 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
@@ -2,7 +2,7 @@
(
id bigint NOT NULL,
user_id bigint NOT NULL,
- tenant_id nvarchar(20) NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
auth_id nvarchar(255) NOT NULL,
source nvarchar(255) NOT NULL,
open_id nvarchar(255) NULL,
@@ -175,7 +175,7 @@
'COLUMN', N'oauth_token_secret'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_social',
'COLUMN', N'del_flag'
@@ -210,7 +210,11 @@
'TABLE', N'sys_social',
'COLUMN', N'update_time'
GO
-
+EXEC sp_addextendedproperty
+ 'MS_Description', N'绀句細鍖栧叧绯昏〃',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'sys_social'
+GO
CREATE TABLE sys_tenant
(
@@ -326,7 +330,7 @@
'COLUMN', N'status'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_tenant',
'COLUMN', N'del_flag'
@@ -423,7 +427,7 @@
'COLUMN', N'status'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_tenant_package',
'COLUMN', N'del_flag'
@@ -1013,7 +1017,7 @@
'COLUMN', N'status'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'del_flag'
@@ -2002,10 +2006,10 @@
oper_url nvarchar(255) DEFAULT '' NULL,
oper_ip nvarchar(128) DEFAULT '' NULL,
oper_location nvarchar(255) DEFAULT '' NULL,
- oper_param nvarchar(2000) DEFAULT '' NULL,
- json_result nvarchar(2000) DEFAULT '' NULL,
+ oper_param nvarchar(4000) DEFAULT '' NULL,
+ json_result nvarchar(4000) DEFAULT '' NULL,
status int DEFAULT ((0)) NULL,
- error_msg nvarchar(2000) DEFAULT '' NULL,
+ error_msg nvarchar(4000) DEFAULT '' NULL,
oper_time datetime2(7) NULL,
cost_time bigint DEFAULT ((0)) NULL,
CONSTRAINT PK__sys_oper__34723BF9BD954573 PRIMARY KEY CLUSTERED (oper_id)
@@ -2338,7 +2342,7 @@
'COLUMN', N'status'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'del_flag'
@@ -2723,7 +2727,7 @@
'COLUMN', N'status'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'del_flag'
@@ -3202,7 +3206,7 @@
'COLUMN', N'status'
GO
EXEC sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�',
'SCHEMA', N'dbo',
'TABLE', N'sys_client',
'COLUMN', N'del_flag'
--
Gitblit v1.9.3