From 5b7c787b31e7119d09266819e12c7ad6a1eb7cf7 Mon Sep 17 00:00:00 2001
From: JackyTang <jackytang01@gmail.com>
Date: 星期四, 20 四月 2023 10:49:29 +0800
Subject: [PATCH] update 使用instanceof模式匹配, 减少二次转换
---
script/sql/oracle/oracle_test.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/script/sql/oracle/oracle_test.sql b/script/sql/oracle/oracle_test.sql
index 365568e..b4fc881 100644
--- a/script/sql/oracle/oracle_test.sql
+++ b/script/sql/oracle/oracle_test.sql
@@ -1,6 +1,6 @@
create table test_demo (
id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
dept_id number(20) default null,
user_id number(20) default null,
order_num number(10) default 0,
@@ -35,7 +35,7 @@
create table test_tree (
id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
parent_id number(20) default 0,
dept_id number(20) default null,
user_id number(20) default null,
--
Gitblit v1.9.3