From 8d0d85444aca73cc9a34cd69874346b70ff9202a Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期四, 20 四月 2023 13:00:53 +0800
Subject: [PATCH] update 优化 用户更改角色 踢掉角色相关所有在线用户
---
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