From 776b235cecdbc66e1c12ff1b8db64a6ea6e5ba5f Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期三, 02 八月 2023 14:56:52 +0800
Subject: [PATCH] !407 【轻量级 PR】优化第三方认证授权绑定 Merge pull request !407 from MichelleChung/5.X

---
 script/sql/sqlserver/sqlserver_test.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/script/sql/sqlserver/sqlserver_test.sql b/script/sql/sqlserver/sqlserver_test.sql
index e8e6dac..87628bd 100644
--- a/script/sql/sqlserver/sqlserver_test.sql
+++ b/script/sql/sqlserver/sqlserver_test.sql
@@ -1,7 +1,7 @@
 CREATE TABLE test_demo
 (
     id          bigint            NOT NULL,
-    tenant_id   nvarchar(20)      NOT NULL,
+    tenant_id   nvarchar(20)      DEFAULT ('000000') NULL,
     dept_id     bigint            NULL,
     user_id     bigint            NULL,
     order_num   int DEFAULT ((0)) NULL,
@@ -128,7 +128,7 @@
 CREATE TABLE test_tree
 (
     id          bigint               NOT NULL,
-    tenant_id   nvarchar(20)         NOT NULL,
+    tenant_id   nvarchar(20)         DEFAULT ('000000') NULL,
     parent_id   bigint DEFAULT ((0)) NULL,
     dept_id     bigint               NULL,
     user_id     bigint               NULL,

--
Gitblit v1.9.3