From 154ee06d70618f1bb0cfc745f71299eb11dad31a Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 07 三月 2024 15:08:56 +0800
Subject: [PATCH] fix 修复 oracle与postgres sql脚本租户id设置错误问题
---
script/sql/oracle/flowable.sql | 4 ++--
script/sql/postgres/flowable.sql | 4 ++--
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/script/sql/oracle/flowable.sql b/script/sql/oracle/flowable.sql
index 308c7c4..3627f82 100644
--- a/script/sql/oracle/flowable.sql
+++ b/script/sql/oracle/flowable.sql
@@ -35,7 +35,7 @@
CREATE_TIME DATE,
UPDATE_BY NUMBER(20),
UPDATE_TIME DATE,
- TENANT_ID VARCHAR2(255) default '000000'
+ TENANT_ID VARCHAR2(20) default '000000'
);
comment on table TEST_LEAVE is '璇峰亣鐢宠琛�'
@@ -64,7 +64,7 @@
unique,
PARENT_ID NUMBER(20),
SORT_NUM NUMBER(10),
- TENANT_ID NUMBER(20),
+ TENANT_ID VARCHAR2(20) default '000000'
CREATE_DEPT NUMBER(20),
CREATE_BY NUMBER(20),
CREATE_TIME DATE,
diff --git a/script/sql/postgres/flowable.sql b/script/sql/postgres/flowable.sql
index aa68592..1b7ae94 100644
--- a/script/sql/postgres/flowable.sql
+++ b/script/sql/postgres/flowable.sql
@@ -35,7 +35,7 @@
create_time timestamp,
update_by bigint,
update_time timestamp,
- tenant_id varchar(20)
+ tenant_id varchar(20) default '000000'::varchar
);
comment on table test_leave is '璇峰亣鐢宠琛�';
@@ -76,7 +76,7 @@
category_code varchar(255),
parent_id bigint,
sort_num bigint,
- tenant_id bigint,
+ tenant_id varchar(20) default '000000'::varchar,
create_dept bigint,
create_by bigint,
create_time timestamp,
--
Gitblit v1.9.3