From 1e1616ceb0f4c7d11e043201ecbfc9d77092ae65 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期二, 21 十一月 2023 14:55:46 +0800 Subject: [PATCH] update 优化 TenantHelper 动态租户支持函数式方法 --- 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