From affbce1957c1bcce089d1d1e535d9ad0ad6d880b Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期二, 05 十二月 2023 22:46:59 +0800 Subject: [PATCH] update 优化 开启 redisson 脚本缓存 减少网络传输 --- 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