From 1bfcbfa456264fc481dca749958ce535d59aa2a1 Mon Sep 17 00:00:00 2001
From: 一夏coco <627428179@qq.com>
Date: 星期五, 21 四月 2023 09:38:25 +0800
Subject: [PATCH] !341 优化忽略租户写法，在抛出异常时可以正确关闭忽略; 修复 oracle脚本字段缺失 * update 优化忽略租户写法，在抛出异常时可以正确关闭忽略 * fix 修复 oracle脚本字段缺失
---
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