From d868d6c8f188fef4a0b6b63a269efb67d5429081 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期三, 12 四月 2023 22:18:29 +0800
Subject: [PATCH] fix 修复 test 表租户id没有设置默认值问题
---
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